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: storesdata sheet: 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. Load Search Criteria: Reads queries marked with "X" from keywordsearches 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 storesdata 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 businessid 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 query 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
