Rating monitoring for your venues, with the reason attached

The scenario watches your venues' ratings, spots meaningful changes, reads the fresh reviews and sends the reason to your chat.

  • A drop surfaces the same day, not in next month's revenue
  • The AI explains the cause from real guest reviews
  • Small wobbles don't interrupt you
  • Change history is kept in your sheet
Google SheetsGoogle

How it works

To connect botHelp and Google Sheets, you don't need a developer: a ready-made scenario links them in minutes.

  1. Starts when: Schedule Trigger
  2. Then: 📊 Read Restaurant List
  3. Check: 🔄 Loop Over Restaurants
  4. Then: 🌐 Fetch Live Data (Google Places API)
  5. Then: 🧠 Change Detection Engine
  6. Check: 🚦 Alert Worthy? (IF)
  7. If yes: 🤖 AI Diagnosis (Google Gemini)
  8. Check: 🔀 Merge AI + Restaurant Data
  9. Check: 📡 Alert Routing (Switch)
  10. If yes: 🔴 Critical Alert (Slack)
  11. Then: 💾 Update State (Google Sheets)
  12. Then: 📜 Log Alert History (Google Sheets)
  13. If no: 🟡 Watch Alert (Slack)
  14. If no: 🟢 Positive Alert (Slack)

You can launch this botHelp + Google Sheets integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.