Importing Custom Properties from HubSpot to Your Table

I've been able to import a list of companies from hubspot, but custom properties are not automatically pulled into the table. How do I do this?

4 comments

Channeled
APP
·
·
To automatically pull custom properties when importing a list of companies from HubSpot into Clay, follow these steps: 1. Click on "Actions" in the top right of your table, then select "Import". 2. Choose "Import Companies from HubSpot" and authenticate your HubSpot account. 3. Select the list of companies you want to import, or leave it blank to import all companies. 4. Enable the "Include Read Only Properties" option to include all HubSpot calculated fields. After import, the data will appear in a single column. To extract specific properties: 1. Click into a record and select the desired fields (including custom properties). 2. Extract multiple fields to separate columns for better organization. Remember, we refer to this feature as "write to table". If you need further assistance, please ask for human help by clicking "Talk to a person".
Sources: Pull in a List of Companies with HubSpot Hubspot integration overview | Documentation | Clay University Import from CRM [Clay 101] - Clay University Import from CRM [Clay 101] - Clay University
Miheer P.
·
·
yes! I'm also looking to join on a postgres server, is this possible?
Channeled
APP
·
·
Yes, it's possible to perform operations like joins on a Postgres server through Clay's integration. We offer a "Lookup Row" action that allows you to run SQL queries on your Postgres database. You can enter a raw SELECT SQL query, which could include joins, to retrieve data from your Postgres tables. This integration is available for our Enterprise plan users. If you need more specific guidance on constructing join queries, let me know and I can provide further assistance.
Sources: Lookup Row with Postgres Lookup Row with Postgres | Clay.com Postgres integration overview | Documentation | Clay University
Channeled
APP
·
·

Importing Custom Properties from HubSpot to Your Table | Clay