Get Thousands Cheap Leads with Apollo.io & Apify · published 9 July 2025
Play at 4:09 Watch on YouTube Leads
How do I export scraped Apollo leads and keep the personal emails?
I export the finished Apify run to Excel, keep the personal emails, and delete the rows that have no address. That export does not exist anymore, because Apify removed the Apollo actors on 22 September 2025.
Export is in the upper right. I usually choose Excel, and I can take every column or only some: employment history, organization, photo URL, title, headline, and the rest of the list. For a cold email I keep the organization name, so an AI can search the web and write an icebreaker later. I do not send the email in this video. Instantly is the sending tool I mention, and I say it is pricey.
I highlight the header so it stays put when I sort. I replace the work-email column with the personal emails, because a personal address gets opened more often, and then I delete the work-email column. I sort by email. Many rows are blank. I can ask an AI to find the missing ones, or I keep only the rows that already have an address. In this run that was about 350, and I call it a poor batch because I had skipped the email-status filter.