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