This comprehensive n8n workflow automates the process of discovering, extracting, enriching, and storing business information from Google Maps searches. Designed for lead generation, local business research, and digital marketing professionals, it starts with a scheduled trigger to query Google Sheets for unprocessed keywords. Each keyword is used to search Google Maps, from which URLs are scraped using custom JavaScript, and irrelevant or duplicate URLs are filtered out to maintain quality data. The workflow then checks if the URL already exists in the database to prevent duplication. For new URLs, an API call to an APIFY actor extracts full business details, which are further enriched with AI insights via LangChain’s Gemini model, providing detailed profiles including services, strengths, and potential business gaps. All enriched data is saved back to Google Sheets, creating a structured and continuously updated business database. Practical applications include building prospect lists, local SEO analysis, and market research—ideal for agencies and sales teams looking to automate their lead generation and data enrichment efforts.

Node Count	>20 Nodes
Nodes Used	@n8n/n8n-nodes-langchain.agent, @n8n/n8n-nodes-langchain.lmChatOpenRouter, aggregate, code, executeWorkflow, executeWorkflowTrigger, filter, googleSheets, httpRequest, if, merge, removeDuplicates, scheduleTrigger, splitInBatches, stickyNote, wait