.png){kind=logo}
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?
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".
yes! I'm also looking to join on a postgres server, is this possible?
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.