n8n Lead List Cleaner: Deduplicate & Export Review CSV

Clean, deduplicate, and review your lead list in minutes—export a ready-to-check CSV

n8n Lead List Cleaner: Deduplicate & Export Review CSV takes a JSON lead list, normalizes key fields, flags duplicates, and produces a downloadable clean-leads.csv with an accepted / duplicate / review status for every record. No guesswork—just a clear review trail you can act on.

What this workflow does

• Runs manually to process your sample input or your edited lead list.
• Validates input: checks that you provide 1–5000 lead records and that deduplication mode is set to email or domain.
• Normalizes each lead: trims text, lowercases emails, extracts a website hostname as a domain, and performs basic email syntax validation.
• Classifies results per row:
  • Accepted when fields look valid and the email/domain hasn’t appeared earlier in the run.
  • Duplicate when the normalized email or exact domain already exists in the current run (and includes the `row number` of the original record).
  • Review when required information is missing or invalid (e.g., basic email syntax fails).
• Exports a CSV review file containing status and reason for each row.

Use cases

• Pre-processing leads before importing them into your CRM or outreach tool.
• Detecting duplicate companies quickly using email or domain deduplication.
• Creating an auditable “needs review” list when emails are malformed or data is incomplete.

Technical details

• Manual Trigger workflow execution
• Uses built-in n8n nodes: set, code, sticky note, convert to file
• No credentials, API services, or external accounts required
• Processes 1–5000 records per run and downloads clean-leads.csv from the final CSV export step

Best for: n8n users, automation engineers, and SaaS operators who need reliable lead list deduplication and review-ready exports.