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, rapidapi, 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 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: YOURAPIKEY - 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 OAuth2 setup process 3. Create Google Sheet Structure Create a new Google Sheet with these tabs: keywordsearches sheet: | select | query | lat | lon | countryisocode | |--------|-------|-----|-----|------------------| | 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 | storesdata sheet: The workflow will automatically create columns for business data including: businessid, name, phonenumber, email, website, fulladdress, rating, reviewcount, 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 YOURGOOGLESHEETID 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. Lo