Clay Icon
Join the Community
02 Support

Issue with Extracting Personal Email from Apollo API

Avatar of BrayanBrayan
·
·

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?

3 comments

  • Avatar of Channeled
    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)

  • Avatar of Brayan
    Brayan
    ·
    ·

    How do I get personal email from A CSV that has a link of a website?

  • Avatar of Channeled
    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.