AI-powered lead generation with Apollo, LinkedIn research & 4-step personalized emails
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 25 nodes and runs when someone submits an n8n form (plus 1 other trigger). Along the way it connects Google Sheets and OpenAI.
How it runs
Trigger: When someone submits an n8n form (plus 1 other trigger).
- Generate Query (Edit Fields (Set)): sets or maps fields
- Get Prospects (Google Sheets): uses Google Sheets
- Create Apollo URL (Code): runs custom JavaScript code
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Apollo Scraper (HTTP Request): calls an HTTP API
- If: checks a condition and branches into true / false
- Extract Info (Edit Fields (Set)): sets or maps fields
- Linkedin Scraper (HTTP Request): calls an HTTP API
- Filter: keeps only the items that match a condition
- Edit Fields (Edit Fields (Set)): sets or maps fields
…plus 13 more steps. See the full node list below.
Services it uses
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.
- Still check Always Output Data on multi-output nodes (If/Switch) now adds an empty item only when every output is empty (If Linkedin Exists?).
Nodes used (10)
- Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - Filter
n8n-nodes-base.filter - Google Sheets
n8n-nodes-base.googleSheets - HTTP Request
n8n-nodes-base.httpRequest - OpenAI
@n8n/n8n-nodes-langchain.openAi - Schedule Trigger
n8n-nodes-base.scheduleTrigger - If
n8n-nodes-base.if - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - n8n Form Trigger
n8n-nodes-base.formTrigger
From the author
Overview This workflow finds potential customers, gathers detailed info about them and their companies, and then uses AI to research them in detail and write personalized messages for LinkedIn and a series of four cold emails. All this data is organized in…