Automate email discovery for companies with Anymail Finder, Google Sheets & Telegram alerts
Ready for 3.0What this workflow does
This workflow has 8 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets and Telegram. It also calls api.anymailfinder.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get Leads (Google Sheets): uses Google Sheets
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Email finder (HTTP Request): calls api.anymailfinder.com (POST)
- Switch: routes items into 3 branches
- Email found (Google Sheets): update
- Email not found (Google Sheets): update
- Send Alert (Telegram): uses Telegram
Services it uses
HTTP calls to: api.anymailfinder.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 (6)
- Manual Trigger
n8n-nodes-base.manualTrigger - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Switch
n8n-nodes-base.switch - HTTP Request
n8n-nodes-base.httpRequest - Telegram
n8n-nodes-base.telegram
From the author
This automation retrieves company information from a Google Sheet, uses the Anymail Finder API to discover email addresses associated with each company, and then writes the results (including the email status) back into the same Google Sheet and send alert on…