{"product_id":"find-low-rated-cleanliness-complaints-from-google-maps-to-airtable","title":"Find Low-Rated Cleanliness Complaints from Google Maps to Airtable","description":"\u003ch3\u003eFind low-rated cleanliness complaints from Google Maps—automatically—into Airtable\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow pulls your Airtable search queries, searches Google Maps via SerpApi, and upserts the lowest-rated reviews that mention cleanliness issues (like “dirty,” “bathroom,” or “mold”) into an Airtable \u003cstrong\u003eResults\u003c\/strong\u003e table.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads inputs from Airtable:\u003c\/strong\u003e When you manually run the workflow, it reads business “Search Query” and “GPS Coordinates” from an Airtable \u003cstrong\u003eQueries\u003c\/strong\u003e table.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSearches Google Maps through SerpApi:\u003c\/strong\u003e For each query, it paginates through Google Maps search results, normalizes key place fields, and deduplicates places using Google Maps \u003cstrong\u003edata_id\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTargets the lowest-rated places:\u003c\/strong\u003e It filters places to those with \u003cstrong\u003eratings below 4\u003c\/strong\u003e, then fetches the \u003cstrong\u003elowest-rated Google Maps reviews\u003c\/strong\u003e for each place using SerpApi’s Google Maps Reviews endpoint.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects cleanliness-related complaints:\u003c\/strong\u003e Reviews are split into individual items, and only reviews whose text contains cleanliness keywords (e.g., “dirty”, “bathroom”, “mold”) are kept.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEnriches and formats output:\u003c\/strong\u003e Each matched review is associated with the corresponding place details, excludes entries missing a reviewer name, and formats fields for storage.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpserts into Airtable:\u003c\/strong\u003e It upserts each matched review into the Airtable \u003cstrong\u003eResults\u003c\/strong\u003e table using a unique key of \u003cstrong\u003e“title \u0026amp; review position”\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLocation-level reputation monitoring:\u003c\/strong\u003e Continuously identify cleanliness complaints for specific regions or business types.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOps triage for multi-location businesses:\u003c\/strong\u003e Prioritize sites with low Google Maps ratings and cleanliness-related feedback.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eQuality assurance insights:\u003c\/strong\u003e Gather review excerpts in Airtable for reporting, follow-ups, or internal training.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAirtable:\u003c\/strong\u003e Uses Airtable connection with configured base and table IDs for \u003cstrong\u003eQueries\u003c\/strong\u003e (input) and \u003cstrong\u003eResults\u003c\/strong\u003e (output), upserting by “title \u0026amp; review position”.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSerpApi:\u003c\/strong\u003e Google Maps Search + Google Maps Reviews endpoints (requires SerpApi API key\/credentials).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes mentioned:\u003c\/strong\u003e \u003cem\u003eset\u003c\/em\u003e, \u003cem\u003emerge\u003c\/em\u003e, \u003cem\u003efilter\u003c\/em\u003e, \u003cem\u003eairtable\u003c\/em\u003e, \u003cem\u003esplit out\u003c\/em\u003e, and \u003cem\u003esticky note\u003c\/em\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45761001717939,"sku":"N8N-17841","price":48.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/ulHFtturKlnseOczvJ9_T_2iLNZAMU.png?v=1785920669","url":"https:\/\/buyflowscripts.com\/products\/find-low-rated-cleanliness-complaints-from-google-maps-to-airtable","provider":"N8N Commerce","version":"1.0","type":"link"}