🧼 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
