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

  • Avatar of Elena M.
    Elena M.
    Β·
    Β·

    in which field can I select the columns I want to include? I see no such option

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

  • Avatar of Bruno R.
    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)
    Image

    This ID should track to the relevant internal user records which is associated to the owner ID for this specific contact.

  • 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.