{"product_id":"rank-google-maps-leads-in-n8n-basedonbusiness-to-sheets","title":"Rank Google Maps Leads in n8n: BasedOnBusiness to Sheets","description":"\u003ch3\u003eTurn Google Maps search results into a ranked lead list—then drop it straight into Google Sheets with n8n\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow scrapes Google Maps business leads through \u003cstrong\u003eBasedOnBusiness\u003c\/strong\u003e, filters for the listings that fit your criteria (rating and minimum reviews), ranks them by opportunity, and \u003cstrong\u003eappends the sorted prospects to Google Sheets\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAccepts inputs\u003c\/strong\u003e from an n8n form, including business category, city, country code, desired lead count, maximum rating, and minimum review count.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates and normalizes\u003c\/strong\u003e the inputs, then starts a \u003cstrong\u003eBasedOnBusiness\u003c\/strong\u003e scrape job using an \u003cstrong\u003eidempotency key\u003c\/strong\u003e to prevent double-billing on retries.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePolls job status\u003c\/strong\u003e every 15 seconds until it completes, or stops if the job fails\/cancels or after 15 minutes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDownloads scrape results\u003c\/strong\u003e, then splits them into one item per business.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters prospects\u003c\/strong\u003e to remove unrated and closed listings, keeping only businesses at or below your maximum rating and at or above your minimum reviews.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRanks by opportunity\u003c\/strong\u003e by calculating “\u003cstrong\u003eReviews to 4.5\u003c\/strong\u003e”, assigning a \u003cstrong\u003eHigh\/Medium\/Low\u003c\/strong\u003e priority, and sorting by opportunity score.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends ranked rows\u003c\/strong\u003e to the selected Google Sheets worksheet.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eBuild a pipeline of \u003cstrong\u003elocal service leads\u003c\/strong\u003e in a specific city where ratings indicate room to improve.\u003c\/li\u003e\n  \u003cli\u003eSupport SaaS ops teams who want \u003cstrong\u003erepeatable lead sourcing\u003c\/strong\u003e with consistent scoring and spreadsheet output.\u003c\/li\u003e\n  \u003cli\u003eGive sales teams a \u003cstrong\u003eprioritized list\u003c\/strong\u003e of prospects (High\/Medium\/Low) ready for outreach.\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 scrape integration with 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 include: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003esort\u003c\/strong\u003e, \u003cstrong\u003ewait\u003c\/strong\u003e, \u003cstrong\u003efilter\u003c\/strong\u003e, and \u003cstrong\u003esplit out\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e connected account; use the correct headers matching the workflow output.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45869896433843,"sku":"N8N-18428","price":14.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/h75rz48E2Mj2KV48CRMBR_K70H73GI.png?v=1787130745","url":"https:\/\/buyflowscripts.com\/products\/rank-google-maps-leads-in-n8n-basedonbusiness-to-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}