Validate email lists weekly with Google Sheets, VerifiEmail and Gmail reports

Email List Hygiene - Automated Weekly Validator

Overview

Validates email lists through automated checks, categorizes results as Valid/Invalid/Risky, updates Google Sheets in real-time, and delivers HTML reports. Runs every Friday at 5 PM via cron scheduling.

---

Workflow Architecture

Schedule Trigger → Read Google Sheets → Loop (Process Each Email) → Validate API → IF Branch (Valid/Invalid) → Update Google Sheets → Merge → Loop Back → Calculate Statistics → Send Email Report

Loop Mechanism - Split in Batches processes one email at a time - Each email: validate → branch → update sheet → merge → continue - Loop accumulates all results internally - "Done" output triggers statistics calculation after all emails processed

Health Score Formula