Issue with Salesforce integration creating duplicate accounts

I am using the Hubspot to Salesforce integration to sync contacts and companies between the two systems. However, I’ve been having an issue with Hubspot creating duplicate accounts in Salesforce instead of adding contacts to the existing account.

I’ve tried to compare the duplicate accounts, and the only difference is the website listed. I believe the issue is because Hubspot matches on website domain and considers the https:// as part of the domain.

For example, I have Company A already in Salesforce, and the website is listed as https://CompanyA.com. However, Hubspot will autorecognize the domain from an email, so name@CompanyA.com creates a domain of CompanyA.com. As a result, Hubspot does not recognize that CompanyA.com is the same as https://CompanyA.com, and creates a new Company A account to attach the contact to, and I end up with two Company A Salesforce accounts.
Does anyone else have this issue and is there a way to set up Hubspot to learn the https URL format or perhaps use a type of fuzzy match on the account name alone?

Hey @HMartin22 - thanks for reaching out to the Community!
I’d like to tag in some of our integration experts to see if they may have some insight that can help us out here! @StjepanGrcic, @LaurenRyan, and @CateDuarte - any thoughts for @HMartin22?
Shane, Community Manager

Hi @HMartin22

I’ve seen this exact issue a few times. HubSpot’s Salesforce connector does indeed key heavily on the website field when matching companies, so a mismatch like https://companyA.com vs companyA.com can cause a duplicate account.

One workaround is normalizing website domains inside HubSpot before sync strip out https:// and www. with a workflow or a custom code action so the company domain matches Salesforce’s format. HubSpot has some notes on how the connector handles and also some guidance on managing duplicates here:

(Connect HubSpot and Salesforce )

(Deduplicate records in HubSpot )

If you want more control than HubSpot’s standard matching, some teams push company records through an intermediate data layer where domains are standardized before they ever syncc

That way Salesforce and HubSpot both see the same normalized values and you avoid the duplicate creation problem entirely. A sync platform like Stacksync does this natively keeping Salesforce and HubSpot aligned in real time while handling domain normalization and associations automatically, so you don’t have to fight these edge cases in workflows

Hope this helps.