Generate personalized sales emails with LinkedIn data & Claude 3.7 via OpenRouter
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 19 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets, OpenRouter Chat Model and Gmail. It also calls api.apify.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get Leads (Google Sheets): uses Google Sheets
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Google Search for Person LinkedIn (HTTP Request): calls api.apify.com (POST)
- Only People Links (Filter): keeps only the items that match a condition
- Aggregate: combines items into one
- Get LinkedIn Person (HTTP Request): calls api.apify.com (POST)
- Current Company Exists? (If): checks a condition and branches into true / false
- Set Company URL (Edit Fields (Set)): sets or maps fields
- Google Search for Company LinkedIn (HTTP Request): calls api.apify.com (POST)
- Get LinkedIn Company (HTTP Request): calls api.apify.com (POST)
…plus 6 more steps. See the full node list below.
Services it uses
HTTP calls to: api.apify.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (12)
- Manual Trigger
n8n-nodes-base.manualTrigger - Aggregate
n8n-nodes-base.aggregate - Filter
n8n-nodes-base.filter - HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - Edit Fields (Set)
n8n-nodes-base.set - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - OpenRouter Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenRouter - Gmail
n8n-nodes-base.gmail - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches
From the author
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…