How do you export the people that Apollo finds as part of your export?

Hey Jeanne, thanks for reaching out! To clarify, do you need to export that list out of Clay or are you looking to get the emails?

I took a quick look at the table and it looks like it has the Write to table integration properly set up to move the people from one table to another.About the emails: This is due to the fact that Apollo fixed a bug in their API that had been there for months and why it now says "­[email­_not­_unlocked@domain.com](mailto:email_not_unlocked@domain.com)".Apollo’s API was designed so that when you search for people, a person’s email address wasn’t added to the response unless you had used apollo credits and saved them as a contact to your apollo account.However, you can still use Apollo's Enrich Person integration to get that value.

Hey, sorry for the delay. Many threads coming in today :)

We don't have an article on that exactly, but it's very straightforward too. All that needs to be done is select the enrichment and add the inputs (in this case the columns with the contact's names and domains). Once you run, it should return people's additional information which could also be the email

About exporting the entire list of contacts from the original table, unfortunately, we don't have and don't recommend doing that because if you extract the entire list of people there (in the company table) it could re-run other enrichments that already previously ran and just burn extra credits for the same data you already collected once

Our approach and way to keep info clean is to have a Company table and a People table so corresponding enrichments can be used and make credit usage much more efficient and cost-effective. So yeah, from the people table that's where you use this integration

The first link you sent... https://app.clay.com/workspaces/11130/tables/t­_q6XyciPQeCDr/views/gv­_Rc17bKtH4ybD

I took a quick look but it appears there's no relevant data that was pushed. I can help correct that so you can continue with the enrichment.

There we go, I just re-mapped the Write to table integration so the appropriate data points get pushed over to the People Table and now the Enrich Person Integration can be used with the corresponding inputs :)

I pushed the contact ID so it's much easier and that's the only input it would require. Figured I'd add the Enrich column for you but from there it should be easy to follow what steps were taken

Sorry for the delay! The contact ID came from the initial Apollo Find People search, each person should have one.

­

Yep, correct. I believe we were able to achieve that yesterday and pushed them to this table but it appears there's nothing there anymore. Did your client happen to delete the records?https://app.clay.com/workspaces/11130/tables/t­_q6XyciPQeCDr/views/gv­_Rc17bKtH4ybD

All that's needed is to re-run the Write to table integration in the original table so they get created again

Let me know if I can re-run that column to created the contacts again.

I'll DM a loom video of the steps I followed so it's easier for you and the client to recreate it.

Okay, will record it. I'll have to make some updates cause I see some things changed from how I originally mapped the columns

Awesome! Just DM'd you the video. Hope it help!