Monitor restaurant ratings with Google Places, Gemini, Sheets, and Slack

by Divyanshu Gupta ✓ · 49 views · created 2026-05-06 · Market Research, AI Summarization

What this workflow does

This AI workflow has 14 nodes and runs on a schedule (every day). Along the way it connects Google Sheets, Google Gemini and Slack. It also calls maps.googleapis.com over HTTP.

How it runs

Trigger: On a schedule (every day).

1. 📊 Read Restaurant List (Google Sheets): uses Google Sheets
2. 🔄 Loop Over Restaurants (Loop Over Items (Split in Batches)): loops over the items in batches
3. 🌐 Fetch Live Data (Google Places API) (HTTP Request): calls maps.googleapis.com
4. 🧠 Change Detection Engine (Code): runs custom JavaScript code
5. 🚦 Alert Worthy? (IF) (If): checks a condition and branches into true / false
6. 🤖 AI Diagnosis (Google Gemini) (Google Gemini): uses Google Gemini
7. Merge: merges the data from its input branches
8. 📡 Alert Routing (Switch) (Switch): routes items into 3 branches
9. 🔴 Critical Alert (Slack) (Slack): uses Slack
10. 🟡 Watch Alert (Slack) (Slack): uses Slack

…plus 3 more steps. See the full node list below.

Services it uses

Google SheetsGoogle GeminiSlack

HTTP calls to: maps.googleapis.com

Before you upgrade to n8n 3.0

Nodes used (10)

• Google Sheetsn8n-nodes-base.googleSheets
• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
• HTTP Requestn8n-nodes-base.httpRequest
• Coden8n-nodes-base.code
• Ifn8n-nodes-base.if
• Google Gemini@n8n/n8n-nodes-langchain.googleGemini
• Mergen8n-nodes-base.merge
• Switchn8n-nodes-base.switch
• Slackn8n-nodes-base.slack
• Schedule Triggern8n-nodes-base.scheduleTrigger

From the author

What this workflow does Automatically monitors restaurant ratings on Google Places daily, detects meaningful changes, uses Google Gemini AI to diagnose the root cause from real customer reviews, and delivers smart alerts to Slack — categorised as 🔴 Critical,…

View the original on n8n.io → Check your own copy