Automated Email Validation for Google Sheets Using Rapid Email Verifier

# **Automated Email Verification for Google Sheets** This n8n template demonstrates how to automatically validate email addresses from your Google Sheets using a reliable email verification API. Perfect for cleaning contact lists, validating leads, and ensuring email deliverability before marketing campaigns. Use cases are many: Lead qualification for sales teams, contact list cleaning for marketing, subscriber validation for newsletters, or CRM data hygiene maintenance! ## **Good to know** - The rapid-email-verifier API is free for up to 1,000 verifications per month. - Each email verification typically takes less than 500ms to complete. - The workflow runs automatically every hour, checking for new entries. - Only processes emails that haven't been verified yet, preventing duplicate API calls. ## **How it works** 1. **Monitor Google Sheets**: The trigger watches your spreadsheet for new email entries every hour. 2. **Smart Filtering**: Only emails with empty Email Verified columns are processed to avoid duplicates. 3. **Batch Processing**: Emails are processed one by one to respect API rate limits and ensure reliability. 4. **API Verification**: Each email is sent to the rapid-email-verifier service which returns validation status. 5. **Results Update**: The original sheet is updated with verification results (valid/invalid/unknown) using the Serial Number as a match key. The verification accuracy is consistently above 95% and shows excellent detection of invalid, disposable, and risky email addresses! ## **How to use** 1. The Google Sheets trigger monitors your spreadsheet automatically, but you can also test manually. 2. Simply add new rows with email addresses to your connected Google Sheet. 3. Leave the Email Verified column empty for new entries. 4. The workflow will automatically process and update the verification status. Technically, you can process unlimited emails, but consider API rate limits and costs for large batches. ## **Requirements** - **Google Sheets account** with a spreadsheet containing columns: SrNo, Name, Email, Email Verified. - **Google Sheets credentials** configured in n8n for both trigger and update operations. - **Internet connection** for API access (no additional API key required for rapid-email-verifier). ## **Customizing this workflow** Email verification can be enhanced for many use-cases: - **Add webhook trigger** for real-time verification when leads are captured. - **Connect to CRM systems** like HubSpot or Salesforce for direct integration. - **Add email categorization** to separate personal vs business emails. - **Include bounce detection** by connecting to your email service provider. - **Set up notifications** to alert when invalid emails are detected in important lists. This template is perfect for marketing managers, sales professionals, data analysts, and anyone managing contact databases who needs reliable email validation!

Platform

n8n

Category

Marketing

Price

Free

Creator

Gaurav

• filter
• stickyNote
• httpRequest
• googleSheets
• splitInBatches
• googleSheetsTrigger