Extract business emails from Google Maps to Google Sheets for lead generation

How it Works

This workflow builds a free lead generation system that scrapes emails from Google Maps listings and exports them directly into Google Sheets. It’s built in n8n using HTTP requests and JavaScript—no paid APIs required.

Here’s what it does at a high level:

• 🔎 Scrapes business listings from Google Maps based on search queries (e.g., “Miami lawyers”)
• 🌐 Extracts real business website URLs using regex filtering
• 📧 Finds and validates email addresses from each website
• 🧹 Cleans data by removing duplicates and invalid entries
• 📊 Exports clean email lists into Google Sheets automatically

Set Up Steps

• Estimated setup time: 1–2 hours

• Create a Google Sheet with two tabs:

  • searches → add your search queries (e.g., “Calgary dentist”)
  • emails → results will be stored here automatically

• Connect Google Sheets credentials in n8n

• Update your Google Sheet document ID in the workflow nodes

• Test with small batches first, then scale up

🚀 Get More Resources & Advanced Workflows

For additional resources, advanced automation tutorials, and business strategies that help you generate more leads and grow your agency, check out my website:

👉 Noman Mohammad

You’ll find downloads, guides, and proven systems used by successful marketers and entrepreneurs.