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. - 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 d
At a glance
Generate personalized sales emails with LinkedIn data & Claude 3.7 via OpenRouter is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Gmail, Google Sheets, LinkedIn. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Gmail, Google Sheets, LinkedIn
- Modules
- 19
- Price
- Free
- Version
- v1.0

About this workflow
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.
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
🚀 Automated Stripe payment recovery: track failures & follow-up emails
Track new YouTube videos with custom search criteria and save to Google Sheets
Generate consistent styled images from references with Google Gemini and Sheets
Create .SRT subtitles & .LRC lyrics from audio with Whisper AI and GPT-5-nano
Generate visual summary & knowledge graph insights for your email
Automated customer feedback analysis & response with Jotform, GPT-4.1 & Google Sheets
Generate and Send Personalized Quotations PDF
Automate Cal.com meeting attendee management with Google Sheets, Beehiiv & Telegram
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you