workflows.fit
Back to n8n workflows
n8n templateFreeBy Alex

Validate bulk email addresses in Google Sheets with Verify Email

📧 Google Sheets Bulk Email Validator Automatically validate email addresses in Google Sheets using Verify Email This workflow scans your Google Sheets weekly (configurable), finds unverified email addresses, and vali...

Data & StorageProductivityDevelopmentCore NodesSticky NoteSchedule TriggerGoogle SheetsCode
Loading interactive preview...

Template notes

📧 Google Sheets Bulk Email Validator

Automatically validate email addresses in Google Sheets using Verify Email

This workflow scans your Google Sheets weekly (configurable), finds unverified email addresses, and validates them through the Verify Email API. Results are automatically added back to your spreadsheet

📋 How It Works

1. Reads all email addresses from your Google Sheets 2. Validates email addresses that haven't been verified yet (Status column is empty) 3. Writes results — Valid or Block with the reason for blocking

🔧 Required Google Sheets Setup

Your Google Sheet MUST have these column headers in Row 1:

| Column | Header | Content | |--------|--------|---------| | A | Email | Email addresses to validate | | B | Status | Validation result: Valid or Block | | C | Reason | Block reason: Invalid, Blacklisted, Disposable |