Personalized sales outreach with Apollo, GPT, and Gmail automation
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 28 nodes and runs on a schedule (every day) (plus 2 other triggers). Along the way it connects OpenAI Chat Model, Google Sheets, Google Drive and OpenAI and 2 more.
How it runs
Trigger: On a schedule (every day) (plus 2 other triggers).
- Scraping setup (Edit Fields (Set)): sets 3 fields: Apify Api key, leadSheetID, leadsSheetTabName
- Lead setup (Edit Fields (Set)): sets 5 fields: leadSheetID, leadsSheetTabName, serviceDocId…
- Email setup (Edit Fields (Set)): sets 4 fields: leadSheetID, leadsSheetTabName, brand_name…
- setICP (Edit Fields (Set)): sets 2 fields: Position, Location (country)
- getLeads (Google Sheets): uses Google Sheets
- Get approved leads (Google Sheets): uses Google Sheets
- copyTable (Google Drive): copy
- Limit: keeps the first few items
- Loop Approved Emails (Loop Over Items (Split in Batches)): loops over the items in batches
- urlGenerator (Basic LLM Chain): sends a prompt to an LLM, with model: OpenAI Chat Model
…plus 14 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.
Nodes used (13)
- OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Google Drive
n8n-nodes-base.googleDrive - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Edit Fields (Set)
n8n-nodes-base.set - OpenAI
@n8n/n8n-nodes-langchain.openAi - Gmail
n8n-nodes-base.gmail - Limit
n8n-nodes-base.limit - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Docs
n8n-nodes-base.googleDocs
From the author
This n8n template shows you how to turn outbound sales into a fully automated machine: scrape verified leads, research them with AI, and fire off personalized cold emails while you sleep. Use cases are simple: scale B2B lead gen without hiring more SDRs, run…