In this video, I show you a simple way to make AI find emails automatically and send the results straight into your Google Sheet—no coding, no software, and it’s completely free. The same way you saw emails rolling on my screen, I’m using ChatGPT as the “extractor,” but this time I’m not writing or copying any code at all. We start by collecting a bulk list of websites from Google using search operators (for example: “plumbers in New York site:.com”), then I copy the search results into a text file. Next, I upload that file to ChatGPT and prompt it to extract only the URLs. I even ask it to remove business directories like Yellow Pages, so I’m left with cleaner targets. After that, I paste the website list into Google Sheets, then I prompt ChatGPT again to extract emails from those websites and return the results in a simple table (Website + Emails). If you don’t get many emails, the fix is simple: collect more websites and repeat. And if you want to scale beyond this beginner method, I also mention tools I use for heavy lead extraction—like LeadHarvester Pro for Google Maps leads, Mailgrab AI for scraping emails from search results, and NicheMiner AI Pro for pulling leads from social platforms.