{"product_id":"n8n-gpt-4o-mini-swiggy-zomato-review-monitor-telegram-sheets","title":"n8n GPT-4o Mini Swiggy Zomato Review Monitor: Telegram + Sheets","description":"\u003ch3\u003eTurn Swiggy \u0026amp; Zomato reviews into instant action—Telegram alerts + Google Sheets logging\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow monitors new \u003cstrong\u003eSwiggy\u003c\/strong\u003e and \u003cstrong\u003eZomato\u003c\/strong\u003e reviews, analyzes sentiment and urgency with \u003cstrong\u003eOpenAI (gpt-4o-mini)\u003c\/strong\u003e, drafts suggested replies, and logs everything to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e. Critical feedback is escalated via \u003cstrong\u003eTelegram\u003c\/strong\u003e and \u003cstrong\u003eGmail\u003c\/strong\u003e, while non-critical reviews get ready-to-paste reply drafts. Every week, it also emails a dish-level sentiment report.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns every 30 minutes\u003c\/strong\u003e to fetch review data from an \u003cstrong\u003eHTTP endpoint\u003c\/strong\u003e or accepts new reviews via a \u003cstrong\u003ewebhook\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes review payloads\u003c\/strong\u003e from Swiggy\/Zomato into a consistent format (IDs, ratings, text, dates, and ordered items).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads previously logged review IDs\u003c\/strong\u003e plus your menu from Google Sheets to prevent duplicates and enable dish matching.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses gpt-4o-mini\u003c\/strong\u003e to:\n    \u003cul\u003e\n      \u003cli\u003eClassify sentiment and urgency\u003c\/li\u003e\n      \u003cli\u003eExtract dish mentions and key issues\u003c\/li\u003e\n      \u003cli\u003eGenerate a \u003cstrong\u003esuggested public reply\u003c\/strong\u003e and an \u003cstrong\u003einternal action\u003c\/strong\u003e\n\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003eWrites results to Google Sheets:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003e“Reviews Log”\u003c\/strong\u003e: one row per review\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003e“Dish Mentions”\u003c\/strong\u003e: one row per dish mention\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAlerts via Telegram + Gmail\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003eCritical reviews (low rating \/ high urgency) go to \u003cstrong\u003eTelegram\u003c\/strong\u003e and escalate via \u003cstrong\u003eGmail\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003eNon-critical reviews are posted to Telegram as \u003cstrong\u003ereply drafts\u003c\/strong\u003e\n\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEvery Monday at 9 AM\u003c\/strong\u003e, generates a weekly HTML report (platform + dish sentiment) from the last two weeks, emails it via Gmail, posts a Telegram summary, and archives it in \u003cstrong\u003e“Weekly Reports”\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators and restaurant teams who want \u003cstrong\u003efaster review response\u003c\/strong\u003e without manual copy\/paste\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building a \u003cstrong\u003ereview monitoring\u003c\/strong\u003e system for multiple platforms (Swiggy + Zomato)\u003c\/li\u003e\n  \u003cli\u003eTeams that need \u003cstrong\u003edish-level sentiment tracking\u003c\/strong\u003e over time for menu improvements\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTriggering\u003c\/strong\u003e: scheduled every 30 minutes + \u003cstrong\u003ewebhook\u003c\/strong\u003e option\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes\/controls\u003c\/strong\u003e: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003ewebhook\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMessaging\u003c\/strong\u003e: \u003cstrong\u003eTelegram\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmail escalation + weekly reports\u003c\/strong\u003e: \u003cstrong\u003eGmail\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData storage\u003c\/strong\u003e: \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (“Reviews Log”, “Dish Mentions”, “Weekly Reports”)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI analysis\u003c\/strong\u003e: \u003cstrong\u003eOpenAI (gpt-4o-mini)\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46160840818867,"sku":"N8N-20425","price":44.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/hX3HGK3zpA5WSGRqnHKjG_iPXY8wR9.png?v=1791190988","url":"https:\/\/buyflowscripts.com\/products\/n8n-gpt-4o-mini-swiggy-zomato-review-monitor-telegram-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}