Audit Google Maps Branch Listings with HasData & Google Sheets

Audit your Google Maps branch listings—automatically—with HasData & Google Sheets

This n8n workflow checks whether each branch’s Google Maps listing matches your approved name, address, phone number, and website. It logs any differences or missing fields to Google Sheets, and flags cases that were previously different but later become consistent—without editing your listings.

What this workflow does

• Loads your configuration from n8n Settings: spreadsheet ID, branch limit, and country calling code, then validates them before reading input data.
• Reads approved branches from the Branches tab and validates required values.
• Prevents bad input by rejecting duplicate branch IDs and reused place IDs, and by stopping oversized batches before paid requests.
• Uses saved history: reads the Results tab once, rejects duplicate saved keys, and keeps the prior comparison as the baseline for each branch on every run.
• Fetches live listings through HasData using the exact Google Maps place ID. Failed requests or unexpected place IDs are marked as unknown.
• Compares key fields (configured vs observed): name, address, phone number, and website hostname. Approved aliases are accepted and formatting can be normalized.
• Detects resolution over time: a field only resolves when an earlier difference now matches unchanged expected values. Missing values and failed reads cannot resolve issues.
• Saves outcomes back to Google Sheets: differences, missing fields, and resolved fields—along with request metadata.

Use cases

• Keep multi-location Google Business Profile listings compliant with your brand standards.
• Identify which branches have incorrect phone numbers or website URLs—and track when fixes “stick.”
• Run scheduled audits for hundreds of branches using an exact place ID workflow.

Technical details

• n8n nodes / tech stack: Manual Trigger, Set, Code, Sticky Note, Google Sheets, and HasData (hasdatan8n-nodes-hasdata / Has Data).
• Input/Output: Reads from Google Sheets tabs Branches and Results; writes audit differences and resolution status.
• Key design goal: Uses exact Google Maps place IDs and never edits listings—only audits and records findings.