Discover & enrich decision-makers with Apollo and human verification
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 25 nodes and runs on Google Sheets events (plus 1 other trigger). Along the way it connects Google Sheets, OpenAI and Slack. It also calls api.apollo.io over HTTP.
How it runs
Trigger: On Google Sheets events (plus 1 other trigger).
- Select Unprocessed Companies (Filter): keeps only the items that match a condition
- Retrieve Verified Leads (Google Sheets): uses Google Sheets
- Is Domain Already Provided? (If): checks a condition and branches into true / false
- Derive Past Week's Lead Gen. Metrics (Code): runs custom JavaScript code
- Merge: merges the data from its input branches
- Apollo Organization Search (HTTP Request): calls api.apollo.io (POST)
- Send Weekly Report (Slack): uses Slack
- Apollo Organization Enrichment (HTTP Request): calls api.apollo.io
- Add Company Website (Google Sheets): append or update
- Summarize Core Business (OpenAI): uses OpenAI
…plus 13 more steps. See the full node list below.
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 (12)
- Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Google Sheets
n8n-nodes-base.googleSheets - OpenAI
@n8n/n8n-nodes-langchain.openAi - Slack
n8n-nodes-base.slack - Filter
n8n-nodes-base.filter - If
n8n-nodes-base.if - Split Out
n8n-nodes-base.splitOut - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Merge
n8n-nodes-base.merge
From the author
🧩 What This Workflow Does This workflow automates the process of identifying and enriching decision-maker contacts from a list of companies. By integrating with Apollo's APIs and Google Sheets, it streamlines lead generation, ensures data accuracy through…