All projects · Automation & Data Pipelines
Customer Duplicate Detector
On a manual run, generates a sample list of six customer records, normalizes each email and phone number, detects duplicates by matching…
On a manual run, generates a sample list of six customer records, normalizes each email and phone number, detects duplicates by matching normalized email OR phone against already-seen values, and builds a human-readable duplicate report that it sends to a Telegram chat. A pure data-quality / CRM-hygiene pipeline with no AI.
- Manual trigger to Input Data to Normalize to Report to Telegram linear chain
- Normalization step lowercases/trims email and strips non-digits from phone so equal records actually match
- Dedup logic uses two JS Sets (seenEmail, seenPhone) and flags a record if EITHER key was already seen
- Formatted report with total/clean/duplicate counts delivered to Telegram
Built with: n8n, JavaScript Code nodes, Telegram Bot API, Set-based dedup, regex normalization