Automated Local Business Data Extraction & Enrichment Workflow

This n8n workflow automates the process of scraping, enriching, and storing local business data from Google Maps, Yelp, and other sources for targeted lead generation and market analysis. It begins with setting up input parameters like search URL, zone, and webhook notification URL, which are customizable to fetch specific business data. The workflow then uses Bright Data’s web request capabilities to perform advanced web scraping of Google Maps search results for ‘dentists in Texas’ and related locations. The extracted raw data is processed through a Google Gemini language model to generate structured content, which is parsed and saved into a JSON file and Google Sheets for easy access and further analysis. Additionally, the workflow includes a second data enrichment cycle where Yelp data is fetched via a custom MCP client, processed through language models to extract relevant URLs and descriptions, then stored locally and in Google Sheets. Practical applications include local SEO analysis, market research, and lead list building by consolidating data from multiple sources into accessible formats. The workflow is highly flexible, supporting enrichment workflows with structured output, data storage, and real-time notifications for ongoing business intelligence activities.