Issue with Extracting Personal Email from Apollo API

Brayan · 2025-04-30 12:37:49.599311+00

Hi team, I have a HTTP API set up with Apollo and with SQL, when i run the enrichment to get all the information from the contact it works however when i try to extract the email it doesn't get the email but when i go directly to apollo or salesql the contact does have the personal email. Some work and some dont why?

Issue with Extracting Personal Email from Apollo API | Clay

3 comments

· Sorted by Oldest

Channeled
APP
·
·
This issue is likely due to Apollo's recent change in their API. Now, when using the "Find People at Company" enrichment, emails aren't automatically extracted. Instead, you'll see "[email_not_unlocked@domain.com](mailto:email%5Fnot%5Funlocked@domain.com)". To get the actual email, follow these steps: 1. Use "Find People at Company By Job Title" in Apollo to identify the right people. 2. Use the "write each item to new row in other table" function in Clay to extract results. 3. In the new table, use the "Enrich Person From Apollo" function. Map all necessary columns except email. 4. Run the enrichment. The saved contact's email should now be included. If you're still having issues, please share your JSON code so we can troubleshoot further.
Sources: Enrich Person with Apollo.io [FAQ: Why am I seeing email_not_unlocked@domain.com in Apollo?](https://docs.clay.com/en/articles/9757360-faq-why-am-i-seeing-email%5Fnot%5Funlocked-domain-com-in-apollo)
Brayan
·
·
How do I get personal email from A CSV that has a link of a website?
Channeled
APP
·
·
To extract personal emails from a CSV with website links, you can follow these steps: 1. Use Clay's "Extract URLs and Emails from Text" action to extract any emails directly from the website links. 2. If no emails are found, use the website links to find associated LinkedIn profiles. 3. Use the "Find Personal Email from LinkedIn URL" action with Retention.com to discover personal emails for each LinkedIn profile. 4. Alternatively, use the "Find Personal Email" action with RocketReach, which can provide recommended personal emails based on the information you have. Remember, the success rate may vary depending on the available data and the specific websites or profiles you're working with.
Sources: Find Personal Email with RocketReach Find Personal Email from LinkedIn URL (via Retention.com) with Retention.com Extract URLs and Emails from Text with Clay

Channeled
APP
·
·
This issue is likely due to Apollo's recent change in their API. Now, when using the "Find People at Company" enrichment, emails aren't automatically extracted. Instead, you'll see "[email_not_unlocked@domain.com](mailto:email%5Fnot%5Funlocked@domain.com)". To get the actual email, follow these steps: 1. Use "Find People at Company By Job Title" in Apollo to identify the right people. 2. Use the "write each item to new row in other table" function in Clay to extract results. 3. In the new table, use the "Enrich Person From Apollo" function. Map all necessary columns except email. 4. Run the enrichment. The saved contact's email should now be included. If you're still having issues, please share your JSON code so we can troubleshoot further.
Sources: Enrich Person with Apollo.io [FAQ: Why am I seeing email_not_unlocked@domain.com in Apollo?](https://docs.clay.com/en/articles/9757360-faq-why-am-i-seeing-email%5Fnot%5Funlocked-domain-com-in-apollo)
Brayan
·
·
How do I get personal email from A CSV that has a link of a website?
Channeled
APP
·
·
To extract personal emails from a CSV with website links, you can follow these steps: 1. Use Clay's "Extract URLs and Emails from Text" action to extract any emails directly from the website links. 2. If no emails are found, use the website links to find associated LinkedIn profiles. 3. Use the "Find Personal Email from LinkedIn URL" action with Retention.com to discover personal emails for each LinkedIn profile. 4. Alternatively, use the "Find Personal Email" action with RocketReach, which can provide recommended personal emails based on the information you have. Remember, the success rate may vary depending on the available data and the specific websites or profiles you're working with.
Sources: Find Personal Email with RocketReach Find Personal Email from LinkedIn URL (via Retention.com) with Retention.com Extract URLs and Emails from Text with Clay