{"product_id":"audit-google-maps-branch-listings-with-hasdata-google-sheets","title":"Audit Google Maps Branch Listings with HasData \u0026 Google Sheets","description":"\u003ch3\u003eAudit your Google Maps branch listings—automatically—with HasData \u0026amp; Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow checks whether each branch’s Google Maps listing matches your approved \u003cstrong\u003ename, address, phone number, and website\u003c\/strong\u003e. It logs any differences or missing fields to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and flags cases that were previously different but later become consistent—without editing your listings.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads your configuration\u003c\/strong\u003e from n8n Settings: spreadsheet ID, branch limit, and country calling code, then validates them before reading input data.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads approved branches\u003c\/strong\u003e from the \u003cem\u003eBranches\u003c\/em\u003e tab and validates required values.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents bad input\u003c\/strong\u003e by rejecting duplicate branch IDs and reused \u003cstrong\u003eplace IDs\u003c\/strong\u003e, and by stopping oversized batches before paid requests.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses saved history\u003c\/strong\u003e: reads the \u003cem\u003eResults\u003c\/em\u003e tab once, rejects duplicate saved keys, and keeps the prior comparison as the baseline for each branch on every run.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches live listings\u003c\/strong\u003e through \u003cstrong\u003eHasData\u003c\/strong\u003e using the exact Google Maps \u003cstrong\u003eplace ID\u003c\/strong\u003e. Failed requests or unexpected place IDs are marked as unknown.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCompares key fields\u003c\/strong\u003e (configured vs observed): name, address, phone number, and website hostname. Approved aliases are accepted and formatting can be normalized.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects resolution over time\u003c\/strong\u003e: a field only resolves when an earlier difference now matches unchanged expected values. Missing values and failed reads cannot resolve issues.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaves outcomes\u003c\/strong\u003e back to Google Sheets: differences, missing fields, and resolved fields—along with request metadata.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eKeep multi-location \u003cstrong\u003eGoogle Business Profile\u003c\/strong\u003e listings compliant with your brand standards.\u003c\/li\u003e\n  \u003cli\u003eIdentify which branches have incorrect phone numbers or website URLs—and track when fixes “stick.”\u003c\/li\u003e\n  \u003cli\u003eRun scheduled audits for hundreds of branches using an \u003cstrong\u003eexact place ID\u003c\/strong\u003e workflow.\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 \/ tech stack:\u003c\/strong\u003e Manual Trigger, Set, Code, Sticky Note, Google Sheets, and \u003cstrong\u003eHasData\u003c\/strong\u003e (hasdatan8n-nodes-hasdata \/ Has Data).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eInput\/Output:\u003c\/strong\u003e Reads from Google Sheets tabs \u003cem\u003eBranches\u003c\/em\u003e and \u003cem\u003eResults\u003c\/em\u003e; writes audit differences and resolution status.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eKey design goal:\u003c\/strong\u003e Uses exact Google Maps \u003cstrong\u003eplace IDs\u003c\/strong\u003e and never edits listings—only audits and records findings.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46164223754419,"sku":"N8N-20474","price":42.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/9CsKswPyDXF4Q46aMPx71_CrEtHbw9.png?v=1791278471","url":"https:\/\/buyflowscripts.com\/products\/audit-google-maps-branch-listings-with-hasdata-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}