Extract Contacts from Apollo Enriched Company List into Separate Rows

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?

13 comments

Muhammad S.
·
·
Hover your mouse over People and click on write to other table
AJ C.
·
·
Hey Bo (. 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 C.
·
·
okay thank you!
AJ C.
·
·
I ran into issues when Appending data from a table using "Lookup", as shown in the video up above^^
AJ C.
·
·
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 C.
·
·
when I did it, it only returned a few columns of data
AJ C.
·
·
AJ C.
·
·
See the screenshot - the table where I tried Lookup, only returned 6 columns of data, not all columns of data
AJ C.
·
·
compared to the instructional video which shows a plethera of data
AJ C.
·
·
AJ C.
·
·
What did I do wrong? This is the table referenced https://app.clay.com/workspaces/310596/tables/t_RCKcJb3sZmvK/views/gv_FBij5yRTvaqV
Bruno R.
·
·
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 C.
·
·
makes sense thank you Bruno R.

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