{"product_id":"apify-google-maps-lead-scraper-for-n8n-google-sheets","title":"Apify Google Maps Lead Scraper for n8n → Google Sheets","description":"\u003ch3\u003eTurn Google Maps searches into structured leads in Google Sheets—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow collects Google Maps-style search queries from an n8n form, scrapes business details using Apify’s \u003cstrong\u003eGoogle Maps Businesses\u003c\/strong\u003e actor, cleans and flattens the results, and then appends each lead as a new row in your Google Sheets “Leads” tab.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives input\u003c\/strong\u003e from an n8n form: one or more search queries, a target country, and optional lead filters.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns Apify’s actor\u003c\/strong\u003e \u003cstrong\u003eplainrows\/google-maps-businesses\u003c\/strong\u003e for each query to fetch Google Maps business data, applying your selected max results and requirements such as website\/phone.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters and formats results\u003c\/strong\u003e by removing non-results and converting each place into a flat, readable structure—including an opening-hours string plus key fields like phone, website, rating, and the \u003cstrong\u003eGoogle Maps URL\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends leads to Google Sheets\u003c\/strong\u003e by writing every formatted business as a new row in the worksheet named \u003cstrong\u003eLeads\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eLead generation for local businesses by running repeatable Google Maps searches (e.g., “plumber near me”) and storing verified fields in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eBuilding a prospect list for outreach: scrape phone, website, rating, and location context into a single spreadsheet.\u003c\/li\u003e\n  \u003cli\u003eOperational workflows for SaaS teams who need fresh lead rows after submitting new search queries through an n8n form.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify integration:\u003c\/strong\u003e uses an \u003cstrong\u003eApify API token\u003c\/strong\u003e with the community node \u003cstrong\u003e@apify\/n8n-nodes-apify\u003c\/strong\u003e and the actor \u003cstrong\u003eplainrows\/google-maps-businesses\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes used:\u003c\/strong\u003e code, sticky note, form trigger, Google Sheets, and \u003cstrong\u003e@apify\/n8n-nodes-apify\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOutput:\u003c\/strong\u003e Google Sheets worksheet tab named \u003cstrong\u003eLeads\u003c\/strong\u003e, appending each business lead as a new row.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup requirements\u003c\/h3\u003e\n\u003cp\u003eYou’ll need an Apify account (free plan supported) with an API token, Google Sheets OAuth credentials, the \u003cstrong\u003e@apify\/n8n-nodes-apify\u003c\/strong\u003e node available in your n8n instance, and a target spreadsheet URL to map the “Leads” tab.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46190230536371,"sku":"N8N-20637","price":56.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Xo2oJaZvDbRbAN0h9_HNx_AiIiW8gQ.png?v=1791450638","url":"https:\/\/buyflowscripts.com\/products\/apify-google-maps-lead-scraper-for-n8n-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}