Extract Contacts from Apollo Enriched Company List into Separate Rows

AJ Cassata · 2024-08-29 15:33:49.829133+00

*Separate question -* I enriched a list of companies using Apollo find contacts. How do I get all of the people results into separate rows, or another table from here, and all the associated data points that came back in the array?

Extract Contacts from Apollo Enriched Company List into Separate Rows | Clay

13 comments

· Sorted by Oldest

Muhammad
·
·
Hover your mouse over People and click on write to other table
AJ Cassata
·
·
Hey Bo (Clay) Thanks for the help, I followed what's in the video correctly (I think) and am getting an error for all columns. The error doesn't give any info, it just says "integration error" Here's my table, and a screenshot https://app.clay.com/workspaces/310596/tables/t_cDdXoK9GrGU9/views/gv_Wve7KqMggHpx What went wrong here? Also, 2nd question -- what if I want to only write up the the first 3 people from "Find Contacts" at company.
So see how some of the apollo enrichment results came back with 7-10+ people results. I only want to email 3 contacts per company max. How do I filter this ? Is this possible via the Write to table process, or is this something I would have to do after the fact, in the new table, to filter for only 3 contacts per company, and if yes- how ?
AJ Cassata
·
·
okay thank you!
AJ Cassata
·
·
I ran into issues when Appending data from a table using "Lookup", as shown in the video up above^^
AJ Cassata
·
·
In the video, when you did lookup, it shows all columns of data for each row, that you can choose from to add as a list in the new table
AJ Cassata
·
·
when I did it, it only returned a few columns of data
AJ Cassata
·
·
AJ Cassata
·
·
See the screenshot - the table where I tried Lookup, only returned 6 columns of data, not all columns of data
AJ Cassata
·
·
compared to the instructional video which shows a plethera of data
AJ Cassata
·
·
AJ Cassata
·
·
What did I do wrong? This is the table referenced https://app.clay.com/workspaces/310596/tables/t_RCKcJb3sZmvK/views/gv_FBij5yRTvaqV
Bruno (Clay)
·
·
Hi Alexander, thank you for reaching out. The issue you're encountering with the missing columns here is because of the properties need to be parsed into non-enrichment columns. Once that’s done, the lookup will be able to find the records for you. Here's a video showing you how you can address this: https://www.loom.com/share/7177cd1af8fe4767ae7bef55ff856b4a?sid=e51254a8-46ec-4c4d-a89a-f74edf4da0ed I hope this was helpful. If there's anything else I can assist you with, please let me know!
AJ Cassata
·
·
makes sense thank you Bruno (Clay)

Muhammad
·
·
Hover your mouse over People and click on write to other table
AJ Cassata
·
·
Hey Bo (Clay) Thanks for the help, I followed what's in the video correctly (I think) and am getting an error for all columns. The error doesn't give any info, it just says "integration error" Here's my table, and a screenshot https://app.clay.com/workspaces/310596/tables/t_cDdXoK9GrGU9/views/gv_Wve7KqMggHpx What went wrong here? Also, 2nd question -- what if I want to only write up the the first 3 people from "Find Contacts" at company.
So see how some of the apollo enrichment results came back with 7-10+ people results. I only want to email 3 contacts per company max. How do I filter this ? Is this possible via the Write to table process, or is this something I would have to do after the fact, in the new table, to filter for only 3 contacts per company, and if yes- how ?
AJ Cassata
·
·
okay thank you!
AJ Cassata
·
·
I ran into issues when Appending data from a table using "Lookup", as shown in the video up above^^
AJ Cassata
·
·
In the video, when you did lookup, it shows all columns of data for each row, that you can choose from to add as a list in the new table
AJ Cassata
·
·
when I did it, it only returned a few columns of data
AJ Cassata
·
·
AJ Cassata
·
·
See the screenshot - the table where I tried Lookup, only returned 6 columns of data, not all columns of data
AJ Cassata
·
·
compared to the instructional video which shows a plethera of data
AJ Cassata
·
·
AJ Cassata
·
·
What did I do wrong? This is the table referenced https://app.clay.com/workspaces/310596/tables/t_RCKcJb3sZmvK/views/gv_FBij5yRTvaqV
Bruno (Clay)
·
·
Hi Alexander, thank you for reaching out. The issue you're encountering with the missing columns here is because of the properties need to be parsed into non-enrichment columns. Once that’s done, the lookup will be able to find the records for you. Here's a video showing you how you can address this: https://www.loom.com/share/7177cd1af8fe4767ae7bef55ff856b4a?sid=e51254a8-46ec-4c4d-a89a-f74edf4da0ed I hope this was helpful. If there's anything else I can assist you with, please let me know!
AJ Cassata
·
·
makes sense thank you Bruno (Clay)