1. Automated Email Validation for Google Sheets using Rapid Email Verifier

Level up your email deliverability with a complete n8n workflow that reads contacts from Google Sheets and verifies them using Rapid Email Verifier. I show the full build, from secure API integration and batching to writing back validated results, so you can clean large lists reliably while respecting rate limits.

Workflow - https://n8n.io/workflows/6521-automat...

What you’ll learn:
Connecting Google Sheets to read emails and write back results
Securing and using Rapid Email Verifier API credentials in n8n
Syntax checks, disposable and role-based detection, and risk scoring
Batch processing with Split In Batches, rate limiting, and retries
Robust error handling with IF/Switch paths and fallback logic
De-duplication to avoid re-verifying previously checked emails
Mapping and normalizing outputs for clear statuses and reasons
Updating rows with deliverability outcomes and suggested fixes

Workflow overview (nodes):
Trigger (Manual/Cron)
Google Sheets (Read/Append/Update)
HTTP Request (Rapid Email Verifier)
Set, IF, Switch
Split In Batches, Merge
Function (optional) for transformations

Output fields you can store:
email, status (valid/invalid/risky/unknown), reason_code, is_disposable, is_role, mx_found, suggestion, verified_at

Use cases:
Lead qualification for sales teams
Marketing list cleaning before campaigns
Newsletter subscriber validation
CRM data hygiene and ongoing maintenance

Prerequisites:
n8n (cloud or self-hosted)
Rapid Email Verifier API key
Google Sheet with an Email column and service account credentials

If this helped, please like the video, drop your questions in the comments, and subscribe for more automation tutorials. The workflow template is referenced in the video resources.