Im running a one shot table and the issue that I have is that 3 contacts can be from the same company but when I do the lookup i dont find results and if I dont find results I want to create the company, but all the lookups and create record happens at the same time ending with 3 identical accounts
This is a common issue with parallel processing. The solution is to use conditional logic to prevent duplicate company creation.
First, do a company lookup before creating any records. Then set up your "Create Company" action to only run when no matching company ID is found from the lookup step. [1]
The key is using conditional runs - configure the create action to only execute if the company lookup returns blank/no results. This prevents multiple contacts from the same company from all triggering company creation simultaneously. [2]
Test with a small batch first (10 rows) to confirm only one company gets created per unique company, even when multiple contacts belong to it. [3]
Before we dive deeper into the technical setup, have you tried using Sculptor? It's our built-in AI tool in the top-right corner that can help you set up these conditional workflows automatically. Give it a try and let me know if that helps solve your duplicate company issue!
what integration are you running?
Which specific CRM are you looking to integrate with for your company lookup and creation workflow?
If you still need help resolving the duplicate company creation issue, I’m here to assist. Would you like to provide more details about the CRM or integration you’re using so we can continue troubleshooting?
