Missing Company Owner Column in Clay Table: Need Assistance

Hello Clay Support Team. I have a question for this table: https://app.clay.com/workspaces/424056/workbooks/wb_WF4AUzauB9fq/tables/t_cCXHqCRVeyQn/views/gv_btWFqTYBos5X I want to lookup from my hubspot account and find the column Company Owner, but there is no such column for some reason. What should I do? Thanks a lot in advance!

5 comments

Channeled
APP
·
·
If you can't see the "Company Owner" column in your linked table, it might not be included in the default fields Clay pulls from HubSpot. To add it: 1. Use the "Lookup Company with HubSpot" action in Clay. 2. When setting up the lookup, you can choose which fields to include. 3. Select the "Company Owner" field if available. If it's still not visible, the field might not be set up in your HubSpot account. Check your HubSpot settings to ensure the "Company Owner" field exists and has data. Remember, Clay only displays fields that contain data. If the "Company Owner" field is empty in HubSpot, it won't appear in Clay.
Sources: Lookup Company with HubSpot Lookup Company with HubSpot | Clay.com
Elena M.
·
·
in which field can I select the columns I want to include? I see no such option
Channeled
APP
·
·
When using the "Lookup Company with HubSpot" action in Clay, there isn't a specific field to select columns you want to include. The action is designed to check if a company exists in HubSpot based on the company domain or HubSpot Company ID you provide. If you want to customize the data you're pulling from HubSpot, you might be thinking of the "Pull in a List of Companies with HubSpot" action instead. This action allows you to choose whether to include read-only properties, which affects the fields returned. To manage the columns in your Clay table after importing data, you can right-click on a column, select "Edit Column," and then "Select Data Type" to organize your data. Is there a specific type of company information you're trying to retrieve from HubSpot?
Sources: Pull in a List of Companies with HubSpot Select Column Data Type Lookup Company with HubSpot
Bruno R.
·
·
Hi Elena, thanks for your message! When looking into the object lookup you ran I actually do see an associated owner ID:
(542 kB)
This ID should track to the relevant internal user records which is associated to the owner ID for this specific contact.
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.