Score and enrich B2B leads with Apollo Official API and 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 11 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Set Apollo Search Parameters (Edit Fields (Set)): sets or maps fields
- Compile Apollo Search Data (Code): runs custom JavaScript code
- Post to Apollo Search API (HTTP Request): calls an HTTP API
- Analyze and Rank Prospects (Code): runs custom JavaScript code
- Preview Qualified Prospects (Code): runs custom JavaScript code
- Prepare Candidates for Enrichment (Code): runs custom JavaScript code
- Post to Apollo Enrichment API (HTTP Request): calls an HTTP API
- Process Enrichment Results (Code): runs custom JavaScript code
- Deduplicate Enriched Leads (Remove Duplicates): removes duplicate items
- Append Leads to Sheets (Google Sheets): uses Google Sheets
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 (6)
- Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Remove Duplicates
n8n-nodes-base.removeDuplicates - Google Sheets
n8n-nodes-base.googleSheets
From the author
Quick overview This workflow runs on demand to search for B2B prospects using the Apollo Official API, scores and shortlists results, optionally enriches the top candidates, and appends deduplicated leads to a Google Sheets spreadsheet. How it works 1. Runs…