Duplicates split a customer's history over two records and lead to double outreach. This recipe checks each new record at the moment it's created. It searches the database app for the same email address, and for every match it sends a message with links to the records. It doesn't delete anything, so a person decides what to do.
Note:
Guard against empty values. A condition with an empty value can match every record. Run the search only when the new record has an email address.
Nothing is deleted or merged. The automation only reports the match.
What you'll need
A database app
Contactswith the fieldsName(text) andEmail(email).An address that receives the warnings, for example
[email protected].To build this automation, you need to be a
Workspace adminin the workspace of theContactsapp.
Check new contacts for duplicates
Open the
Contactsapp and click the automations icon at the top right (Create and view automations).Select
New automation, then selectWhen a record is created.Select
Add action→Conditional actions. UnderIf the following conditions are met, selectAdd filter. PickWhereEmailIs not empty.In the conditional, select
Add action→Search for records. Select the appContacts.Select
Add filter, pickEmailandContains, then type@inValueand select theEmailof the new contact. Remove filter rows you don't fill in. A filter without a value makes the search return no records.Add a second condition that leaves out the new contact itself, otherwise every new record finds itself. Select
Add filter, pickApp Record ID, then≠, and type@to insert theApp Record IDof the new contact.Open the menu of
Search for recordsand turn onLimit resultsto keep the list short.Select
Add action→Loop actions. Afterfor each, choose the records found bySearch for records. Then selectAdd actioninside the loop →Send email.In
To, enter[email protected]. InSubject, enter "Possible duplicate: " and insert theName. In the message, insertRecord URLfor the new contact and for the found contact. In the @ list, fields of the new contact appear under the app's record name, for exampleContact, and fields of the found contact underCollected / Contact.Select
Create automation.
The result
When someone adds a contact with an email address that already exists, the sales ops team gets one email per match, with links to both records. When the address is new, the search finds nothing, the loop runs zero times, and no email goes out.
Variations
Create a task instead of an email. Replace
Send emailwithCreate recordin a database appTasks, with a title like "Review duplicate" and a due date. Learn more about follow-up tasks →Match on something else. Search on
PhonewithContains, or onNamewithIs. Use the operator that fits the field type. Learn more about filters →Check existing records. To check records that already exist, select
Manual runand choose them underRun on:Selected records,Selected view,Number of records, orAll records.Check across apps. In
Search for records, select another app, for exampleLeads, to compare new contacts with leads.
Learn more
FAQs
Can the automation delete the duplicate for me?
Can the automation delete the duplicate for me?
Not directly. Delete record only deletes the current record. Call automation on collected can start a second automation that uses Delete record on each found record, but we don't recommend it. Two records can share an email address and still be different people. Send a message or create a task, and let someone decide.
Why does every new contact count as a duplicate?
Why does every new contact count as a duplicate?
The search finds the new record itself. Add a condition that leaves out the triggering record.
Does it find duplicates that differ in capitalization?
Does it find duplicates that differ in capitalization?
Yes. Contains ignores capitalization, so [email protected] matches [email protected]. This works for text fields too.
Are you a developer using the Tape API for automations?
Are you a developer using the Tape API for automations?
The automation API has its own documentation for developers. Full reference: collect_app_records in the developer docs →
Still have questions? Find answers and get help from community experts in the Tape community →
