This is an n8n workflow that collects business data from Google Maps and adds it to a Google Sheets spreadsheet. It is meant for building prospect lists by business type and city.
You enter the business type, target city, maximum number of results and your Google Maps API key in a simple form. The workflow uses the Google Geocoding API to convert the city into coordinates. It then creates a 4-point coordinate grid around the city center and runs a Google Places Nearby Search at each point. Pagination captures up to three result pages per point.
The returned Place IDs are processed in batches to retrieve detailed business information. For each business, the workflow extracts the name, full address, phone number, website URL, rating, review count and business category. Each lead is appended as a new row in the spreadsheet you select. Built-in delays and pagination handling help the workflow respect API rate limits.
- Type
- n8n workflow for lead generation
- Form inputs
- Business type, target city, maximum results, Google Maps API key
- Lead data
- Business name, full address, phone numbers, website URLs, ratings, review counts, business categories
- Search method
- 4-point coordinate grid around the city center, Google Places Nearby Search, up to three result pages per point
- Output
- Each lead appended as a new row in Google Sheets
- n8n nodes
- Set, Wait, Split Out, Aggregate, Sticky Note, Form Trigger
- Integrations
- Google Maps Geocoding API, Google Places API (Nearby Search and Place Details), Google Sheets via OAuth2
- Setup
- Enable Google Maps APIs in Google Cloud Console, configure n8n Google Sheets credentials, select your target spreadsheet
- Use cases
- Sales prospect lists, local market research and competitor analysis, finding commercial clients, entering new markets, gathering business directory data