{"product_id":"n8n-workflow-find-local-businesses-without-websites-maps-to-sheets","title":"n8n Workflow: Find Local Businesses Without Websites (Maps) to Sheets","description":"\u003ch3\u003eFind local Google Maps business leads that don’t have a website—then drop them straight into Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically pulls local business prospects from \u003cstrong\u003eGoogle Maps\u003c\/strong\u003e via \u003cstrong\u003eBasedOnBusiness\u003c\/strong\u003e, filters out any listings that already have a website, and appends the remaining leads (up to 500) into your selected `Google Sheets` tab using a simple input form.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives form inputs\u003c\/strong\u003e for \u003cem\u003ebusiness category\u003c\/em\u003e, \u003cem\u003ecity\u003c\/em\u003e, \u003cem\u003ecountry code\u003c\/em\u003e, and \u003cem\u003elead count\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates and normalizes inputs\u003c\/strong\u003e to prevent invalid searches.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStarts a BasedOnBusiness scraping job\u003c\/strong\u003e for Google Maps and uses an \u003cstrong\u003eidempotency key\u003c\/strong\u003e to avoid duplicate billing on retries.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePolls job status\u003c\/strong\u003e every 15 seconds until it finishes—failing if the job is cancelled, errors, or exceeds a 15-minute runtime.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDownloads up to 500 results\u003c\/strong\u003e, splits them into individual businesses, and keeps only listings where the \u003cstrong\u003ewebsite field is empty\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends one row per prospect\u003c\/strong\u003e to Google Sheets with fields including \u003cstrong\u003eBusiness Name\u003c\/strong\u003e, \u003cstrong\u003ePhone\u003c\/strong\u003e, \u003cstrong\u003eAddress\u003c\/strong\u003e, \u003cstrong\u003eCategory\u003c\/strong\u003e, \u003cstrong\u003eRating\u003c\/strong\u003e, \u003cstrong\u003eReviews\u003c\/strong\u003e, \u003cstrong\u003eGoogle Maps URL\u003c\/strong\u003e, \u003cstrong\u003eCity\u003c\/strong\u003e, and \u003cstrong\u003eCountry\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eGenerate \u003cstrong\u003elocal lead lists\u003c\/strong\u003e for agencies targeting businesses likely to need a website.\u003c\/li\u003e\n  \u003cli\u003eBuild a \u003cstrong\u003eGoogle Sheets prospect pipeline\u003c\/strong\u003e by category + location from Google Maps.\u003c\/li\u003e\n  \u003cli\u003eSupport SaaS sales and outbound campaigns with fresh, filtered business data.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBasedOnBusiness\u003c\/strong\u003e integration using HTTP Bearer Auth (requires \u003cstrong\u003escrapes:read\u003c\/strong\u003e and \u003cstrong\u003escrapes:write\u003c\/strong\u003e scopes).\u003c\/li\u003e\n  \u003cli\u003en8n nodes\/logic: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003ewait\u003c\/strong\u003e, \u003cstrong\u003efilter\u003c\/strong\u003e, \u003cstrong\u003esplit out\u003c\/strong\u003e, and \u003cstrong\u003esticky note\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets append\u003c\/strong\u003e step: your worksheet should include matching column headers before running.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45865759932595,"sku":"N8N-18375","price":29.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/WdySDQCbUCgtP4d-9wgIJ_Hb5c1CCy.png?v=1787044180","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-find-local-businesses-without-websites-maps-to-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}