Google Maps Lead Scraping with Emails without any paid tools

📧 Automated Lead Enrichment from Google Maps 🗺️

Tired of manual data entry? This powerful n8n workflow automates the process of enriching your Google Maps leads by scraping their websites for emails and updating your spreadsheet in a single click. It's a 100% free solution to supercharge your lead generation efforts!

How It Works

1. Lead Ingestion: Use a free browser extension to scrape leads from Google Maps and import them directly into a Google Sheet.
2. Website Crawling: The n8n workflow reads the leads from your sheet and automatically crawls each website to find all internal pages.
3. Email Extraction: For each page, the workflow intelligently scrapes for email addresses, filtering out image files and other non-relevant data.
4. Enrich and Update:
   • If an email is found, the workflow updates the corresponding row in your Google Sheet with the new email address.
   • If no email is found after crawling the main page and all sub-pages, it marks the lead as "Not Found" so you can easily track your progress.

Requirements

• n8n: A self-hosted or cloud instance of n8n.
• Google Sheets: A Google account with a designated spreadsheet for your Google Maps leads.
• Browser Extension: A free Google Maps scraping extension to get your initial lead data into the Google Sheet.

How to Use

1. Set up your spreadsheet: Use the browser extension to scrape leads from Google Maps and populate your Google Sheet. Make sure the sheet has a column named "Website" and a column named "Processed for Email" (with an initial value of "Pending").
2. Configure the workflow: Import this n8n workflow JSON into your n8n instance and connect your Google Sheets credentials.
3. Run the workflow: Click the "Execute workflow" button to start the process. The workflow will automatically begin crawling websites and enriching your lead list with emails.