n8n Google Maps lead scraper to Google Sheets
Scrapes businesses from Google Maps for a query, extracts contact info with OpenAI, and saves leads to Sheets.
Setup steps
- Import
- Add OpenAI, Sheets, scraper, SerpAPI keys
- Set query
- Run
Steps summarized from the original Template source ↗. Use “Copy” to grab them with the tools and source link, or copy an AI prompt.
Try it with AI
Paste this into ChatGPT, Claude or your own agent for step-by-step help. Prompt written by AppToBot from this recipe's data, not by the original author. It keeps drafts for your review and asks before anything is sent or paid.
Help me set up this automation using n8n + OpenAI + Google Sheets: "n8n Google Maps lead scraper to Google Sheets". Goal: replace Paid lead databases / manual prospecting. How it should work: - Trigger: Your search query - Then: Scrapes businesses from Google Maps - Then: OpenAI extracts contact info - Result: Leads saved to Sheets Setup steps (summarized from the original source): 1. Import 2. Add OpenAI, Sheets, scraper, SerpAPI keys 3. Set query 4. Run Guide me one step at a time. Ask me for anything you need (accounts, sheet or channel names) before you start. Safety rules: - Build and test with sample data first, and show me a sample result before anything goes live. - Keep anything that goes to other people (emails, posts, replies, record updates) as drafts for my review until I say otherwise. - Never send, post, buy, pay, delete or change records without my approval. - Tell me about any cost (paid plans, API usage) before I'd incur it, and help me set a spending limit. - Keep API keys and passwords out of shared docs and chats. - Privacy: Collects business contact data; follow local privacy/anti-spam law. Based on: https://n8n.io/workflows/3443-scrape-business-leads-from-google-maps-using-openai-and-google-sheets/
From the source
Tool names link to each official site (opens in a new tab).
Running cost: API pennies Free template; several pay-per-use API keys (scraper, crawler, SerpAPI, OpenAI). No-code How we sort costs
Stack: n8n · OpenAI · Google Sheets
App vs bot, side by side
| Old app / habit | Bot | |
|---|---|---|
| Tool | Paid lead databases / manual prospecting | n8n + Google Maps scraper + crawler + SerpAPI + OpenAI + Sheets |
| Monthly cost | Not reported | Several API keys (scraper, crawler, SerpAPI, OpenAI) + n8n; free template |
| Setup | None (already in use) | Not reported · Intermediate |
| Your time | Baseline | Not reported |
| Maintenance | Handled by vendor/you as before | Keep API keys funded. |
| Privacy | Data stays with the app vendor | Collects business contact data; follow local privacy/anti-spam law. |
Full comparison
| Replaces | Paid lead databases / manual prospecting |
|---|---|
| Bot / agent stack | n8n + Google Maps scraper + crawler + SerpAPI + OpenAI + Sheets |
| Monthly cost before | Not reported |
| Monthly cost after | Several API keys (scraper, crawler, SerpAPI, OpenAI) + n8n; free template |
| Setup time | Not reported |
| Time saved | Not reported |
| Skill level | Intermediate |
| Reliability | 3/5: published template; check scraping terms and anti-spam laws. |
| Maintenance | Keep API keys funded. |
| Privacy & data | Collects business contact data; follow local privacy/anti-spam law. |
| Best for | Local B2B prospecting |
| Not for | Cold-email at scale |
Pros and cons
Pros
- Free template
Cons
- Multiple paid APIs
- Legal/ToS risk
Source and evidence
Published template; check scraping terms.
Read the original Template source ↗
“Not reported” means the source doesn't say. We never fill gaps with guesses. Numbers marked “per author” or “vendor claim” are the source's own and weren't independently tested. Source last checked Oct 15, 2026.
Our rating is an editorial opinion based on the public source above, not lab testing. Spot an error? Request a correction.
Plain-text summary (for search and AI assistants)
n8n Google Maps lead scraper to Google Sheets. Replaces Paid lead databases / manual prospecting with n8n + Google Maps scraper + crawler + SerpAPI + OpenAI + Sheets. Cost before: Not reported. Cost after: Several API keys (scraper, crawler, SerpAPI, OpenAI) + n8n; free template. Setup: Not reported, Intermediate. Time saved: Not reported. Reliability 3/5: 3/5: published template; check scraping terms and anti-spam laws. Best for: Local B2B prospecting. Not for: Cold-email at scale. Source: https://n8n.io/workflows/3443-scrape-business-leads-from-google-maps-using-openai-and-google-sheets/
Related recipes
- Auto-update Salesforce from sent emails with n8n and GPT (4/5)
- AI sales lead replies with human approval (n8n + Gmail) (4/5)
- n8n AI appointment booking agent with Google Calendar (3/5)
- SMS appointment booking agent with Cal.com and n8n (3/5)
More: all Sales recipes · Best AI agents to replace Zapier · n8n vs Make: AI agent recipes compared
Questions, corrections or ideas?
Spotted an error, want a recipe covered, or have a partnership idea? Send us a message and we'll get back to you.
Starting your own newsletter? Try beehiiv ↗
What is beehiiv?
beehiiv is a newsletter platform: you write and send emails, host a newsletter website, and grow and monetize a list from one place. We've used it for our own newsletter.
beehiiv says (vendor claims, not tested by us):
- Free plan with up to 2,500 subscribers and unlimited sends
- Built-in website, recommendation network and analytics
- 0% cut of paid subscription revenue (Stripe fees apply)
Good for: starting or growing an email newsletter. Not ideal for: email automations or removing beehiiv branding on a $0 budget (those need Lite or Pro).
Free plan: $0, no card needed. Paid plans from $49/mo billed annually (Lite, up to 1,000 subscribers). People who sign up through our link get a 14-day trial plus 20% off their first 3 months, per beehiiv's partner page. Facts as of Oct 2026, from beehiiv's own website. More about beehiiv →