Hey everyone, I could use some help in a "real-world" application. I received a list of trade-show attendees that contains: First Last Company Name Company Address Company Phone Number I brought the CSV into Clay, enriched company to find URL, then checked HubSpot via Lookup to filter out "new" companies. When I created the Hubspot Company Objects, it created one per contact at each company (not what I wanted to do). I can't think of a way to only create one company (not one per contact) via Clay outside of first deduping my companies and working out of two tables. Does anyone have a way to handle this? It's a repetitive request I get from our marketing team so I'd love to stop deleting/merging duplicates 🙂
Hey! 👋 You’re totally right. Clay will create one HubSpot company per row unless you dedupe first. The cleanest way to handle this is:
Create a “Companies” table where you dedupe by domain (or company name + city if no domain).
Enrich that table to get unique company records.
Then create HubSpot Company Objects from that table instead of the contacts table.
Once that’s done, you can use a Lookup or Link Table column in Clay to match your contacts to their HubSpot Company IDs.
That way, you’ll only ever create one company per domain, and you can safely re-run this workflow without duplicates.
Hey, so I'm going through this process today and was wondering if for Step 1, you're just uploading the .csv two times to two separate tables? One as the Master and the other as the dedup company table? Or are you taking the master .csv, sending data to another table, then deduping Company? Not sure if there is any value in the latter other than avoiding the redundant import of the same csv
