Generate B2B Leads by Industry & Location with Google Places API and Google Sheets

How it works A form trigger accepts an Industry + Location query (e.g. Accountants London). Text Search Page 1 calls Google Places Text Search to return results and a next_page_token. Conditional checks + 5s wait nodes fetch page 2 and page 3 when a next page exists. All pages are merged, split into individual place results, and each place_id is passed to Place Details. Place Details returns name, formatted_phone_number, website, formatted_address. Results are formatted and appended to a Google Sheet.

Setup steps Enable Google Cloud project billing and Places API (Text Search + Details). Create an API key and add it to the three Text Search and Place Details HTTP request nodes (<YOUR KEY>). Add Google Sheets OAuth credentials to the Google Sheets node. Create a Google Sheet with columns: Company Name, Phone Number, Website, Address Update the Google Sheets node documentId and sheetName to your spreadsheet. Import/paste this workflow into n8n and test with a small query.

Customization Edit Place Details fields to retrieve more/less info (address_components, opening_hours, etc.). Adjust the number of pages fetched (workflow currently supports up to 3 pages). Alter output mapping in the code node to add/remove columns or change column order. Add further nodes after the sheet (e.g., email scraper/ sender, CRM integration, enrichment API)

Use cases B2B lead generation for targeted industries and locations. Building outreach lists for sales teams and agencies. Enriching CRM with phone, website, and address data from Google Places. Rapid market mapping for local competitors, vendors, or partners.

Troubleshooting tips No results / invalid API key: verify API key is correct, not restricted incorrectly, and Places API is enabled. next_page_token not working: the token can take a couple of seconds to activate. Keep the 5s wait nodes; if still failing, increase to ~10s+ Quota / billing errors: confirm billing is enabled on the Google Cloud project and check your Places API quota. Missing phone/website: not all places provide all fields; fallback handling is already included (nulls). Duplicates in Sheets: run tests on small queries and inspect the Merge/Split logic; add a dedupe step before appending if needed. Place Details rate limits: if you plan high volume, throttle requests or add longer waits to avoid quota/rate-limit errors. Permissions / OAuth: ensure the Google Sheets OAuth user has edit access to the target spreadsheet.