Enrich and verify partnership leads from Google Sheets with Apollo and Instantly

by Atharva Ashtekar ✓ · 2 views · created 2026-09-21 · Lead Generation, AI Summarization

What this workflow does

This workflow has 42 nodes and runs on a schedule (cron 0 7 * * 1-5) (plus 1 other trigger). Along the way it connects Google Sheets.

How it runs

Trigger: On a schedule (cron 0 7 * * 1-5) (plus 1 other trigger).

1. config (Code): runs custom JavaScript code
2. [cred] Sheets - read the raw list (Google Sheets): uses Google Sheets
3. pick this run's batch (Code): runs custom JavaScript code
4. anything to enrich? (If): checks a condition and branches into true / false
5. normalise the organisation (Code): runs custom JavaScript code
6. STOP: nothing to enrich (Code): runs custom JavaScript code
7. AI classification needed? (If): checks a condition and branches into true / false
8. AI - classify the organisation (HTTP Request): calls an HTTP API (POST)
9. STOP: keyword rules only (Code): runs custom JavaScript code
10. apply the AI classification (Code): runs custom JavaScript code

…plus 28 more steps. See the full node list below.

Services it uses

Google Sheets

Before you upgrade to n8n 3.0

Nodes used (8)

• Manual Triggern8n-nodes-base.manualTrigger
• Schedule Triggern8n-nodes-base.scheduleTrigger
• Coden8n-nodes-base.code
• Google Sheetsn8n-nodes-base.googleSheets
• Ifn8n-nodes-base.if
• HTTP Requestn8n-nodes-base.httpRequest
• Mergen8n-nodes-base.merge
• No Operation, do nothingn8n-nodes-base.noOp

From the author

Quick overview This workflow runs every weekday and processes a batch of organisations from Google Sheets, optionally classifying them with Anthropic, finding contacts via Apollo, and verifying emails via MillionVerifier. It writes outcomes back to Google…

View the original on n8n.io → Check your own copy