Automate website enquiries without creating duplicate CRM contacts

The pattern that prevents them

Whichever tool you use, the workflow should follow the same logic:

1. Receive the enquiry, ideally by webhook so it runs instantly.
2. Clean the data. Trim spaces and lower-case the email address. Format phone numbers consistently.
3. Search the CRM for a contact with that email address.
4. Branch:
   • if found, update the existing contact and add the enquiry as a note, activity or deal
   • if not found, create the contact, then add the enquiry
5. Notify the team in email, Slack or Teams, with a link to the CRM record.
6. Confirm to the enquirer that you received their message.
7. Handle errors. If the CRM is unavailable, store the enquiry somewhere safe and alert a named person.

Some CRMs and tools offer a single “find or create” or “upsert” action that combines steps 3 and 4. Check your CRM’s documentation for what it supports.

Choosing a tool

A few points from the providers’ own documentation:

• Zapier: the Free plan only allows two-step Zaps, and Filters and Paths need a paid plan, so the pattern above needs at least Professional. Zapier says triggers and its built-in tools such as Formatter, Filter and Paths do not use tasks.
• Make: each search, create or update module uses credits, but Make says routers and error handlers do not.
• n8n: the whole workflow counts as one execution, however many steps it has.

Before you go live: a test checklist

Submit test enquiries and check:

• A brand new email creates one contact
• The same email again updates that contact, not a new one
• The same email in capital letters, or with a trailing space, still matches
• The team alert links to the right CRM record
• A failed CRM step alerts a named person and the enquiry is not lost
• Spam submissions are filtered or flagged

Data protection

Enquiries contain personal data. Keep only the fields you need, make sure your privacy notice covers the CRM and automation tool, and know where each tool stores data. Our AI and customer data checklist covers the questions to ask.

Cleaning up existing duplicates

If your CRM already has duplicates, fix the workflow first, then merge records. Most CRMs offer a merge or duplicate-management tool. Back up your data before bulk merging.

Need help setting this up?

Browse CRM automation agencies in the UK, or find specialists by platform: Zapier, Make and n8n. Ask them to show you the test checklist above working before you sign off.