{"product_id":"n8n-workflow-google-maps-lead-scraper-to-google-sheets","title":"n8n Workflow: Google Maps Lead Scraper to Google Sheets","description":"\u003ch3\u003eTurn Google Maps searches into email leads in Google Sheets—automatically\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n Workflow: Google Maps Lead Scraper to Google Sheets\u003c\/strong\u003e manually scrapes business listings from Google Maps using the \u003cstrong\u003eSerper Maps API\u003c\/strong\u003e, visits each business website to extract an email address, and appends the results to your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e spreadsheet.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eManual start:\u003c\/strong\u003e You run the workflow manually in n8n.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSearch and paginate results:\u003c\/strong\u003e It sets your Google Maps search query and generates multiple result pages to scrape.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetch listings via Serper:\u003c\/strong\u003e It calls the \u003cstrong\u003eSerper Google Maps API\u003c\/strong\u003e (requests made to \u003ccode\u003ehttps:\/\/google.serper.dev\/maps\u003c\/code\u003e) to retrieve business listings per page.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilter and normalize data:\u003c\/strong\u003e It keeps only listings that include a \u003cstrong\u003ewebsite\u003c\/strong\u003e, and normalizes key fields such as \u003cstrong\u003ename, phone, address, rating, rating count,\u003c\/strong\u003e and \u003cstrong\u003ebusiness type\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtract email from each website:\u003c\/strong\u003e It requests each business website and extracts the \u003cstrong\u003efirst unique email address\u003c\/strong\u003e found in the page content.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppend to Google Sheets:\u003c\/strong\u003e It writes lead details to your selected sheet, including \u003cstrong\u003ename, email, phone, website, address, rating, rating count,\u003c\/strong\u003e and \u003cstrong\u003ebusiness type\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eBuild a targeted lead list (e.g., “dentist in UAE”) for outbound sales and outreach campaigns.\u003c\/li\u003e\n  \u003cli\u003eRapidly collect contact data for niche directories using Google Maps search results.\u003c\/li\u003e\n  \u003cli\u003ePopulate or refresh a Google Sheets CRM with website-verified email addresses.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes:\u003c\/strong\u003e Manual Trigger, Set, Code, HTTP Request, Google Sheets\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e \u003cstrong\u003eSerper Maps API\u003c\/strong\u003e (via HTTP header auth using your Serper API key)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOutput:\u003c\/strong\u003e Appends rows to a chosen Google Sheets spreadsheet and sheet tab\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup (quick)\u003c\/h3\u003e\n\u003cp\u003eAdd an HTTP Header Auth credential for your \u003cstrong\u003eSerper API key\u003c\/strong\u003e and set the request URL to \u003ccode\u003ehttps:\/\/google.serper.dev\/maps\u003c\/code\u003e. Then configure a \u003cstrong\u003eGoogle Sheets OAuth2\u003c\/strong\u003e credential, choose the target sheet, and update the search query to match your niche and location.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46075760804019,"sku":"N8N-19816","price":51.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/UqS5HHx5ymgSp2gshFnMx_LaNuR41f.png?v=1790154545","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-google-maps-lead-scraper-to-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}