Tips for Retrieving Company Owner Data from HubSpot | Clay

Tips for Retrieving Company Owner Data from HubSpot

Andrew H. · 2025-03-05T16:53:24.331883+00:00

I have a table I'm using where I want to... 1. Bring in "LinkedIn Post Likes" from Phantombuster 2. Look up their Company Domain based on the Company Name (included in import) 3. Look at HubSpot to pull in Company Owner for accounts associated with that Company Domain 4. Send Slack Alerts to Compay Owner • I've successfully imported the data from Phantombuster • I've successfully looked up Company Domain • I am very stuck trying to use the Lookup Object or Retrieve Object functions to bring "Company Owner" into the table from HubSpot Does anyone have tips here?

Andrew H.

I have a table I'm using where I want to...

1.
Bring in "LinkedIn Post Likes" from Phantombuster
2.
Look up their Company Domain based on the Company Name (included in import)
3.
Look at HubSpot to pull in Company Owner for accounts associated with that Company Domain
4.
Send Slack Alerts to Compay Owner

I've successfully imported the data from Phantombuster
I've successfully looked up Company Domain
I am very stuck trying to use the Lookup Object or Retrieve Object functions to bring "Company Owner" into the table from HubSpot

Does anyone have tips here?

4 comments

Channeled
APP
·
·
To bring the Company Owner from HubSpot into your table using the Lookup Object function, follow these steps: 1. Select your HubSpot account in Clay 2. Choose "Company" as your Object Type to lookup 3. Set up your search parameters: • Select the appropriate field to filter by (like Company Domain) • Choose your search operator (AND/OR) if using multiple fields • Enter your field values from your Clay table 4. Configure your response settings: • Set "Remove Blank Values from Results" as needed • Adjust the limit of returned objects (defaults to 10) The results will return: ** An array of matching records ** Total number of matches found * For each result: Object ID, creation date, update date, and properties (including Company Owner) By default, new rows in your Clay table will automatically run this lookup. You can also use formulas to trigger the lookup only under specific conditions.
Sources: Hubspot integration overview | Documentation | Clay University Hubspot integration overview | Documentation | Clay University Hubspot integration overview | Documentation | Clay University
Andrew H.
·
·
No
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.
Gillian
·
·
Clay any solution here? The above does not work