Batch verify email leads from Google Sheets with Rapid Email Verifier
Go to WorkflowDescription
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
Reads emails from an input Google Sheet (one email per row).
Splits the list into configurable batches.
Builds a JSON payload for each batch (use a Set node named Build Payload to create { "emails": [...] }), then waits briefly to avoid rate limits.
Sends each batch to the Rapid Email Verifier batch endpoint.
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.