Is it completely free?

Yes, it uses only free HTTP requests and Google Sheets with no paid API keys required.

What do I need to run it?

An n8n instance, a Google account for Sheets, and basic workflow setup with the provided HTTP Request and Google Sheets nodes.

How do I import this workflow?

Copy the JSON workflow file into n8n via the import option and connect your Google Sheets credentials.

Lead Generation System: Google Maps to Email Scraper with Google Sheets Export

Verified

Scrapes business emails from Google Maps and exports leads to Google Sheets.

n8nSales & CRMBeginner👁 2.4K views

Open template

Updated 2026-06-15

What this workflow does

This automation connects HTTP Request and Google Sheets to pull business contact details from Google Maps searches and record them in a spreadsheet.

It is intended for sales professionals and marketers who need a simple integration to collect and manage location-based leads.

Who is this for?

Sales teams, marketers, and small business owners running lead generation campaigns who need targeted business contacts without paid scraping tools.

What problem it solves

Manually finding and extracting business emails from Google Maps is slow and expensive; this workflow automates the process using only free HTTP requests and Google Sheets.

Live workflow preview

Interactive canvas of every node and connection — scroll and click to explore. Powered by n8n's preview.

Open the template on n8n to import and run it. View source template →

What it automates

Local service outreach

Search for dentists or restaurants in a city like Calgary and collect contact emails for direct marketing campaigns.

Industry list building

Generate lists of businesses in a specific sector across multiple locations for B2B sales prospecting.

Geographic lead targeting

Pull verified emails from Google Maps results in chosen regions and store them cleanly in Google Sheets for follow-up.

How the workflow works

The 3 nodes in this automation, in order.

1Google SheetsgoogleSheets
2HTTP RequesthttpRequest
3Codecode

Apps & integrations used

Google SheetsHTTP Request

How to set up Lead Generation System: Google Maps to Email Scraper with Google Sheets Export

1Create a new n8n workflow and add an HTTP Request node configured for Google Maps search URLs.
2Add a JavaScript node to parse website URLs from the HTTP response using regex filters.
3Insert a Loop node to process each website URL individually with delays.
4Add another HTTP Request node to fetch each business website HTML.
5Use a JavaScript node with regex to extract email addresses from the HTML.
6Connect a Google Sheets node to append cleaned, deduplicated emails to your spreadsheet.

How to customize this workflow

→Change the search query parameter in the first HTTP Request node to target different cities or business types.
→Add a filter step after email extraction to remove common domains like gmail.com.
→Adjust the loop delay values to modify scraping speed and reduce blocking risk.
→Extend the Google Sheets node to include additional columns such as business name or address.