Back to Templates

Generate Personalized Sales Emails with LinkedIn Data & Claude 3.7 via OpenRouter

Created by

Created by: Adam Janes || adamjanes

Adam Janes

Last update

Last update 8 hours ago

Share


How it works

  • The automation loads rows from a Google Sheet of leads that you want to contact.
  • It makes a Google search via Apify for LinkedIn links based on the First name / Last name / Company.
  • Another Apify actor fetches the right LinkedIn profile based on the first profile which is retuned
  • The same process is done for the company that the lead works for, giving extra context. If the lead has a current company listed on their LinkedIn, we use that URL to do the lookup, rather than doing a separate Google search.
  • A call is made to OpenRouter to get an LLM to generate an email based on a prompt designed to do personalized outreach.
  • An email is sent via a Gmail node.

Set up steps

  • Connect your Google Sheets + Gmail accounts to use these APIs.
  • Make an account with Apify and enter your credentials.
  • Set your details in the "Set My Data" node to customize the workflow to revolve around your company + value proposition.

I would recommend changing the prompt in the "Generate Personalized Email" node to match the tone of voice that you want your agent to have.

You can change the guidelines to e.g. change whether the agent introduces itself, and give more examples in the style you want to make the output better.