Automated Lead Extraction from Google Maps to Google Sheets

This n8n workflow automates the extraction of local business leads from Google Maps based on service type and location, then organizes and de-duplicates the data in Google Sheets. It is ideal for marketers, sales teams, or business researchers seeking targeted local business data. The process begins with a user submitting a form specifying the service, city, state, and country. The workflow then generates a list of relevant cities and categories these services using AI. For each city, it constructs Google Maps search URLs and scrapes business listings via Bright Data’s proxy network. It waits for the dataset to be ready, fetches the scraped data, and checks for duplicates by comparing business names and phone numbers. The cleaned data, with detailed business info, is then saved into Google Sheets. This automation helps streamline market research, lead generation, and competitive analysis by providing accurate, consolidated business data across multiple locations.