Fixing Duplicate Company Records in Clay-HubSpot Integration
Hey could someone help me out with this? Running into an issue with Clay-HubSpot integration. The Problem: I have a Clay table with multiple leads, some from the same company When I run "Create Company in HubSpot", Clay creates duplicate companies - one for each lead from the same company So if I have 3 leads from Apple, Clay creates 3 separate Apple company records in HubSpot What I've Tried:
"Lookup Company" action (this checks existing HubSpot records, not duplicates within Clay)
Conditional logic on the create action
Multiple formula approaches to count occurrences
AI actions to identify first occurrences
Clay's formula builder with different prompts
None of these work What I Need: A way to make Clay only create ONE company record per unique company during a single table run, regardless of how many contacts work there. Has anyone solved this before? Thanks