)
Written by
Table of Contents
“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”
HubSpot’s native import tool struggles with company name variations because it relies on exact string matching, creating duplicates when “ABC Corp” and “ABC Corporation” are the same company.
You’ll learn how to use company domains as unique identifiers to prevent duplicates and build advanced matching workflows that HubSpot can’t handle natively.
Use domain-based deduplication workflows using Coefficient
Coefficient solves this problem by enabling sophisticated data reconciliation in spreadsheets before importing to HubSpot or HubSpot . You can build matching logic using company domains while HubSpot’s import tool only does basic name matching.
How to make it work
Step 1. Export existing HubSpot companies with domains and IDs.
Use Coefficient to pull your current HubSpot company data including company domain and HubSpot company ID fields. This creates your reference dataset for matching against new imports.
Step 2. Create domain lookup formulas in your spreadsheet.
Build VLOOKUP or INDEX/MATCH formulas to check if incoming company domains already exist: =INDEX(hubspot_ids, MATCH(new_domain, hubspot_domains, 0)). This returns the HubSpot ID if a domain match is found.
Step 3. Set up conditional logic for UPDATE vs INSERT operations.
Create a column that determines the action: =IF(ISBLANK(matched_id), “INSERT”, “UPDATE”). Records with existing domain matches get updated, while new domains create new companies.
Step 4. Use Coefficient’s export actions to push clean data back.
Coefficient automatically handles UPDATE operations for records with HubSpot IDs and INSERT operations for new records. This prevents the duplicate creation that happens with HubSpot’s standard import process.
Stop creating duplicate companies in HubSpot
Domain-based deduplication ensures “ABC Corp” and “ABC Corporation” with the same domain get treated as one company, not two separate records. Try Coefficient to build sophisticated matching rules that HubSpot’s import tool simply can’t handle.
