Accessing Company Owner Data in HubSpot: Tips & Troubleshooting

Aaron K. · 2025-11-11T19:10:34.293Z

is anyone able to access this article (https://community.clay.com/x/start/jz5j4tgzcwj4/tips-for-retrieving-company-owner-data-from-hubspo)? I'm running into some issues with HubSpot returning only IDs instead of names for Company Owner

Accessing Company Owner Data in HubSpot: Tips & Troubleshooting | Clay

13 comments

· Sorted by Oldest

Clay Support
APP
·
·
When importing HubSpot data into Clay, you can include read-only properties" data-entity-id="119399512" data-entity-type="129">include read-only properties which are helpful for non-editable fields.
For HubSpot lookups, you have options to include read-only properties and remove blank values from results. These settings can help ensure you're getting the complete data including owner names rather than just IDs.
Try enabling "Include read-only properties" in your HubSpot import or lookup settings to retrieve the full owner name data instead of just the ID references.
Clay Support
APP
·
·
Did that answer your question?
Aaron K.
·
·
no
Clay Support
APP
·
·
I'm routing you to our human team now. They’ll be able to assist you further.
Clay Support
APP
·
·
Our support team has got your message and we'll get back to you soon!
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
image.png(93 kB)
Sayli G.
·
·
Hello Aaron! Thanks for reaching out! Do you mind sending the link (url) to the table so we can take a look?
Loading attachments
AhmadNasiri
·
·
Hi Sayli G., I'm in Aaron's team. Here is the article link that we were looking for: https://community.clay.com/x/start/jz5j4tgzcwj4/tips-for-retrieving-company-owner-data-from-hubspo We use Hubspot-Clay integration, and when we search for "Company" or "Deal" owner, Hubspot returns the "USER ID" instead of "User Names". We want to know how we can solve that issue.
Mitch H.
·
·
Hey Aaron, I'm also not able to see that particular article. I'd be happy to take a look at your table set up in any case to see if I can help. Feel free to send a table link and I can dive in :)
AhmadNasiri
·
·
Thanks, Mitch! It’s more of a general question about how we can get the User’s name instead of the User ID in the HubSpot–Clay integration. As you can see in this table, the Company Owner field comes back as the Company Owner ID (a number, not the name). Let me know if you know of any workaround for that.
Mitch H.
·
·
Good question! Yeah, HubSpot returns owner IDs (numbers) instead of names by default. Here are two workarounds:
Option 1: Create a mapping table (simpler)
1.
Create a separate Clay table with your HubSpot users/owners
2.
Map the Owner ID to Owner Name in that table
3.
Use a lookup column in your main table to match the Owner ID and pull in the name
Option 2: Use HTTP API to import HubSpot owners (more automated)
Set up an HTTP API enrichment to pull owner data directly from HubSpot:
1.
Add an "HTTP API" enrichment column
2.
Use this endpoint: https://api.hubapi.com/crm/v3/owners
3.
In Headers, add:
Key: Authorization
Value: Bearer YOUR_HUBSPOT_TOKEN
1.
The response will include owner ID, name, email, etc.
2.
You can then use a lookup or formula to match the owner ID from your table to the owner name from the API response
Quick version: If you just need to do this once or for a small table, Option 1 is faster. If you're dealing with this regularly or at scale, Option 2 is better because it stays up to date automatically.
The reason this happens is that HubSpot's API returns owner properties as IDs by default - it's a HubSpot thing, not a Clay limitation. The workaround is just mapping those IDs back to names.
AhmadNasiri
·
·
Thanks a lot, Mitch! That’s super helpful 🙌 I’ll take a look at both options and get back to you once I test them out.
Mitch H.
·
·
Fantastic, more than happy to help :)
Clay Support
APP
·
·
We haven't heard back from you here, so we're going to go ahead and close this thread out.
Still need help here? Reply back and someone will jump back in.
Have a question thats not related to this thread? We recommend kicking off a new ticket in the support channel!

Clay Support
APP
·
·
When importing HubSpot data into Clay, you can include read-only properties" data-entity-id="119399512" data-entity-type="129">include read-only properties which are helpful for non-editable fields.
For HubSpot lookups, you have options to include read-only properties and remove blank values from results. These settings can help ensure you're getting the complete data including owner names rather than just IDs.
Try enabling "Include read-only properties" in your HubSpot import or lookup settings to retrieve the full owner name data instead of just the ID references.
Clay Support
APP
·
·
Did that answer your question?
Aaron K.
·
·
no
Clay Support
APP
·
·
I'm routing you to our human team now. They’ll be able to assist you further.
Clay Support
APP
·
·
Our support team has got your message and we'll get back to you soon!
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
image.png(93 kB)
Sayli G.
·
·
Hello Aaron! Thanks for reaching out! Do you mind sending the link (url) to the table so we can take a look?
Loading attachments
AhmadNasiri
·
·
Hi Sayli G., I'm in Aaron's team. Here is the article link that we were looking for: https://community.clay.com/x/start/jz5j4tgzcwj4/tips-for-retrieving-company-owner-data-from-hubspo We use Hubspot-Clay integration, and when we search for "Company" or "Deal" owner, Hubspot returns the "USER ID" instead of "User Names". We want to know how we can solve that issue.
Mitch H.
·
·
Hey Aaron, I'm also not able to see that particular article. I'd be happy to take a look at your table set up in any case to see if I can help. Feel free to send a table link and I can dive in :)
AhmadNasiri
·
·
Thanks, Mitch! It’s more of a general question about how we can get the User’s name instead of the User ID in the HubSpot–Clay integration. As you can see in this table, the Company Owner field comes back as the Company Owner ID (a number, not the name). Let me know if you know of any workaround for that.
Mitch H.
·
·
Good question! Yeah, HubSpot returns owner IDs (numbers) instead of names by default. Here are two workarounds:
Option 1: Create a mapping table (simpler)
1.
Create a separate Clay table with your HubSpot users/owners
2.
Map the Owner ID to Owner Name in that table
3.
Use a lookup column in your main table to match the Owner ID and pull in the name
Option 2: Use HTTP API to import HubSpot owners (more automated)
Set up an HTTP API enrichment to pull owner data directly from HubSpot:
1.
Add an "HTTP API" enrichment column
2.
Use this endpoint: https://api.hubapi.com/crm/v3/owners
3.
In Headers, add:
Key: Authorization
Value: Bearer YOUR_HUBSPOT_TOKEN
1.
The response will include owner ID, name, email, etc.
2.
You can then use a lookup or formula to match the owner ID from your table to the owner name from the API response
Quick version: If you just need to do this once or for a small table, Option 1 is faster. If you're dealing with this regularly or at scale, Option 2 is better because it stays up to date automatically.
The reason this happens is that HubSpot's API returns owner properties as IDs by default - it's a HubSpot thing, not a Clay limitation. The workaround is just mapping those IDs back to names.
AhmadNasiri
·
·
Thanks a lot, Mitch! That’s super helpful 🙌 I’ll take a look at both options and get back to you once I test them out.
Mitch H.
·
·
Fantastic, more than happy to help :)
Clay Support
APP
·
·
We haven't heard back from you here, so we're going to go ahead and close this thread out.
Still need help here? Reply back and someone will jump back in.
Have a question thats not related to this thread? We recommend kicking off a new ticket in the support channel!