Looking for a step-by-step Zapier setup to prevent duplicate entries from multiple form platforms (Typeform/HubSpot) and mark duplicates in Google Sheets.
Tool mentioned: Zapier
1 approved answer
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
Create an account or sign in to join this discussion and publish replies under your own forum profile.
I need a repeatable Zapier workflow that enriches and scores inbound leads using ChatGPT prompts before routing to reps. Looking for trigger choices, prompt structure, and rate-limit/quotas to…
I run a SaaS with ~200 weekly support emails and want a Zapier workflow that sends tickets to ChatGPT for concise summaries, tags, and priority flags with minimal…
I need a Zapier workflow to score Typeform leads and push only qualified prospects to HubSpot while minimizing API calls and false positives.
I need a reliable Zapier sequence that captures leads from an external form, enriches them, de-duplicates, and pushes to HubSpot with owner assignment. Looking for concrete Zap steps,…
