workflows.fit
Back to n8n workflows
n8n templateFreeBy Arnav Tiwary

Batch verify email leads from Google Sheets with Rapid Email Verifier

Who’s it for Teams and solo founders who keep lead lists in Google Sheets and want a fast, free and repeatable way to validate email deliverability before outreach. Ideal for sales, growth, recruiting, and ops teams w...

Data & StorageProductivityDevelopmentCore NodesFilterSticky NoteManual TriggerGoogle Sheets
Loading interactive preview...

Template notes

Who’s it for Teams and solo founders who keep lead lists in Google Sheets and want a fast, free and repeatable way to validate email deliverability before outreach. Ideal for sales, growth, recruiting, and ops teams who want to reduce bounces and protect sender reputation.

How it works / What it does 1. Reads emails from an input Google Sheet (one email per row). 2. Splits the list into configurable batches. 3. Builds a JSON payload for each batch (use a Set node named Build Payload to create { "emails": [...] }), then waits briefly to avoid rate limits. 4. Sends each batch to the Rapid Email Verifier batch endpoint. 5. Optionally filters results by score (default >75) and appends verified addresses plus metadata (score, disposable, domain/mailbox checks) to an output sheet.

How to set up - Create a Google Sheets OAuth credential in n8n and point the Get / Append nodes to your Document ID and Sheet/GID (use placeholders in the template — do not ship real IDs). - No API key is required for the Rapid Email Verifier demo endpoint; simply POST { "emails": [...] }. - Configure batch size (default 20), Wait delay (e.g., 5s), and Filter score threshold, then test with a small sample.

Requirements - n8n (cloud or self-hosted) - Google Sheets OAuth credential

How to customize - Adjust batch size (up to 100) or score threshold; change which columns are written to the output sheet; add error-handling or notifications for failed requests.