{"product_id":"export-google-maps-leads-to-google-sheets-via-n8n-apify","title":"Export Google Maps Leads to Google Sheets via n8n + Apify","description":"\u003ch3\u003eExport Google Maps business leads to Google Sheets with n8n + Apify\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically runs on a weekly schedule, pulls cleaned business lead data from \u003cstrong\u003eGoogle Maps via Apify\u003c\/strong\u003e, and appends the results into your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e worksheet—so your sales and outreach pipeline stays updated without manual exporting.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns weekly\u003c\/strong\u003e using a \u003cem\u003eschedule trigger\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003eStarts the Apify actor \u003cstrong\u003ecaptainhandsome\/google-maps-business-search\u003c\/strong\u003e with your configured \u003cstrong\u003esearch_terms\u003c\/strong\u003e and \u003cstrong\u003emax_items\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWaits 45 seconds\u003c\/strong\u003e to give the Apify scraping job time to generate a dataset.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches the cleaned JSON items\u003c\/strong\u003e from the Apify dataset produced by the run.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends the lead records\u003c\/strong\u003e into the Google Sheets tab named \u003cstrong\u003e“Leads”\u003c\/strong\u003e, including business details such as \u003cstrong\u003ename, phone, address, rating, and website\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMaintain a \u003cstrong\u003elocal lead list\u003c\/strong\u003e (e.g., contractors, clinics, agencies) by refreshing Google Maps leads on a recurring basis.\u003c\/li\u003e\n  \u003cli\u003eSupport \u003cstrong\u003eSaaS sales ops\u003c\/strong\u003e by continuously updating prospect data in a centralized Google Sheet.\u003c\/li\u003e\n  \u003cli\u003eStreamline \u003cstrong\u003eautomation engineering\u003c\/strong\u003e workflows where Google Sheets is your lightweight CRM or sourcing log.\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 used:\u003c\/strong\u003e schedule trigger, wait, HTTP Request, Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify integration:\u003c\/strong\u003e uses an \u003cstrong\u003eApify token\u003c\/strong\u003e added as an \u003cstrong\u003eHTTP Header Auth credential\u003c\/strong\u003e for Apify API requests.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConfiguration:\u003c\/strong\u003e replace \u003cstrong\u003eYOUR_GOOGLE_SHEET_ID\u003c\/strong\u003e; confirm the sheet name is \u003cstrong\u003e“Leads”\u003c\/strong\u003e (or update it).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eInput controls:\u003c\/strong\u003e set \u003cstrong\u003esearch_terms\u003c\/strong\u003e and \u003cstrong\u003emax_items\u003c\/strong\u003e in the Apify actor input to match your target locations and desired lead volume.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003eIdeal if you want a practical \u003cstrong\u003eGoogle Maps lead generation\u003c\/strong\u003e workflow that turns Apify results into actionable rows in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e—fully automated with n8n.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46001838686387,"sku":"N8N-19480","price":25.99,"currency_code":"GBP","in_stock":true}],"url":"https:\/\/buyflowscripts.com\/products\/export-google-maps-leads-to-google-sheets-via-n8n-apify","provider":"N8N Commerce","version":"1.0","type":"link"}