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.
incredible, thank you Bo (.!
