Hi all, wanted to know if anyone had encountered a way to bulk enrich company data in Hubspot with the UK company house number?
Hello,
One option is to use a third-party data enrichment tool like Clearbit, ZoomInfo, or any other integration available in the HubSpot Marketplace. These tools can pull data from external databases and match it with your existing company records.
If you’re working with UK-specific data, you could also export your company list from HubSpot, use the Companies House API (or a similar service) to find the company numbers, and then re-import the updated data back into HubSpot. Make sure your CSV has the correct mapping fields for a smooth import process.
Lastly, if you prefer automation, consider using a tool like Zapier or custom API scripts to connect HubSpot with Companies House directly for real-time data syncing.
Thanks - I ended up using a custom code in a workflow to utilise the companies house API to do this instead. 3rd party services all said this was not something they could automate, or have a focus on US only data.
For a no-code approach, you might also consider using a data integration tool like Skyvia (HubSpot Integration - ETL, Reverse ETL - Skyvia Connector). It allows bulk updates in HubSpot by importing CSV files or using SQL queries to enrich company data efficiently.