{"product_id":"n8n-workflow-google-places-email-lead-scraper-to-sheets","title":"n8n Workflow: Google Places Email Lead Scraper to Sheets","description":"\u003ch3\u003eTurn Google Places results into email leads—automatically\u003c\/h3\u003e\n\u003cp\u003eThis 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.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCollects inputs via an n8n form\u003c\/strong\u003e: business type, location, and a \u003cstrong\u003eGoogle Places API key\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSearches Google Places (Text Search, paginated)\u003c\/strong\u003e: retrieves matching local businesses and returns details such as \u003cstrong\u003ename, address, phone, website, and types\u003c\/strong\u003e (up to \u003cstrong\u003e3 pages\u003c\/strong\u003e of results).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eProcesses results in small batches\u003c\/strong\u003e by splitting the place results into individual items to reduce load and keep processing stable.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends each business to Google Sheets\u003c\/strong\u003e with the lead details and a scrape status field.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScrapes each business website (when available)\u003c\/strong\u003e: fetches the page HTML and extracts the \u003cstrong\u003efirst valid email address\u003c\/strong\u003e, recording whether scraping succeeded.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWaits briefly between items\u003c\/strong\u003e to be polite to websites, then continues until all places are processed.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eGenerate prospect lists for local services (e.g., “plumbers in Austin”) and capture emails for outbound outreach.\u003c\/li\u003e\n  \u003cli\u003eBuild a lightweight lead pipeline by funneling Google Places discovery directly into Google Sheets for review.\u003c\/li\u003e\n  \u003cli\u003eUse an n8n form as a self-serve interface for SaaS operators or automation engineers to run targeted searches.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Places API\u003c\/strong\u003e integration using Text Search with pagination\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e OAuth2 credential connection to append records\u003c\/li\u003e\n  \u003cli\u003en8n nodes\/blocks referenced in the workflow: \u003cstrong\u003eForm Trigger\u003c\/strong\u003e, \u003cstrong\u003eSet\u003c\/strong\u003e, \u003cstrong\u003eCode\u003c\/strong\u003e, \u003cstrong\u003eWait\u003c\/strong\u003e, \u003cstrong\u003eSplit Out\u003c\/strong\u003e, and \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup \u0026amp; customization\u003c\/h3\u003e\n\u003cp\u003eEnable 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.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45895370932403,"sku":"N8N-18661","price":73.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/aVVsEzz5BteXkMCRC05H0_g8wiBug8.png?v=1787648906","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-google-places-email-lead-scraper-to-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}