Clay Icon
Join the Community
02 Starting with Clay

Tips for Retrieving Company Owner Data from HubSpot

Avatar of Andrew H.Andrew H.
·
·

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

  1. 1.

    Bring in "LinkedIn Post Likes" from Phantombuster

  2. 2.

    Look up their Company Domain based on the Company Name (included in import)

  3. 3.

    Look at HubSpot to pull in Company Owner for accounts associated with that Company Domain

  4. 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?

3 comments

  • Avatar of Channeled
    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.

  • Avatar of Andrew H.
    Andrew H.
    ·
    ·

    No

  • Avatar of Channeled
    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.