{"product_id":"google-maps-reviews-evidence-to-google-sheets-apify-n8n","title":"Google Maps Reviews Evidence to Google Sheets (Apify + n8n)","description":"\u003ch3\u003eTurn Google Maps search results into a reviewable Google Sheets register (with evidence)\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003eApify + n8n workflow\u003c\/strong\u003e creates a structured, evidence-backed list of businesses from a \u003cstrong\u003eGoogle Maps\u003c\/strong\u003e search and delivers it to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e as a \u003cem\u003ecurrent review register\u003c\/em\u003e—including phone numbers, website link checks, and clear markers when manual verification is required.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns one bounded Apify collection\u003c\/strong\u003e that provides source records plus `coverage` and `billing` evidence.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eChecks the complete dataset\u003c\/strong\u003e before writing anything to Google Sheets, so the sheet reflects what was actually observed in the declared window.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpserts using stable source keys\u003c\/strong\u003e: previously seen rows are updated on repeat runs, while earlier unobserved rows remain—so your Sheet stays a \u003cstrong\u003ereview register\u003c\/strong\u003e, not a full historical archive.\u003c\/li\u003e\n  \u003cli\u003eDistinguishes source windows: \u003cstrong\u003eCOMPLETE\u003c\/strong\u003e reflects the declared source window; \u003cstrong\u003eCAPPED\u003c\/strong\u003e is kept as a labelled sample.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles failures safely\u003c\/strong\u003e: source failures stop delivery; verified empty results produce \u003cstrong\u003eno data rows\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSeparates contact evidence from website fetch results\u003c\/strong\u003e. If a website check is uncertain or fails, the row is marked \u003cstrong\u003eMANUALLY_VERIFY_WEBSITE\u003c\/strong\u003e—it never becomes proof that a business needs a new site.\u003c\/li\u003e\n  \u003cli\u003eApplies intent-aware labeling: \u003cstrong\u003eNO_SUPPORTED_WEBSITE_PITCH\u003c\/strong\u003e indicates the source does not support that offer. Public phone availability does not establish permission to contact.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eLocal agencies compiling \u003cstrong\u003eGoogle Maps-based prospect lists\u003c\/strong\u003e for outbound review.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators maintaining a \u003cstrong\u003eGoogle Sheets evidence register\u003c\/strong\u003e for auditability and human QA.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building repeatable workflows that \u003cstrong\u003estop on source failures\u003c\/strong\u003e and flag uncertain website checks for manual review.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify run\u003c\/strong\u003e supplies evidence and records (bounded execution).\u003c\/li\u003e\n  \u003cli\u003eUses n8n nodes including: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003ewait\u003c\/strong\u003e, and \u003cstrong\u003eHTTP Request\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eRequires your own \u003cstrong\u003eApify account\u003c\/strong\u003e and a \u003cstrong\u003eHeader Auth credential\u003c\/strong\u003e on \u003cstrong\u003eall five HTTP nodes\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eConnects \u003cstrong\u003eGoogle Sheets OAuth2\u003c\/strong\u003e to \u003cstrong\u003eUpsert review register\u003c\/strong\u003e data.\u003c\/li\u003e\n  \u003cli\u003eCreates the supplied tab using the \u003cstrong\u003eexact CSV header\u003c\/strong\u003e from the workflow’s provided sheet-header template.\u003c\/li\u003e\n  \u003cli\u003eEnter the \u003cstrong\u003espreadsheet ID\u003c\/strong\u003e in \u003cstrong\u003eR\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45978925367475,"sku":"N8N-19340","price":72.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/QmZqjpz-b_mOVQG4atEQf_NQQVllxz.png?v=1788859135","url":"https:\/\/buyflowscripts.com\/products\/google-maps-reviews-evidence-to-google-sheets-apify-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}