Apollo data enrichment using Company Id, Google Sheets & Telegram
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 19 nodes and runs when an HTTP GET request hits its webhook URL (plus 2 other triggers). Along the way it connects Google Sheets and Telegram.
How it runs
Trigger: When an HTTP GET request hits its webhook URL (plus 2 other triggers).
- Save Lead Phone to Sheet (Google Sheets): uses Google Sheets
- Format Error Message (Code): runs custom JavaScript code
- Get Apollo Company ID (Google Sheets): uses Google Sheets
- Notify: Success (Telegram): uses Telegram
- Send Alert to Telegram (Telegram): uses Telegram
- Define Search Settings (Edit Fields (Set)): sets or maps fields
- Build Search Filters (Code): runs custom JavaScript code
- Search People in Apollo (HTTP Request): calls an HTTP API
- Check if Any People Found (If): checks a condition and branches into true / false
- Process Each Person One by One (Split Out): splits a list into separate items
…plus 6 more steps. See the full node list below.
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 (11)
- Google Sheets
n8n-nodes-base.googleSheets - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if - Split Out
n8n-nodes-base.splitOut - Wait
n8n-nodes-base.wait - Error Trigger
n8n-nodes-base.errorTrigger - Telegram
n8n-nodes-base.telegram - Webhook
n8n-nodes-base.webhook
From the author
Apollo Data Enrichment Using Company Id to automatically finds contacts for companies listed in your Google Sheet, enriches each person with emails and phone numbers via Apollo’s API, and writes verified contacts back to your procurement sheet while notifying…