Smart Email List Cleaner – Google Sheets & Hunter.io

📌 Overview

This workflow automates the cleaning and validation of email lists stored in Google Sheets. It validates email format, removes duplicates, verifies deliverability with Hunter.io, and deletes invalid or inactive emails directly from the sheet. This ensures your mailing lists remain accurate, reliable, and ready for campaigns.

Category: Data Management / Marketing AutomationTrigger: Manual execution (workflow runs only when executed manually in n8n).

⚙️ Workflow Steps

1. Manual Trigger
2. • Workflow starts only when you manually click Execute Workflow in n8n.
3. Get List of Emails (Google Sheets)
4. • Fetches all email addresses from the specified Google Sheet (Email tab).
5. Code (Validation & Deduplication)
6. • Trims whitespace, validates email format with regex.
   • Flags duplicates as "Duplicate" and invalid formats as "Invalid".
   • Marks unique, correctly formatted emails as "Valid".
7. If Email is Valid
8. • Branches email records:
   • • Valid → Keeps the email.
     • Invalid/Duplicate → Moves to deletion flow.
9. Sort Rows in Descending Order (Google Sheets)
10. • Orders rows from bottom to top to prevent row shifting issues when deleting.
11. Delete Invalid Emails (Google Sheets)
12. • Removes all rows flagged as invalid or duplicate from the Email sheet.
13. Verify Email with Hunter.io
14. • Sends remaining emails to Hunter Email Verifier API.
    • Returns deliverability status (valid, invalid, inactive).
15. If Email is Active
16. • Keeps emails flagged as valid.
    • Routes invalid/inactive emails to be removed.
17. Get Invalid/Inactive Email (Google Sheets)
18. • Finds the exact row number of the inactive or invalid email in the sheet.
19. Sort Rows in Descending Order
20. • Ensures deletions start from bottom to avoid misalignment.
21. Delete Invalid/Inactive Emails (Google Sheets)
22. • Removes all rows with inactive or invalid emails.

✅ End result: Only valid, unique, and active emails remain in your Google Sheet.

🗂️ Data Sources

• Google Sheets: Stores email lists and logs cleaned data.
• Hunter.io: Validates email deliverability status.
• n8n: Automates cleaning, deduplication, and validation workflow.

✅ Key Benefits

• Removes invalid and duplicate emails automatically.
• Ensures mailing lists are up-to-date and campaign-ready.
• Improves email deliverability by keeping only active addresses.
• Saves time compared to manual list cleanup.