Automation Is Creating Duplicate Opportunities: How to Prevent It
When automation is creating duplicate opportunities, the same deal exists more than once in the pipeline. The cause is trigger repetition, workflow re-entry or a missing check for an existing opportunity. This is different from duplicate contacts, because the record being duplicated is the deal, not the person.
Table of Contents
- 01.Duplicate opportunities vs duplicate contacts
- 02.What to check first
- 03.Trigger repetition and re-entry
- 04.Missing existing opportunity check
- 05.Multiple workflows creating
- 06.Repeated source events
- 07.How to test it
Duplicate opportunities vs duplicate contacts
A duplicate opportunity is a repeated deal record, not a repeated contact. The same contact may correctly have one record but multiple opportunities if they buy more than once. The problem is when one business action creates two or more opportunity records. The cause is in the trigger, the re-entry or the existing opportunity check. This is distinct from the duplicate contact problem covered in the guide on automation creating duplicate CRM contacts.
| Cause | What happens | How to confirm |
|---|---|---|
| Trigger fires twice | Two opportunities created | Two trigger events in log |
| Workflow re-entry | Contact re-enters, creates again | Re-entry enabled |
| No existing opportunity check | Always creates new | No lookup before create |
| Multiple workflows create | Each creates one | Two workflows with create action |
| Repeated source event | Source fired twice | Source log shows two events |
What to check first
- Identify the duplicate opportunities and compare their source and trigger.
- Check whether the trigger event occurred more than once.
- Confirm whether re-entry is enabled on the workflow.
- Check whether the workflow looks for an existing opportunity before creating.
- Search for a second workflow that also creates opportunities.
Trigger repetition and re-entry
If the trigger fires twice, two opportunities are created. Check the source event log to confirm whether the business action occurred once or twice. If the trigger fired once but two opportunities exist, re-entry may be the cause. A contact who re-enters the workflow runs the create action again. Confirm the re-entry setting. Re-entry problems are covered in the guide on automation workflow re-entry problems.
Missing existing opportunity check
A workflow that creates an opportunity without checking for an existing one produces a duplicate every time the trigger fires for the same contact and deal. Confirm the workflow has a lookup step that searches for an existing open opportunity before creating. The check should look for an open opportunity on that contact, not a closed one, because a closed deal legitimately allows a new opportunity. The fix is to add a condition that skips creation when an open opportunity already exists.
Multiple workflows creating
Two workflows that both create opportunities produce two records for one event. Check for multiple workflows with a create opportunity action that trigger on the same event. Each runs once, but the combined result is a duplicate. The fix is to disable or consolidate one workflow. This is the same multi-workflow pattern covered in the guide on automation running twice.
Repeated source events
The source event itself may have fired twice. A form submitted twice or a webhook sent twice creates two opportunities because each event legitimately triggers the workflow. Check the source log. If the source fired twice, the fix is at the source, not the workflow. Webhook retries can cause this and are covered in the guide on webhook sending duplicate data.
How to test it
- 1.Find duplicate opportunities and compare their trigger source.
- 2.Check the source event log for repeated events.
- 3.Confirm the re-entry setting on the workflow.
- 4.Check for an existing opportunity lookup before the create action.
- 5.Search for a second workflow that also creates opportunities.
- 6.Add the existing opportunity check and retest with one trigger event.
Frequently Asked Questions
Why is my automation creating duplicate opportunities?
The trigger may fire twice, re-entry may be enabled or the workflow may create without checking for an existing open opportunity. Check the trigger count, the re-entry setting and whether a lookup exists before the create action.
How do I stop my automation from creating duplicate opportunities?
Add a lookup that checks for an existing open opportunity on the contact before creating, confirm the trigger fires once and disable unwanted re-entry. Check for a second workflow that also creates opportunities.
Need help applying this to your business?
PPC, Conversion Tracking, CRM and Automation Specialist. Helping businesses generate qualified leads with Google Ads, accurate tracking and automated follow-up.
Related Guides
Automation Is Creating Duplicate CRM Contacts: How to Find the Source
Duplicates come from create versus update logic, not the CRM database. Fix the matching in the workflow before you deduplicate the records.
Automation Re-Entry Problems: Why the Same Contact Keeps Entering the Workflow
Re-entry may be legitimate or unwanted. Check the enrollment count, the re-entry setting and the trigger count before deciding whether to block repeated entry.
Automation Running Twice: Why the Same Workflow May Execute More Than Once
Duplicate execution has two causes that look the same. One workflow running twice needs a different fix than two workflows doing the same action. Identify which you have first.