Extract Business Emails from Google Maps to Google Sheets

This n8n workflow creates a powerful, free lead generation system that scrapes business listings from Google Maps based on user-defined search queries (e.g., 'Miami lawyers' or 'Calgary dentists'). It extracts real website URLs using regex filtering, visits each site to find and validate email addresses, removes duplicates and invalid entries, and automatically exports the clean email list to a Google Sheets tab.

Key benefits include no reliance on paid APIs, full automation from search to spreadsheet, and scalability for large lead lists. It's ideal for marketers, sales teams, or agencies generating targeted leads without manual effort, saving hours of scraping and data entry time.

Use cases span industries like real estate, legal services, healthcare, and more. Setup involves creating a Google Sheet with 'searches' and 'emails' tabs, connecting credentials, and updating the document ID. Test with small batches before scaling, making it accessible for beginners while powerful for pros in lead gen.