Find Low-Rated Cleanliness Complaints from Google Maps to Airtable

Find low-rated cleanliness complaints from Google Maps—automatically—into Airtable

This 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 Results table.

What this workflow does

• Loads inputs from Airtable: When you manually run the workflow, it reads business “Search Query” and “GPS Coordinates” from an Airtable Queries table.
• Searches Google Maps through SerpApi: For each query, it paginates through Google Maps search results, normalizes key place fields, and deduplicates places using Google Maps data_id.
• Targets the lowest-rated places: It filters places to those with ratings below 4, then fetches the lowest-rated Google Maps reviews for each place using SerpApi’s Google Maps Reviews endpoint.
• Detects cleanliness-related complaints: Reviews are split into individual items, and only reviews whose text contains cleanliness keywords (e.g., “dirty”, “bathroom”, “mold”) are kept.
• Enriches and formats output: Each matched review is associated with the corresponding place details, excludes entries missing a reviewer name, and formats fields for storage.
• Upserts into Airtable: It upserts each matched review into the Airtable Results table using a unique key of “title & review position”.

Use cases

• Location-level reputation monitoring: Continuously identify cleanliness complaints for specific regions or business types.
• Ops triage for multi-location businesses: Prioritize sites with low Google Maps ratings and cleanliness-related feedback.
• Quality assurance insights: Gather review excerpts in Airtable for reporting, follow-ups, or internal training.

Technical details

• Airtable: Uses Airtable connection with configured base and table IDs for Queries (input) and Results (output), upserting by “title & review position”.
• SerpApi: Google Maps Search + Google Maps Reviews endpoints (requires SerpApi API key/credentials).
• n8n nodes mentioned: set, merge, filter, airtable, split out, and sticky note.