Push HubSpot Contact Find Results into a New Table

Filipe Brigas · 2025-05-07 11:13:25.633321+00

is there a way to push all the results found from a hubspot contact find into a new table?

Push HubSpot Contact Find Results into a New Table | Clay

8 comments

· Sorted by Oldest

Channeled
APP
·
·
Yes, you can push HubSpot contact search results into a new table in Clay. Here's how: 1. Use the "Find People" feature to search for contacts in HubSpot. 2. When importing HubSpot data: • Go to the Source panel • Select "HubSpot" as your data source • Choose "Contact" as the Object Type • Optionally, select a specific list to pull from 3. The imported data will appear in a single column. You can then extract specific fields (e.g., email, company name) into separate columns for better organization. This process uses our "write to table" feature to create a new table with your HubSpot contact search results.
Sources: Find Contacts at Company with Companies, People, Jobs Import from CRM [Clay 101] - Clay University Hubspot integration overview | Documentation | Clay University
Filipe Brigas
·
·
not helpful - can’t create that list as they are company filters
kushagra tiwari
·
·
use write to enrichment and select the results, then map out the columns to write them as new rows in a new table
Filipe Brigas
·
·
more info - as I did not completely follwo your answer kushagra tiwari
Suleman Khan
·
·
Use the Write to other table function within Clay, select the list as an input and map out the columns as you need per your requirements from the data.
Filipe Brigas
·
·
that is amazing - thank you for the help - now I understood it 🙌
kushagra tiwari
·
·
1.
When you hover on the results you will see take action on the list option, click on that. Then click on write each item to a new row option.
🙌2
Channeled
APP
·
·
Hello Filipe! Thanks for reaching out and being super patient! As rightly mentioned in this thread, you can use the WTT (Write to Other Table) option to get all this list data into a new table. You can follow these steps:
a. Choose a table to write to b. Select a destination table, preferably within your current workbook c. Choose the column that contains the lists you want to map (such as email addresses found in each cell) d. Select the list properties to map into your new table columns e. (Optional) Configure run settings - Auto-update will automatically enrich new rows as they are added - The "Only run if" option allows you to set conditions for when the AI runs. For example, you can specify that the AI only runs if certain data fields are filled. This document talks about the use case in more detail and has an FAQ section as well: https://www.clay.com/university/guide/write-to-table-integration-overview

Channeled
APP
·
·
Yes, you can push HubSpot contact search results into a new table in Clay. Here's how: 1. Use the "Find People" feature to search for contacts in HubSpot. 2. When importing HubSpot data: • Go to the Source panel • Select "HubSpot" as your data source • Choose "Contact" as the Object Type • Optionally, select a specific list to pull from 3. The imported data will appear in a single column. You can then extract specific fields (e.g., email, company name) into separate columns for better organization. This process uses our "write to table" feature to create a new table with your HubSpot contact search results.
Sources: Find Contacts at Company with Companies, People, Jobs Import from CRM [Clay 101] - Clay University Hubspot integration overview | Documentation | Clay University
Filipe Brigas
·
·
not helpful - can’t create that list as they are company filters
kushagra tiwari
·
·
use write to enrichment and select the results, then map out the columns to write them as new rows in a new table
Filipe Brigas
·
·
more info - as I did not completely follwo your answer kushagra tiwari
Suleman Khan
·
·
Use the Write to other table function within Clay, select the list as an input and map out the columns as you need per your requirements from the data.
Filipe Brigas
·
·
that is amazing - thank you for the help - now I understood it 🙌
kushagra tiwari
·
·
1.
When you hover on the results you will see take action on the list option, click on that. Then click on write each item to a new row option.
🙌2
Channeled
APP
·
·
Hello Filipe! Thanks for reaching out and being super patient! As rightly mentioned in this thread, you can use the WTT (Write to Other Table) option to get all this list data into a new table. You can follow these steps:
a. Choose a table to write to b. Select a destination table, preferably within your current workbook c. Choose the column that contains the lists you want to map (such as email addresses found in each cell) d. Select the list properties to map into your new table columns e. (Optional) Configure run settings - Auto-update will automatically enrich new rows as they are added - The "Only run if" option allows you to set conditions for when the AI runs. For example, you can specify that the AI only runs if certain data fields are filled. This document talks about the use case in more detail and has an FAQ section as well: https://www.clay.com/university/guide/write-to-table-integration-overview