Bulk lead email validation with Google Sheets & Anymail Finder
Ready for 3.0What this workflow does
This workflow has 5 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets. 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
- Check email status (HTTP Request): calls api.anymailfinder.com (POST)
- Update email status (Google Sheets): update
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 (4)
- Manual Trigger
n8n-nodes-base.manualTrigger - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - HTTP Request
n8n-nodes-base.httpRequest
From the author
This workflow automates the process of validating email addresses stored in a Google Sheets file by using the Anymail Finder API. --- Key Advantages ✅ Automated Lead Validation No need for manual copy-paste or bulk uploads emails are verified directly inside…