Get Started
Back to Templates

Generate Business Leads from Google Maps & Places API to Google Sheets

Created by

Created by: Aryan Shinde || shindearyan

Aryan Shinde

Last update

Last update 20 hours ago

Categories

Share

Overview

This workflow automates the process of generating niche-specific business leads from Google Maps, leveraging the Google Places API and Google Sheets for seamless data collection and storage.

Who Is This For?

  • Business owners, marketers, sales teams, or anyone needing to build targeted lead lists by business type and location quickly.

Main Use Cases

  • Building outreach lists for local marketing campaigns.
  • Finding potential clients in a specific location and industry.
  • Automating research for sales prospecting.

How It Works

  1. Collect Inputs via Form:
    Gather your business type (search term), target location, desired number of results, and Google Maps API key using a simple built-in form.
  2. Geocode Location:
    The workflow automatically converts your location input into geographic coordinates.
  3. Search Businesses:
    It utilizes the Google Places API to search for businesses that match your criteria within a 10-km radius of your location.
  4. Extract & Validate Data:
    For each business found, it extracts key contact details (name, address, phone, website, etc.), validates for essential info, and automatically appends valid leads into your connected Google Sheet—ready for action.

Prerequisites

Setup Steps

  1. Connect your Google Sheets account inside n8n.
  2. Obtain a Google Maps API key (usually takes a few minutes from the Google Cloud Console).
  3. Configure the workflow:
    • Fill out the form inside the workflow with your business type, location, number of results, and your API key.
  4. Run the workflow and watch qualified leads flow into your Google Sheet in real-time.

Customization Options

  • Adjust the search radius or result count to match your needs.
  • Extend extracted fields or add filters for advanced lead qualification.
  • Change the Google Sheet structure as per your business process.

Example Output

Each row in your sheet contains:

  • Business Name
  • Address
  • Phone
  • Website
  • Google Maps URL
  • Ratings & Reviews
  • Business Types
  • Search Query & Location
  • Scraped At timestamp

Tip:
For more details and advanced customizations, refer to the in-workflow sticky notes.