Extract leads from an Apollo search URL into Google Sheets
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 workflow has 10 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets. It also calls api.apollo.io over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Apollo Search Input (Edit Fields (Set)): sets 2 fields: url, start_page
- Build API Filters (Code): runs custom JavaScript code
- Fetch Leads (Apollo) (HTTP Request): calls api.apollo.io (POST)
- Extract People (Code): runs custom JavaScript code
- Extract Pagination Info (Edit Fields (Set)): sets 2 fields: current_page, total_pages
- Write to Google Sheets (Google Sheets): append
- Has More Pages? (If): checks a condition and branches into true / false
- Increment Page (Edit Fields (Set)): sets 2 fields: current_page, base_filters
- Rate Limit Delay (Wait): waits 2 seconds
Services it uses
HTTP calls to: api.apollo.io
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 (7)
- Manual Trigger
n8n-nodes-base.manualTrigger - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Edit Fields (Set)
n8n-nodes-base.set - Wait
n8n-nodes-base.wait - If
n8n-nodes-base.if - HTTP Request
n8n-nodes-base.httpRequest
From the author
Stop manually downloading CSVs or risking account bans with sketchy UI scrapers! This workflow bridges the gap between Apollo.io's powerful search filters and your Google Sheets database using Apollo's official REST API. Perfect for Sales Development Reps…