Monitor Swiggy and Zomato reviews with GPT-4o-mini, Telegram, and Google Sheets

by Rahul Joshi ✓ · 24 views · created 2026-10-05 · Market Research, AI Summarization

What this workflow does

This AI workflow has 29 nodes and runs on a schedule (every 30 minutes) (plus 2 other triggers). Along the way it connects Google Sheets, OpenAI, Telegram and Gmail.

How it runs

Trigger: On a schedule (every 30 minutes) (plus 2 other triggers).

1. Fetch Swiggy & Zomato Reviews (HTTP Request): calls an HTTP API
2. Normalize Review Payloads (Code): runs custom JavaScript code
3. Set Report Config (Edit Fields (Set)): sets 9 fields: restaurant_name, sheet_id, reviews_sheet…
4. Set Monitor Config (Edit Fields (Set)): sets 10 fields: restaurant_name, brand_voice, sheet_id…
5. Get Reviews for Report (Google Sheets): uses Google Sheets
6. Get Logged Reviews (Google Sheets): uses Google Sheets
7. Get Dish Mentions for Report (Google Sheets): uses Google Sheets
8. Get Menu Items (Google Sheets): uses Google Sheets
9. Aggregate Weekly Dish Sentiment (Code): runs custom JavaScript code
10. Filter New Reviews (Code): runs custom JavaScript code

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

Services it uses

Google SheetsOpenAITelegramGmail

Before you upgrade to n8n 3.0

Nodes used (10)

• Schedule Triggern8n-nodes-base.scheduleTrigger
• Webhookn8n-nodes-base.webhook
• HTTP Requestn8n-nodes-base.httpRequest
• Coden8n-nodes-base.code
• Edit Fields (Set)n8n-nodes-base.set
• Google Sheetsn8n-nodes-base.googleSheets
• OpenAI@n8n/n8n-nodes-langchain.openAi
• Ifn8n-nodes-base.if
• Telegramn8n-nodes-base.telegram
• Gmailn8n-nodes-base.gmail

From the author

Quick Overview This workflow monitors Swiggy and Zomato reviews via an HTTP feed polled every 30 minutes or a webhook, uses OpenAI to analyze sentiment and draft replies, logs results to Google Sheets, and sends Telegram/Gmail alerts for critical reviews plus…

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