Automate lead generation with Apollo, AI parsing, and timed email follow-ups
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 37 nodes and runs manually, when you click “Execute workflow” (plus 3 other triggers). Along the way it connects Google Sheets, OpenAI Chat Model and Gmail. It also calls api.apify.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 3 other triggers).
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- Apollo URL Generator (Basic LLM Chain): sends a prompt to an LLM, with model: OpenAI Chat Model
- Delay generator (Code): runs custom JavaScript code
- Delay generator (Code): runs custom JavaScript code
- proper json (Code): runs custom JavaScript code
- Run Apify (HTTP Request): calls api.apify.com (POST)
- Wait: pauses before continuing
- Wait: pauses before continuing
- Parse Lead Data (Basic LLM Chain): sends a prompt to an LLM, with model: OpenAI Chat Model; output parser: Structured Output Parser
- Parse Lead Data (Basic LLM Chain): sends a prompt to an LLM, with model: OpenAI Chat Model; output parser: Structured Output Parser
…plus 16 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 (15)
- Wait
n8n-nodes-base.wait - Google Sheets
n8n-nodes-base.googleSheets - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Gmail
n8n-nodes-base.gmail - Limit
n8n-nodes-base.limit - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Manual Trigger
n8n-nodes-base.manualTrigger - n8n Form Trigger
n8n-nodes-base.formTrigger - HTTP Request
n8n-nodes-base.httpRequest - Schedule Trigger
n8n-nodes-base.scheduleTrigger - If
n8n-nodes-base.if - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Code
n8n-nodes-base.code
From the author
Good to know: - The workflow runs every hour with a randomized delay of 5–20 minutes to help distribute load. - It records the exact date and time a lead is emailed so you can track outreach. - Follow-ups are automatically scheduled two days after the initial…