Latenode
Google sheets
Headless browser

Automate Business Email Extraction from Google Maps

This n8n workflow template automates the process of scraping business email addresses from Google Maps listings without relying on any third-party APIs or paid services. Designed for sales, marketing, and business development professionals, the workflow allows users to generate qualified leads in a cost-effective manner by providing a list of queries based on business type and target region.

The workflow fetches the URLs of relevant business listings, extracts email addresses from the HTML content using custom JavaScript, deduplicates the results, and saves the final list of emails to a specified Google Sheets spreadsheet. By leveraging only the core n8n nodes, this template ensures there are no additional costs involved, making it an efficient solution for lead generation.

Updated Apr 2, 2026Est. run: 7sEst. cost: $0.0004
How Latenode estimates time and cost

Latenode bills workflow runs in credits: 1 credit = 30 seconds of processing. Minimum charge per run depends on your plan. Plug-and-Play (PnP) AI nodes are billed separately—each PnP token is $1 USD, charged pay-as-you-go at vendor cost plus a small processing fee, with no API keys required.

Full pricing — how credits work →
Scraping & data collection

Workflow preview

What this template does

  • Scrapes business email addresses from Google Maps listings without relying on third-party APIs or paid services.
  • Generates a list of qualified leads based on business type and target region.
  • Fetches relevant business listing URLs and extracts email addresses from HTML content using custom JavaScript.
  • Deduplicates the extracted email addresses and saves the final list to a Google Sheets spreadsheet.
  • Leverages only the core n8n nodes, ensuring no additional costs are involved for the lead generation process.

How it works

1
Trigger

Specify target business type and location

The user provides a list of business types and target regions to search for on Google Maps.

2
Action

Fetch Google Maps listings

The workflow uses a headless browser to search Google Maps and retrieve the HTML content of the relevant business listings.

3
Logic

Extract email addresses

Custom JavaScript extracts the email addresses from the HTML content of the Google Maps listings.

4
Action

Save to Google Sheets

The extracted email addresses are deduplicated and appended to a specified Google Sheets spreadsheet.

Setup guide

1

Configure Google Maps Search

1. Add a 'Google Maps Search' node to your workflow canvas. 2. In the node settings, provide a list of queries to search Google Maps. Each query should contain keywords related to the type of business and the target region or subregion you want to search for. 3. Optionally, you can configure additional settings in the Google Maps Search node, such as the number of results to fetch per query.

2

Set up Google Sheets Integration

1. Add a 'Google Sheets' node to your workflow canvas. 2. In the Latenode Credentials panel, create a new Google Sheets credential by connecting your Google account via OAuth. 3. In the Google Sheets node settings, select the Google Sheets document and sheet where you want to save the scraped email addresses.

3

Configure Email Scraping

1. Add a 'Code' node to your workflow canvas. 2. In the JavaScript node settings, use the provided JavaScript code to extract email addresses from the HTML content of the Google Maps listings. 3. Customize the regular expressions in the code as needed to refine the email extraction logic or extract additional information.

4

Handle Duplicate Email Removal

1. Add a 'Split out into default data structure' node after the 'Aggregate arrays of emails' node. 2. Connect the 'Remove duplicate emails' node to the output of the 'Split out into default data structure' node. 3. Configure the 'Remove duplicate emails' node to deduplicate the extracted email addresses.

5

Save Emails to Google Sheets

1. Connect the 'Remove duplicate emails' node to the 'Google Sheets' node you configured earlier. 2. In the Google Sheets node settings, verify that the correct Google Sheets document and sheet are selected for saving the scraped email addresses.

Requirements

Google Maps account to access business listings
Google Sheets account and spreadsheet to store the extracted email addresses
Set up a Latenode workspace with the 'google-sheets', 'code', and 'headless-browser' nodes
Configure the headless browser node to scrape Google Maps pages and extract email addresses from the HTML content

FAQ

Common questions about this template

Each run uses credits on your Latenode plan. We charge for processing time (1 credit = 30 seconds). Your actual cost depends on your plan and how long the run takes. See pricing plans for plans and how credits work.
Contact support →

More templates

You might also like

Browse all templates →
Scraping & data collection

Scrape and export Google Maps business data to Google Sheets

This automation allows users to efficiently scrape business data from Google Maps, including names, contact details, and reviews, and export the structured information into a spreadsheet or database for lead generation and market analysis. The workflow triggers manually or on a scheduled basis, fetching search results from Google Maps using the SerpAPI service, deduplicating the data, and writing it to a Google Sheet. This streamlines the process of gathering valuable business intelligence from Google Maps, empowering users to leverage this data for strategic decision-making and sales prospecting.

11s$0.0007
Scraping & data collection

Scrape Zillow property data and sync to Google Sheets automatically

This Latenode automation extracts real estate listing details from Zillow and automatically populates a Google Sheets spreadsheet with the property data. It leverages the Scrape.do web scraping API to bypass anti-bot protections and fetch the full HTML of Zillow listings, then parses key information like price, address, days on Zillow, and Zestimate, and saves the structured results into a Google Sheet. This solution is designed for real estate professionals, investors, and market analysts who need to collect property data at scale without manual effort, enabling better market research, portfolio tracking, and lead generation.

9s$0.0006
Scraping & data collection

Automate Instagram profile data export to Google Sheets

This automation template allows users to scrape comprehensive Instagram profile data using the Apify platform, and automatically export the results into a Google Sheets spreadsheet for analysis. It is designed to run on a schedule, processing a list of usernames by calling the Apify API, appending the scraped data to a Google Sheet, and marking the usernames as processed. The automation integrates with Google Sheets and the Apify actor, providing a streamlined way to gather and organize Instagram profile information without manual intervention.

15s$0.0009