How to set up Zapier dedupe for webform leads
Looking for a step-by-step Zapier setup to prevent duplicate entries from multiple form platforms (Typeform/HubSpot) and mark duplicates in Google Sheets.
Best tools for this use case
Based on the workflow in this discussion, these tools are useful starting points to review.
Zapier
Best general-purpose automation layer for connecting tools and processes quickly.
Make
Powerful automation builder for advanced visual flow design and multi-step operations.
n8n
Technical automation platform with strong flexibility, control and AI workflow potential.
Answers
Approved replies, operator insight, and tactical follow-up from the community.
Make one Zap per source (Typeform, HubSpot).
Trigger: new entry/contact.
Use Formatter to normalize email/phone (lowercase, strip non-digits).
Action: Google Sheets — Find or Create Row by email or phone (your unique key).
If found: Update row -> set “Duplicate”=TRUE and append source/timestamp.
If created: leave “Duplicate”=FALSE.
Test both Zaps against the same sheet and use a dedicated key column to avoid race conditions.
More on Zapier and alternatives: Compare Zapier and Make