Skip to main content

Find duplicate records

Check every new contact against the records you already have. When the email address exists, Tape emails you both records so you can merge or remove one.

Written by Leo

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.

Automation editor for Contacts with the trigger When a record is created and a Conditional actions step that runs only where Email Is not empty. Inside it, Search for records in Contacts looks for the same email address

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 Contacts with the fields Name (text) and Email (email).

  • An address that receives the warnings, for example [email protected].

  • To build this automation, you need to be a Workspace admin in the workspace of the Contacts app.

Check new contacts for duplicates

  1. Open the Contacts app and click the automations icon at the top right (Create and view automations).

  2. Select New automation, then select When a record is created.

  3. Select Add action → Conditional actions. Under If the following conditions are met, select Add filter. Pick Where Email Is not empty.

  4. In the conditional, select Add action → Search for records. Select the app Contacts.

  5. Select Add filter, pick Email and Contains, then type @ in Value and select the Email of the new contact. Remove filter rows you don't fill in. A filter without a value makes the search return no records.

  6. Add a second condition that leaves out the new contact itself, otherwise every new record finds itself. Select Add filter, pick App Record ID, then ≠, and type @ to insert the App Record ID of the new contact.

  7. Open the menu of Search for records and turn on Limit results to keep the list short.

  8. Select Add action → Loop actions. After for each, choose the records found by Search for records. Then select Add action inside the loop → Send email.

  9. In To, enter [email protected]. In Subject, enter "Possible duplicate: " and insert the Name. In the message, insert Record URL for the new contact and for the found contact. In the @ list, fields of the new contact appear under the app's record name, for example Contact, and fields of the found contact under Collected / Contact.

  10. Select Create automation.

Search for records in Contacts where Email Contains the new contact's email and App Record ID is not the new contact's ID, limited to one result, followed by Loop actions for each Contact with Send an email to <a href="mailto:salesops@acme.com" rel="nofollow noopener noreferrer" target="_blank">salesops@acme.com</a>, the subject Possible duplicate and the name, and the record URLs of the new and the found contact

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 email with Create record in a database app Tasks, with a title like "Review duplicate" and a due date. Learn more about follow-up tasks →

  • Match on something else. Search on Phone with Contains, or on Name with Is. Use the operator that fits the field type. Learn more about filters →

  • Check existing records. To check records that already exist, select Manual run and choose them under Run on: Selected records, Selected view, Number of records, or All records.

  • Check across apps. In Search for records, select another app, for example Leads, to compare new contacts with leads.

Learn more

FAQs

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?

The search finds the new record itself. Add a condition that leaves out the triggering record.

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?

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 →

Did this answer your question?