AI-Powered Google Maps Business Scraper with Enrichment & Export to Sheets

Overview

This workflow automates the discovery, extraction, enrichment, and storage of business information from Google Maps search queries using AI tools, scrapers, and Google Sheets.

It is ideal for:

Lead generation agencies Local business researchers Digital marketing firms Automation & outreach specialists

🔧 Tools & APIs Used

Google Maps Search (via HTTP)** Custom JavaScript Parsing** URL Filtering & De-duplication** Google Sheets (Read/Write)** APIFY Actor** for business scraping LangChain AI Agent** (OpenRouter - Gemini 2.5) n8n Built-in Logic** (Loops, Conditions, Aggregators)

🧠 Workflow Summary

Trigger The automation starts via schedule (every hour).

Read Queries from Google Sheet Loads unprocessed keywords from a Google Sheet tab named keywords.

Loop Through Keywords Each keyword is used to search Google Maps for relevant businesses.

Extract URLs JavaScript parses HTML to find all external website URLs from the search results.

Clean URLs Filters out irrelevant domains (e.g., Google-owned, example.com, etc.), and removes duplicates.

Loop Through URLs For each URL:

Checks if it already exists in the Google Sheet (to prevent duplication). Calls the APIFY Actor to extract full business data. Optionally uses AI Agent (Gemini) to provide detailed insight on the business, including:

 Services, About, Market Position, Weaknesses, AI suggestions, etc.

Converts the AI result (text) to a structured JSON object.

Save to Google Sheet Adds all extracted and AI-enriched business information to a separate tab (Sheet1).

Mark Queries as Processed Updates the original row in keywords to avoid reprocessing.

🗃️ Output Fields Saved

The following information is saved per business:

Business Name, Website, Email, Phone Address, City, Postal Code, Country, Coordinates Category, Subcategory, Services About Us, Opening Hours, Social Media Links Legal Links (Privacy, Terms) Logo, Languages, Keywords AI-Generated Description** Google Maps URL

📈 Use Cases

Build a prospect database for B2B cold outreach. Extract local SEO insights per business. Feed CRMs or analytics systems with enriched business profiles. Automate market research for regional opportunity detection.

📩 Want a Similar Workflow?

If you’d like a custom AI-powered automation like this for your business or agency, feel free to contact me:

📧 msaidwolfltd@gmail.com