How to automatically prevent duplicate items in your board
TL;DR: Combine one Connected Boards Automations recipe with one native monday.com automation to auto-detect AND auto-delete duplicate items. Any new item that matches an existing record (by Email, ID, or any column) is connected to the original and then deleted — keeping your board clean automatically.
What this setup does
This is a two-automation pattern. When a new item is created on your board, the setup:
Checks if another item already exists with the same matching value (Email, Client ID, etc.)
If found, connects the new item to the existing one
The connection triggers a native monday.com automation that deletes the new (duplicate) item
If no match is found, the item stays on the board as a unique record. The whole flow happens in the background within seconds of item creation.
When to use it
- CRM systems — prevent duplicate contacts with the same email address
- Lead management — avoid adding the same lead multiple times
- Order tracking — prevent duplicate orders with the same order ID
- Client databases — ensure each client only appears once
Test on a sandbox board before turning this on for production data. The deletion is automatic and irreversible — a misconfigured recipe could delete items you wanted to keep.
Before you start
- A matching key column on your board with consistent, accurate values (e.g. Email, Client ID, Phone) — see Setting up Connect Boards columns if you don't have a connect column yet
- Edit access on the board and permission to create automations
- A clear definition of "duplicate" — which column(s) determine uniqueness
Step 1: Set up the Connected Boards Automations recipe
Recipe: "When item/subitem created, connect it to items/subitems from another board using this connect column when this column matches another column and sync ALL future changes where column name and type match."
Configure
Before creating the automation, add a new Connect Boards column to this board.
In the column settings, connect this board to itself (yes, the same board).
Open the Connected Boards Automations recipe above and click Use Template.
Pick the same board as both source and target.
Select the newly created Connect Boards column.
In the matching-column fields, pick the column you want to use to detect duplicates:
- Email column → matches with Email column
- Text column → matches with Text column (best for unique IDs)
When a new item is created with the same matching value as an existing one, the recipe auto-connects them via the connect column.
Step 2: Set up the native monday.com delete automation
Native automation: "When column changes, then delete item."
Configure
- In the When column changes trigger, select your Connect Boards column.
- This means: when the connect column gets populated (a match was found by Step 1), the item is automatically deleted.
What happens after setup
- If a new item is unique → it stays on the board
- If a duplicate is created → Step 1 connects it to the original → Step 2 deletes it
- Original items are never touched
Common gotchas
Test before going live. The delete is automatic and irreversible. Run on a sandbox board with sample data before enabling on production.
Matching data must be consistent. " alice@example.com " won't match " Alice@Example.com " unless your matching logic accounts for case. Normalise values where possible.
The connect column must connect the board to itself. Self-board connections are the unusual part here — not how most CB recipes work, but the key to making this pattern work.
Both automations must be active. Disabling either one breaks the pattern. The connect step alone leaves dupes in place; the delete step alone has nothing to trigger it.
Pair with import workflows. If you import data from external sources (forms, CSV, integrations), this pattern catches dupes that import processes often miss.
Related
- Connect items across boards (parent landing — all connect recipes)
- Match or create · When an item is created, connect — opposite pattern: create the master record if no match found
- When an item is created, connect + sync — the recipe used in Step 1
- Setting up Connect Boards columns — prerequisite
Still stuck?