Validate email lists weekly with Google Sheets, VerifiEmail and Gmail reports
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This workflow has 12 nodes and runs on a schedule (cron 0 17 * * 5). Along the way it connects Google Sheets, Gmail and Verifiemail (community).
How it runs
Trigger: On a schedule (cron 0 17 * * 5).
- Read Email List (Google Sheets): uses Google Sheets
- Process Each Email (Loop Over Items (Split in Batches)): loops over the items in batches
- Calculate Statistics (Code): runs custom JavaScript code
- Validate Email Address (Verifi Email): uses Verifi Email
- Send Weekly Report (Gmail): uses Gmail
- Check Validation Result (If): checks a condition and branches into true / false
- Process Valid Email (Code): runs custom JavaScript code
- Process Invalid Email (Code): runs custom JavaScript code
- Update Valid Status (Google Sheets): update
- Update Invalid Status (Google Sheets): update
…plus 1 more step. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-verifiemail is verified or supports 3.0 (used in Validate Email Address).
Nodes used (8)
- Code
n8n-nodes-base.code - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Verifi Email
n8n-nodes-verifiemail.verifiEmail - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail - Merge
n8n-nodes-base.merge
From the author
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.…