Need Help Creating a Bulk Table from Apollo Integration in Clay

Vasileios K. · 2024-12-02 15:37:30.40456+00

I am a beginner in Clay and need some help please. I have a list of 2000 companies and I ran the automation to find certain people from these companies with the apollo integration. My issue is that I cannot find how I run an automation to create a table including all these people. All I can do is click inside each one of them and do it but I cannot do this in bulk.

Need Help Creating a Bulk Table from Apollo Integration in Clay | Clay

8 comments

· Sorted by Oldest

Channeled
APP
·
·
Here's how to create a table with people from multiple companies: 1. First, create a new Company table: • Open your workspace • Click "Create New" > "Table" • Select "Company Table" 2. Once you have your company table populated with the 2000 companies, you can use Apollo.io integration to find people: • Use the Apollo.io integration to search for specific job titles • You can specify company domains to narrow your search • Set your desired limit for the number of people returned 3. To find contacts at specific companies: • Add the contacts as new columns in your table • The system will automatically find relevant professional connections within the context of your specified companies Sources: Create New Table Find People By Job Title with Apollo.io Find Contacts at Company with Companies, People, Jobs
Adnan M.
·
·
You need to write this data to another table using the Write to another table integration
Channeled
APP
·
·
Here's how to set up the Write to Table integration to consolidate people found from multiple companies: 1. First, use the Apollo.io integration to find people at your target companies. 2. Then set up Write to Table following these steps: • Select your Clay account • Choose or create a destination table for all your contacts • Skip the list selection by entering "/" • Map the relevant columns from your source table (with Apollo results) to your destination tableThis setup works well for "1 to many" relationships, where one company has multiple contacts.Pro tip: Enable the "Auto-update" setting if you want new rows to be automatically added when more people are found. Sources: Write to Table - Clay University Find People By Job Title with Apollo.io Write to Table [Clay 101] - Clay University Find People at Company By Job Title with Apollo.io
Vasileios K.
·
·
Adnan M. can I do it on bulk? because I get one contact per row
Channeled
APP
·
·
Yes, you can use Write to Table to consolidate multiple contacts into a single table. This is particularly useful for handling "one-to-many" relationships, like when one company has multiple contacts.Here's how to do it: 1. Set up Write to Table by selecting your Clay account 2. Choose your destination table 3. Select the column containing your contact lists 4. Map the list properties to the appropriate columns in your new tableYou can enable auto-update to automatically enrich new rows as they're added.For example, if you're using the find contacts search option in the enrichment tab, you can save the results into your table and run enrichments for each contact found. This will allow you to have all contact data consolidated in one place. Sources: Write to Table [Clay 101] - Clay University Write to Table - Clay University
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.
Adnan M.
·
·
Yes. You will get each of those 10 contacts on its own row, just like one you would need to upload to smartlead or instantly. So if cell 1 found 10 contacts, that's 10 rows. If cell 2 found 3 contacts, that's 3 more rows, and so on.
Vasileios K.
·
·
I think that I got it, thank you so much
🤝1

Channeled
APP
·
·
Here's how to create a table with people from multiple companies: 1. First, create a new Company table: • Open your workspace • Click "Create New" > "Table" • Select "Company Table" 2. Once you have your company table populated with the 2000 companies, you can use Apollo.io integration to find people: • Use the Apollo.io integration to search for specific job titles • You can specify company domains to narrow your search • Set your desired limit for the number of people returned 3. To find contacts at specific companies: • Add the contacts as new columns in your table • The system will automatically find relevant professional connections within the context of your specified companies Sources: Create New Table Find People By Job Title with Apollo.io Find Contacts at Company with Companies, People, Jobs
Adnan M.
·
·
You need to write this data to another table using the Write to another table integration
Channeled
APP
·
·
Here's how to set up the Write to Table integration to consolidate people found from multiple companies: 1. First, use the Apollo.io integration to find people at your target companies. 2. Then set up Write to Table following these steps: • Select your Clay account • Choose or create a destination table for all your contacts • Skip the list selection by entering "/" • Map the relevant columns from your source table (with Apollo results) to your destination tableThis setup works well for "1 to many" relationships, where one company has multiple contacts.Pro tip: Enable the "Auto-update" setting if you want new rows to be automatically added when more people are found. Sources: Write to Table - Clay University Find People By Job Title with Apollo.io Write to Table [Clay 101] - Clay University Find People at Company By Job Title with Apollo.io
Vasileios K.
·
·
Adnan M. can I do it on bulk? because I get one contact per row
Channeled
APP
·
·
Yes, you can use Write to Table to consolidate multiple contacts into a single table. This is particularly useful for handling "one-to-many" relationships, like when one company has multiple contacts.Here's how to do it: 1. Set up Write to Table by selecting your Clay account 2. Choose your destination table 3. Select the column containing your contact lists 4. Map the list properties to the appropriate columns in your new tableYou can enable auto-update to automatically enrich new rows as they're added.For example, if you're using the find contacts search option in the enrichment tab, you can save the results into your table and run enrichments for each contact found. This will allow you to have all contact data consolidated in one place. Sources: Write to Table [Clay 101] - Clay University Write to Table - Clay University
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.
Adnan M.
·
·
Yes. You will get each of those 10 contacts on its own row, just like one you would need to upload to smartlead or instantly. So if cell 1 found 10 contacts, that's 10 rows. If cell 2 found 3 contacts, that's 3 more rows, and so on.
Vasileios K.
·
·
I think that I got it, thank you so much
🤝1