Extract Business Contact Leads from Google Maps with RapidAPI and Google Sheets

Follow me on LinkedIn for more!

Category: Lead Generation, Data Collection, Business Intelligence

Tags: lead-generation, google-maps, rapidpi, business-data, contact-extraction, google-sheets, duplicate-prevention, automation

Difficulty Level: Intermediate

Estimated Setup Time: 15-20 minutes

Template Description

Overview

This powerful n8n workflow automates the extraction of comprehensive business information from Google Maps using keyword-based searches via RapidAPI's Local Business Data service. Perfect for lead generation , market research , and competitive analysis , this template intelligently gathers business data including contact details, social media profiles, and location information while preventing duplicates and optimizing API usage.

Key Features

• 🔍 Keyword-Based Google Maps Scraping : Search for any business type in any location using natural language queries
• 📧 Contact Information Extraction : Automatically extracts emails, phone numbers, and social media profiles (LinkedIn, Instagram, Facebook, etc.)
• 🚫 Smart Duplicate Prevention : Two-level duplicate detection saves 50-80% on API costs by skipping processed searches and preventing duplicate business entries
• 📊 Google Sheets Integration : Seamless data storage with automatic organization and structure
• 🌍 Multi-Location Support : Process multiple cities, regions, or countries in a single workflow execution
• ⚡ Rate Limiting & Error Handling : Built-in delays and error handling ensure reliable, uninterrupted execution
• 💰 Cost Optimization : Intelligent batching and duplicate prevention minimize API usage and costs
• 📱 Comprehensive Data Collection : Gather business names, addresses, ratings, reviews, websites, verification status, and more

Prerequisites

Required Services & Accounts

1. RapidAPI Account with subscription to "Local Business Data" API
2. Google Account for Google Sheets integration
3. n8n Instance (cloud or self-hosted)

Required Credentials

• RapidAPI HTTP Header Authentication for Local Business Data API
• Google Sheets OAuth2 for data storage and retrieval

Setup Instructions

Step 1: RapidAPI Configuration

1. Create a RapidAPI Account

   • Sign up at RapidAPI.com
   • Navigate to "Local Business Data" API
   • Subscribe to a plan (Basic plan supports 1000 requests/month)

2. Get API Credentials

   • Copy your X-RapidAPI-Key from the API dashboard
   • Note the host: local-business-data.p.rapidapi.com

3. Configure n8n Credential

   • In n8n: Settings → Credentials → Create New
   • Type: HTTP Header Auth
   • Name: RapidAPI Local Business Data
   • Add headers:
     • X-RapidAPI-Key : YOUR_API_KEY
     • X-RapidAPI-Host : local-business-data.p.rapidapi.com

Step 2: Google Sheets Setup

1. Enable Google Sheets API

   • Go to Google Cloud Console
   • Enable Google Sheets API for your project
   • Create OAuth2 credentials

2. Configure n8n Credential

   • In n8n: Settings → Credentials → Create New
   • Type: Google Sheets OAuth2 API
   • Follow the OAuth2 setup process

3. Create Google Sheet Structure

Create a new Google Sheet with these tabs:

keyword_searches sheet:

 | select | query | lat | lon | country_iso_code | 
|--------|-------|-----|---------------------|
 | X | Restaurants Madrid | 40.4168 | -3.7038 | ES |
 | X | Hair Salons Brooklyn | 40.6782 | -73.9442 | US |
 | X | Coffee Shops Paris | 48.8566 | 2.3522 | FR |

stores_data sheet:

 The workflow will automatically create columns for business data including:
 business_id, name, phone_number, email, website, full_address, rating,
 review_count, linkedin, instagram, query, lat, lon, and 25+ more fields

Step 3: Workflow Configuration

1. Import the Workflow

   • Copy the provided JSON
   • In n8n: Import from JSON

2. Update Placeholder Values

   • Replace YOUR_GOOGLE_SHEET_ID with your actual Google Sheet ID
   • Update credential references to match your setup

3. Configure Search Parameters (Optional)

   • Adjust limit : 1-100 results per query (default: 100)
   • Modify zoom : 10-18 search radius (default: 13)
   • Change language : EN, ES, FR, etc. (default: EN)

How It Works

Workflow Process

1. Load Search Criteria : Reads queries marked with "X" from keyword_searches sheet
2. Load Existing Data : Retrieves previously processed data for duplicate detection
3. Filter New Searches : Smart merge identifies only new query+location combinations
4. Process Each Location : Sequential processing prevents API overload
5. Configure Parameters : Prepares search parameters from sheet data
6. API Request : Calls RapidAPI to extract business information
7. Parse Data : Structures and cleans all business information
8. Save Results : Stores new leads in stores_data sheet
9. Rate Limiting : 10-second delay between requests
10. Loop : Continues until all new searches are processed

Duplicate Prevention Logic

Search Level : Compares new queries against existing data using query+latitude combination, skipping already processed searches.

Business Level : Each business receives a unique business_id to prevent duplicate entries even across different searches.

Data Extracted

Business Information

• Business name, full address, phone number
• Website URL, Google My Business rating and review count
• Business type, price level, verification status
• Geographic coordinates (latitude/longitude)
• Detailed location breakdown (street, city, state, country, zip)

Contact Details

• Email addresses (when publicly available)
• Social media profiles: LinkedIn, Instagram, Facebook, Twitter, YouTube, TikTok, Pinterest
• Additional phone numbers
• Direct Google Maps and reviews links

Search Metadata

• Original search queries and parameters
• Extraction timestamp and geographic data
• API response details for tracking

Use Cases

Lead Generation

• Generate targeted prospect lists for B2B sales
• Build location-specific customer databases
• Create industry-specific contact lists
• Develop territory-based sales strategies

Market Research

• Analyze competitor density in target markets
• Study business distribution