Import Users from HubSpot for Record Management and Round Robins

Dominic G. · 2025-07-08T23:20:45.000438+00:00

I'd love to be able to import Users from Hubspot to help me build tables for understanding who is assigned to which records, run round robins etc. As the screenshot shows I can only see Company/Contact/Deal/Lead objects available

Hey, Totally hear you — while the HubSpot Users object isn’t directly supported yet, a quick workaround is to use the HTTP API source. You can hit HubSpot’s /crm/v3/owners endpoint, which returns a list of users. Just set up an HTTP request in Clay with your HubSpot API key, and map the response into a table. From there, you can use lookups or join columns to connect users to records.

Endpoint: https://api.hubapi.com/crm/v3/owners And add your API key (or private app token) In the Headers section, add: • Key: Authorization • Value: Bearer YOUR_HUBSPOT_TOKEN 4. Optional – limit fields If you only want specific fields (like name, email, ID), you can filter those in a formula column after the data is returned. 5. Test and import Click Test Request, and if it returns the user data as expected, hit Save & Import

Let me know if you have more questions.

2 comments