Automate personalized cold emails with Apollo lead scraping and GPT-4.1
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 16 nodes and runs manually, when you click “Execute workflow”. Along the way it connects OpenAI, Google Sheets and Slack.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Create spreadsheet (Google Sheets): work with spreadsheet
- EDIT Apollo URL + Amount (Edit Fields (Set)): sets 2 fields: Apollo URL, Amount to Scrape
- Call Apify Scraper (HTTP Request): calls an HTTP API (POST)
- Receive Scraper's Data (HTTP Request): calls an HTTP API
- Filter: keeps only the items that match a condition
- Keep Fields (Edit Fields (Set)): sets 6 fields: first_name, last_name, email…
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Send a message (Slack): uses Slack
- Crawl Website Content (HTTP Request): calls an HTTP API
- HTTP -> Plain Text (Code): runs custom JavaScript code
…plus 5 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 (9)
- OpenAI
@n8n/n8n-nodes-langchain.openAi - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Manual Trigger
n8n-nodes-base.manualTrigger - Google Sheets
n8n-nodes-base.googleSheets - Edit Fields (Set)
n8n-nodes-base.set - Filter
n8n-nodes-base.filter - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Slack
n8n-nodes-base.slack
From the author
How This Works - This automation automatically scrapes leads from Apollo using the Apify scraper, filters out those who do not have an Email or URL included, scrapes the leads' website content and writes personalised Icebreakers and subject lines based on the…