Every lead list I've seen has the same problems: JOHN SMITH next to john smith, jane@gmial.com, three copies of the same person from three different CSV exports, and a pile of info@ addresses nobody will ever answer.
Cleaning that by hand is slow, and sending to it hurts your sender reputation. So I built a small n8n workflow that does it in one run, and I'm giving it away.
What it does
- Fixes names:
JOHN SMITH→John Smith,mary o'brien→Mary O'Brien, keepsvan der BergandMcDonaldright, drops titles likeDr., and splits full names into first and last. - Repairs emails: strips
mailto:, spaces and stray;, fixes common domain typos (gmial.com,hotmial.com,yahoo.con) and checks the syntax. - Classifies every address: business, free-mail, role (
info@,sales@) or disposable. - Finds the company domain from the website column, or from a business email when there's no website.
- Merges duplicates: same mailbox (case,
+tagsand Gmail dots ignored), or same name plus company. The first row wins, and empty fields are filled from its duplicates. - Marks each row
readyorreview, with readableissuesandfixescolumns, and returns a summary with the counts.
It reads from Google Sheets or a CSV file. In Sheets mode it upserts on a stable key, so re-running it updates rows instead of adding duplicates.
Try it in 30 seconds
The workflow ships in test mode with 12 deliberately messy sample rows. Import the JSON, click Execute workflow, and you'll see 9 clean rows come out (3 duplicates merged) plus the summary. No credentials needed.
Then switch source to csv or google_sheets in the Cleaner settings node and point it at your own list.
How it's built
No external libraries and no AI calls. Two Code nodes do the work in plain JavaScript: one normalizes and validates each row, the other groups duplicates and merges them. The rest is n8n's own nodes for reading and writing CSV and Sheets. That keeps it fast, free to run, and easy to read if you want to change a rule.
Get it
- GitHub (free, with setup notes): https://github.com/Relaybrook/n8n-free-workflows
- n8n Basket: https://n8nbasket.com/workflow/a6f9e7fd-0fac-4f56-997d-563b1ecda1aa
If you find a name or email pattern it gets wrong, open an issue on GitHub and I'll add it.
Disclosure: I run Relaybrook, which also sells paid n8n packs (lead enrichment, inbox triage, content repurposing) at https://relaybrook.bytesell.app. This workflow is free and works on its own.
Launch offer: the store takes crypto (USDT, USDC, BTC, ETH, SOL and more), and code CRYPTO10 gives 10% off every pack until Nov 30, 2026.
n8n is a trademark of n8n GmbH. Relaybrook is not affiliated with n8n.


