BULDRR AI Vikash KumarSchedule a Call
Updated Workflow #1321

n8n Local Business Lead Finder 2026: Extract 100+ Leads From Google Maps (Free)

This free n8n workflow extracts business contact data from Google Maps — names, phones, emails, and addresses — and builds a clean lead list for any city and niche in minutes.

n8n Local Business Lead Finder 2026: Extract 100+ Leads From Google Maps (Free)
CONNECTS
chatTrigger, agent, lmChatOpenAi, memoryBufferWindow, toolWorkflow, toolSerpApi, stickyNote, executeWorkflowTrigger, httpRequest, googleSheets, aggregate
Learn it with AI
✦ SEE IT BEFORE YOU DOWNLOAD

The canvas, and the 11 nodes behind it.

Preview of the n8n Local Business Lead Finder 2026: Extract 100+ Leads From Google Maps (Free) workflow canvas in n8n
✦ NODE BY NODE

What runs inside this workflow

n8n Local Business Lead Finder 2026: Extract 100+ Leads From Google Maps (Free) is built from these n8n nodes: chatTrigger, agent, lmChatOpenAi, memoryBufferWindow, toolWorkflow, toolSerpApi, stickyNote, executeWorkflowTrigger, httpRequest, googleSheets, aggregate.

    ✦ LEARN HOW TO BUILD THIS WORKFLOW WITH AI
    Send this workflow to your assistant and have it taught to you.

    Each button opens the assistant with the prompt already written — asking it to explain this exact workflow step by step, as if teaching a complete beginner.

    Using our workflows often?
    Mark BULDRR AI as a preferred source and our templates surface higher in your own Google results.
    Add as a preferred source
    This free n8n workflow works as an automated lead finder — not just a data scraper. Type in any business type and city, and it pulls 100+ verified leads from Google Maps directly into a Google Sheet. Each lead includes the business name, phone number, website, and address — ready for outreach without any manual search. No spreadsheet work. No copy-pasting. Just a clean list of leads every time you run it.

    What this workflow does

    This workflow collects business leads by searching Google Maps and company websites automatically.   It fixes slow, error-prone manual work by organizing lead data and saving it to Google Sheets.   The main purpose is to save time and avoid mistakes in lead gathering.   The result is faster, more accurate lead lists ready for sales outreach.  

    Key tools and services

    • n8n automation platform: Runs the workflow and connects nodes.
     
    • OpenAI: Uses GPT-4o AI for understanding requests and data processing.
     
    • Google Sheets API: Stores and updates lead data records.
     
    • Apify API: Scrapes Google Maps and website content.
     
    • SerpAPI: Performs fallback Google searches when scraping is incomplete.
     

    Inputs, Processing, and Outputs

    Inputs

    • User message containing search terms, city, state, and country code.
     
    • Google Maps business listings via Apify API.
     
    • Website URLs to extract detailed content.
     

    Processing steps

    • The Webhook node receives user messages and starts the workflow.
     
    • AI Agent - Lead Collection interprets input with ethical and format rules.
     
    • GPT-4o - Generate & Process Requests plans requests and data flow.
     
    • Memory - Track Recent Context maintains conversation history to keep answers consistent.
     
    • Scrape Google Maps (via Apify) gathers business data filtered by user criteria.
     
    • Save Extracted Data to Google Sheets appends results to a spreadsheet.
     
    • Aggregate Business Listings consolidates data for easier review.
     
    • Tool - Crawl Business Website launches subworkflow to get website details.
     
    • Scrape Website Content (via Apify) extracts content from websites for lead enrichment.
       
    • Aggregate Website Content combines website details for AI use.
     
    • Fallback - Enrich with Google Search uses SerpAPI when other data is missing.
     

    Output

    • A clean spreadsheet with detailed, checked business leads for outreach.
     
    • Improved lead quality by avoiding duplicates and adding website info.
     
    • More efficient workflow enabling faster sales contact.
     

    Beginner step-by-step: How to build this in n8n

    Download and Import

    2. Download the workflow file using the Download button on this page.
     
    2. Go into the n8n editor where you want the workflow to run.
     
    2. Use "Import from File" option to upload the workflow JSON.
     

    Configure Credentials

    2. Open each node requiring keys: OpenAI, Apify, Google Sheets, SerpAPI.
     
    2. Add valid API Keys exactly as given by each service.
     
    2. Update Google Sheets Document IDs and sheet names where data should be saved.
     
    2. Check any email addresses, URLs, or folder names and adjust to your setup.
     

    Test and Activate

    2. Send a test message like "Find carpenters in San Francisco, US" to the workflow webhook.
     
    2. Watch the workflow run and check spreadsheet for results.
     
    2. Fix any API or ID errors if data does not appear correctly.
     
    2. Once tested, activate the workflow using the toggle switch for live use.
     

    Extra Notes

    2. For better performance, consider self-host n8n.
     
    2. Make sure API limits for OpenAI and Apify are enough for expected usage.
     

    Customization ideas

    • Increase or decrease the max number of places scraped by editing maxCrawledPlacesPerSearch in the Google Maps scrape node JSON.
     
    • Change the target Google Sheets Document ID and sheet names in related nodes to store data in preferred files.
     
    • Edit the AI Agent system prompt to focus on specific business types or add filters.
     
    • Add new search parameters like skipClosedPlaces or business categories by expanding the JSON body sent to the Apify API.
     

    Handling errors and failures

    No data from Google Maps Scraper API

    Check that the country code is lowercased, like "us" not "US".   Verify the city name is correct and spelled right.  

    Authorization or API key errors

    Make sure API keys for Apify, OpenAI, Google Sheets, and SerpAPI are valid and not expired.   Re-enter keys in node credential sections.  

    JSON formatting problems

    Use the n8n JSON editor to avoid syntax mistakes.   Test JSON in online validators before saving to prevent errors.  

    Summary of results

    What You Get From This Workflow ✓ 100+ business leads per search — pulled automatically from Google Maps ✓ Each lead includes name, phone, website, and address ✓ Leads saved directly to Google Sheets — no manual data entry ✓ Duplicate leads filtered out automatically by the AI agent ✓ Website data enriched via Apify for deeper contact details ✓ Fallback Google Search via SerpAPI fills gaps when Maps data is incomplete ✓ Saves 8+ hours weekly on manual lead research Download the free workflow and run your first search in under 10 minutes.  

    Frequently Asked Questions

    How does the Google Maps Scraper node work in this workflow?

    It sends a POST request to the Apify Google Maps Scraper API with search terms, city, and country code to gather business listings.

    What should be done if Google Sheets do not save the data?

    Verify the Google Sheets Document ID and sheet names are correctly set, and check that proper OAuth credentials are used.

    Can other scraping services replace Apify in this workflow?

    Yes, but <a href="https://buldrr.com/a-practical-guide-to-learning-n8n/" title="A Practical Guide to Learning n8n" data-wpil-monitor-id="2183">HTTP request nodes</a> must be modified to match the alternative scraping APIs and their JSON payload formats.

    How does the workflow avoid saving duplicate business leads?

    The <a href="https://buldrr.com/workflows/gpt4-conversational-ai-agent-n8n/" title="Build a GPT-4 Powered Conversational AI Agent with n8n" data-wpil-monitor-id="2184">AI Agent node</a> uses validation rules to detect duplicates and removes repeated entries before saving.

    Vikash Kumar
    WRITTEN BY
    Vikash Kumar
    Founder, BULDRR AI
    Building AI agents, n8n workflows and end-to-end automation for 30+ Brands across India, the US, Europe, Dubai & Australia. 7+ years of Experience saving founders real hours every week - no code required.

    Related workflows.

    All 10,467+ templates →
    FREE Automate Twist Channel Creation and Messaging with n8n This workflow automates creating and updating a channel in Twist and sending a personalized message to specific users. It eliminates manual setup errors and saves time managing Twist communications. Open template → FREE Automate IT Support with Slack and OpenAI in n8n Streamline IT support by automating Slack message handling using n8n and OpenAI. This workflow handles Slack DMs, filters bots, queries a Confluence knowledge base, and delivers AI-generated responses, improving support efficiency and response time. Open template → FREE Automate Crypto Analysis with CoinMarketCap & n8n AI Agent Discover how this unique n8n workflow leverages CoinMarketCap's multi-agent AI to deliver precise, real-time cryptocurrency insights directly via Telegram. Manage crypto data analysis efficiently with automated multi-source API integration. Open template → FREE Generate On-Brand Blog Articles Using n8n and OpenAI This workflow automates the creation of on-brand blog articles by analyzing existing company content using n8n and OpenAI. It extracts article structures and brand voice to produce consistent draft articles, saving significant content creation time. Open template → FREE Automate Archiving Spotify Discover Weekly with n8n This automation workflow solves the hassle of manually archiving your Spotify Discover Weekly playlist by automatically comparing and adding only unique tracks to an archive playlist every Monday. It saves time, avoids duplicates, and keeps your archived music collection organized effortlessly using n8n. Open template → FREE Automate Analyzing Sales Call Transcripts with n8n & AI Agents This n8n workflow automates the extraction of structured insights from sales call transcripts using AI agents focused on sales, marketing, and product teams. It streamlines data processing, enabling faster decision-making and team alignment. Open template → FREE Automated SSL Expiry Alert System with n8n & Google Sheets This n8n workflow automates SSL certificate expiry monitoring by fetching URLs from Google Sheets, checking their SSL status via SSL-Checker.io, updating the sheet with results, and sending targeted email and Telegram alerts for certificates that are invalid or near expiry. Open template → FREE Automate Task Creation in ClickUp with n8n Struggling to manually create tasks in ClickUp? This beginner-friendly n8n workflow automates task creation, saving you time and reducing errors. Learn how to create tasks automatically with a simple trigger and ClickUp integration. Open template → FREE Automate Todoist Task Snoozing with n8n Workflow Struggling to manage and snooze your Todoist tasks efficiently? This detailed n8n workflow automates moving tasks between Inbox and Snoozed projects based on due dates, saving you hours of manual task juggling and ensuring timely task returns. Open template → FREE Build OpenAI Assistant with Google Drive Using n8n Automation This workflow automates creating and updating an OpenAI-powered Travel Assistant using a Google Drive file for accurate, specific user replies. It saves time by streamlining assistant updates and chat interactions seamlessly. Open template → FREE Automate WooCommerce Product Announcements on Twitter & Telegram Save time and boost your WooCommerce store's visibility by automatically posting new product announcements on Twitter and Telegram with this n8n workflow. Avoid manual posting errors and reach your audience instantly when new products go live. Open template → FREE Automate Zendesk to Asana Task Creation with n8n This detailed guide shows how to automate task creation in Asana from new Zendesk tickets using n8n. It solves the common challenge of manually duplicating support requests into project management, saving time and reducing errors. Open template → FREE Automate Image Alt Text Auditing & Enhancement with n8n & OpenAI Discover how this n8n workflow automates auditing and enhancing image alt text from any webpage using OpenAI GPT-4. It helps fix poor or missing alt attributes quickly and accurately, saving hours of manual work and improving web accessibility. Open template → FREE Create OpenAI Citation Workflow in n8n for File Retrieval This n8n workflow automates citation and source retrieval from OpenAI's vector store files, ensuring accurate content referencing and formatted output. It solves the problem of incomplete or strange citation text generated by AI, providing reliable markdown or HTML-ready citations for file-based AI assistance. Open template → FREE Automate Squarespace Order Fulfillment with n8n Workflow This n8n workflow automates order fulfillment for Squarespace Commerce by fetching pending orders and fulfilling them automatically, saving hours of manual work. It ensures timely fulfillment and customer notifications with seamless API integration. Open template → FREE Phishing Analysis Automation with n8n, URLScan.io & VirusTotal Automate phishing URL analysis with n8n using URLScan.io and VirusTotal. This workflow extracts URLs from unread Outlook emails, scans for threats, and reports via Slack, saving hours on threat detection. Open template → FREE Automate Image Analysis with Local Ollama Vision Models in n8n Struggling to extract detailed insights from images for business or research? This n8n workflow automates exhaustive image analysis using multiple local Ollama Vision Models, delivering structured, markdown-formatted results saved directly to Google Docs for collaboration and ease of use. Open template → FREE Automate Website Change Alerts N8N Telegram — Complete Guide [2026] Learn how to automate website change alerts n8n telegram with this step-by-step guide. Includes workflow examples, tips, and best practices for 2026. Open template → FREE Automate Text-to-Speech with Elevenlabs & n8n Webhook Save hours in your content creation by automating text-to-speech generation using n8n's webhook and Elevenlabs API. This workflow ensures seamless audio generation from text inputs, eliminating manual conversion errors and delays. Open template → FREE Automate Jira Notifications to Telegram with n8n Workflow This detailed guide shows how to automate Jira issue notifications to Telegram using n8n. Save hours by instantly sending updates, creation alerts, and assignment notifications to the right Telegram users, improving team communication and tracking. Open template → FREE Automate Daily Berlin Weather Updates to LINE with n8n Save time and stay informed by automatically sending daily weather updates for Berlin via LINE using n8n automation. This workflow fetches weather data every morning and messages you directly, eliminating manual checking and keeping you updated efficiently. Open template → FREE n8n Twitter Thread Generator 2026: AI Writes & Posts Threads From Any Content This n8n workflow uses AI to automatically convert any content — blog posts, videos, articles — into ready-to-post Twitter/X threads, complete with hooks and formatting. Open template → FREE Backup n8n Workflows to Bitbucket with Rate Limit Handling Automate daily backups of your n8n workflows directly to Bitbucket, intelligently managing API rate limits to avoid errors. This workflow ensures your automation definitions are safely versioned with minimal manual effort. Open template → FREE Automate Member and Activity Sync from Google Sheets to Orbit This blog explains how to automate moving community member data and their activities from Google Sheets into Orbit using n8n, solving tedious manual updates and ensuring accurate data syncing. Open template → FREE Sync Outlook Calendar with Notion via n8n Automation This workflow automates syncing Microsoft Outlook Calendar events into a Notion database. It solves the problem of manual calendar updates, saving time and reducing errors by automatically creating or updating Notion pages for your events. Open template →
    ✦ WANT THIS RUNNING IN YOUR BUSINESS?

    We’ll set it up for you.

    Tell us what you want it to do. We’ll wire the workflow, connect the credentials, and hand it over running.

    Keep exploring.