Building a website enquiry to CRM flow for a UK small business without duplicate contacts
Описание и применение
Автоматизация сбора заявок с веб‑сайта в CRM без дублирования контактов: очистка данных, поиск, обновление/создание, уведомления и обработка ошибок.
Задача
Duplicate contacts are created when a website enquiry form submits to a CRM, causing multiple records for the same person and fragmented notes.
Результат
The pattern eliminates duplicate contacts, consolidates enquiry data, and provides reliable notifications and error handling.
Рабочий процесс
- Receive enquiry via webhook
- Clean data: trim spaces, lowercase email, normalize phone
- Search CRM for contact by email
- Branch: if found, update contact and attach enquiry; if not, create contact then attach enquiry
- Notify team via email/Slack/Teams with CRM link
- Confirm receipt to enquirer
- Handle errors: store payload, alert named person
Доказательства
The workflow creates a contact on every submission.
The clean step is a Code node placed straight after the Webhook node.
A test checklist to hand over… [ ] A brand new email creates exactly one contact…
- Дата записи: 2026-11-01T04:59:03.042Z