Email List Validation and Cleanup with Google Sheets and VerifiEmail

Description

🧼 Email Subscription Cleaner

A fully automated workflow that cleans, validates, and restructures your subscriber list using Google Sheets and VerifiEmail. Perfect for marketers, SaaS teams, or anyone maintaining an email database.

🚀 What This Workflow Does

In one automated run, it:

Accepts a cleaning request via Webhook
Extracts list settings, preferences, and options
Fetches all subscribers from Google Sheets
Normalizes emails and formats subscriber fields
Performs real-time verification using VerifiEmail
Classifies each subscriber as:
remove (invalid / disposable / role),
keep (valid & safe),
tag (special cases)
Deletes bad emails directly from the source sheet
Stores all valid emails in a clean, curated CleanSubscribers sheet
Returns a structured JSON summary to the caller

🔍 Why This Template Is Useful

Improves deliverability
Removes spam traps, bots, disposable domains
Cleans and reorganizes messy lists
Reduces bounce rates
Builds a healthier mailing list for campaigns
No CSV download/upload required — runs directly on Google Sheets

🧠 How It Works (In Simple Steps)

Webhook receives batch-clean request
Extract Inputs parses settings (listId, priority, options)
Fetch Subscribers reads rows from Google Sheets
Normalize each subscriber’s fields
Validate Email quality (MX check, disposable, provider data)
Merge subscriber info + validation results
Classify each subscriber into keep/remove/tag
Clean Up:

remove → deletes the row
keep → appends to clean list
Respond with a clean JSON summary

Fast, simple, reliable — perfect for weekly or on-demand cleanup.

🔧 Setup Required

Connect 2 credentials:

Google Sheets** (read / delete / append)
VerifiEmail** (API key)

Update:

Sheet name (SubscriberList)
Clean list sheet (CleanSubscribers)
Optional tag rules in “Classify Email”

No other configuration needed.

🏁 Perfect For

Newsletters
Marketing teams
Event lists
SaaS mailing lists
CRM cleanup
Lead verification
Removing dead/invalid emails automatically

🏷️ Tags

email, cleanup, validation, google-sheets, verifiemail, marketing, automation, list-cleaner, webhook