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

This advanced n8n workflow automates the discovery and extraction of business data from Google Maps using scheduled keyword queries from a Google Sheet. It parses search results with custom JavaScript to extract website URLs, filters out irrelevant or duplicate links, and then scrapes detailed business information using the APIFY Actor. For each business, it optionally employs a LangChain AI Agent powered by Gemini 2.5 to generate enriched insights like services, market position, weaknesses, and strategic suggestions, converting raw text into structured JSON.

The workflow ensures data integrity by checking for duplicates in the output Sheet before appending new records to a dedicated tab. It handles loops for keywords and URLs, conditional logic for filtering, and aggregation for batch processing, running hourly to keep leads fresh. This eliminates manual searching, reduces errors, and scales effortlessly for high-volume operations.

Perfect for lead generation agencies, digital marketers, local researchers, and outreach specialists, it saves hours of tedious work while providing AI-powered competitive intelligence. Benefits include comprehensive business profiles, automated de-duplication, seamless Sheets integration, and customizable AI prompts for tailored analysis, making it a powerhouse for business intelligence automation.