Fetch and enrich Apollo leads and sync verified contacts to MeldFlow/GHL
Ready for 3.0What this workflow does
This workflow has 12 nodes and runs on a schedule (cron =0 8 * * 1-5). Along the way it connects Google Sheets. It also calls api.apollo.io and services.leadconnectorhq.com over HTTP.
How it runs
Trigger: On a schedule (cron =0 8 * * 1-5).
- Get Apollo Page (Google Sheets): uses Google Sheets
- Apollo lead search (HTTP Request): calls api.apollo.io (POST)
- Extract ID (Code): runs custom JavaScript code
- Loop Over for batching limit (Loop Over Items (Split in Batches)): loops over the items in batches
- Data Filtering & Formatting (Edit Fields (Set)): sets 15 fields: id, firstName, lastName…
- Apollo-Enrichment (HTTP Request): calls api.apollo.io (POST)
- If: checks a condition and branches into true / false
- Wait: pauses before continuing
- Meldflow-Contacts (HTTP Request): calls services.leadconnectorhq.com (POST)
- Wait: waits 2 minutes
…plus 1 more step. See the full node list below.
Services it uses
HTTP calls to: api.apollo.io, services.leadconnectorhq.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 (8)
- If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - HTTP Request
n8n-nodes-base.httpRequest - Wait
n8n-nodes-base.wait - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code
From the author
Apollo Leads Enrichment & MeldFlow/GHL Sync How It Works 1. Pulls targeted leads from Apollo using predefined ICP filters 2. Enriches each lead with Apollo people enrichment 3. Filters verified contacts and formats lead data 4. Creates or updates contacts…