.png){kind=logo}
Push HubSpot Contact Find Results into a New Table
is there a way to push all the results found from a hubspot contact find into a new table?
is there a way to push all the results found from a hubspot contact find into a new table?
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.
not helpful - can’t create that list as they are company filters
use write to enrichment and select the results, then map out the columns to write them as new rows in a new table
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.
that is amazing - thank you for the help - now I understood it 🙌
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