AlekSystem Workflow Detail

AI-Powered Personalized Sales Emails with LinkedIn Data & Claude 3.7 via OpenRouter Generation

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

How it works The automation loads rows from a Google Sheet of leads that you want to contact.

Rank 69 Verified workflow

Workflow overview

Why this workflow matters

Helpful for business development and pipeline building. Relevant for managed services and support workflows.

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.

Best fit

Categories

AI/MLCommunicationSales

Services

Google SheetsGmailBasic LLM ChainStructured Output ParserOpenRouter Chat Model

Use cases

sales automationemail workflow automation