n8n Workflow: Google Places Email Lead Scraper to Sheets

Turn Google Places results into email leads—automatically

This n8n workflow takes a business type and location from an n8n form, searches Google Places with your API key, scrapes each business website to find an email address, and appends the leads (plus scrape status) into Google Sheets.

What this workflow does

• Collects inputs via an n8n form: business type, location, and a Google Places API key.
• Searches Google Places (Text Search, paginated): retrieves matching local businesses and returns details such as name, address, phone, website, and types (up to 3 pages of results).
• Processes results in small batches by splitting the place results into individual items to reduce load and keep processing stable.
• Appends each business to Google Sheets with the lead details and a scrape status field.
• Scrapes each business website (when available): fetches the page HTML and extracts the first valid email address, recording whether scraping succeeded.
• Waits briefly between items to be polite to websites, then continues until all places are processed.

Use cases

• Generate prospect lists for local services (e.g., “plumbers in Austin”) and capture emails for outbound outreach.
• Build a lightweight lead pipeline by funneling Google Places discovery directly into Google Sheets for review.
• Use an n8n form as a self-serve interface for SaaS operators or automation engineers to run targeted searches.

Technical details

• Google Places API integration using Text Search with pagination
• Google Sheets OAuth2 credential connection to append records
• n8n nodes/blocks referenced in the workflow: Form Trigger, Set, Code, Wait, Split Out, and Google Sheets

Setup & customization

Enable the Google Places API in Google Cloud, create an API key, connect your Google Sheets OAuth2 credential, and update the target sheet/tab so columns match the output fields (e.g., name, email, phone, website, address, category, scrapeStatus). Customization is possible.