{"product_id":"gmail-triage-workflow-gemini-calendar-sheets-discord","title":"Gmail Triage Workflow: Gemini, Calendar, Sheets \u0026 Discord","description":"\u003ch3\u003eTurn unread Gmail inquiries into triaged tasks—automatically\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003eGmail Triage Workflow: Gemini, Calendar, Sheets \u0026amp; Discord\u003c\/strong\u003e watches your inbox for unread messages with the subject \u003cstrong\u003e“Inquiry Received”\u003c\/strong\u003e, then uses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to classify, summarize, draft a reply, calculate an SLA, and immediately log everything in \u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e, \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and \u003cstrong\u003eDiscord\u003c\/strong\u003e for urgent escalation.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMonitors Gmail every minute\u003c\/strong\u003e for unread emails matching the subject \u003cstrong\u003e“Inquiry Received”\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses Google Gemini\u003c\/strong\u003e to analyze the sender, subject, and body, returning structured \u003cstrong\u003eJSON\u003c\/strong\u003e with \u003cstrong\u003ecategory\u003c\/strong\u003e, \u003cstrong\u003epriority\u003c\/strong\u003e, a \u003cstrong\u003eshort summary\u003c\/strong\u003e, and an \u003cstrong\u003eAI reply draft\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates an SLA deadline\u003c\/strong\u003e based on priority:\n    \u003cul\u003e\n      \u003cli\u003eHigh: \u003cstrong\u003e+4 hours\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003eMedium: \u003cstrong\u003enext day at 18:00\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003eLow: \u003cstrong\u003e+3 days at 18:00\u003c\/strong\u003e\n\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates a Google Calendar event\u003c\/strong\u003e from the received time to the SLA deadline, including inquiry details in the event description.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends the ticket to Google Sheets\u003c\/strong\u003e (including the \u003cstrong\u003eCalendar event link\u003c\/strong\u003e) in your specified worksheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates a Gmail draft reply\u003c\/strong\u003e in the original email thread using the Gemini reply text.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAlerts a Discord channel\u003c\/strong\u003e when the inquiry priority is \u003cstrong\u003eHigh\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS support inbox triage: classify inbound inquiries and ensure SLAs are tracked.\u003c\/li\u003e\n  \u003cli\u003eLead routing for sales teams: summarize requests, draft responses, and escalate urgent items.\u003c\/li\u003e\n  \u003cli\u003eOperational control: maintain a live log of inquiries in Google Sheets with Calendar links.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail Trigger\u003c\/strong\u003e: unread messages with subject “Inquiry Received”\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e: returns structured JSON (category, priority, summary, reply draft)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCode + SLA logic\u003c\/strong\u003e: SLA deadline calculation by priority\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e: event creation using received time and SLA deadline\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: append ticket details and Calendar event link\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e: create a draft reply in the original thread\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDiscord webhook\u003c\/strong\u003e: urgent alerts for High priority\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46058952261811,"sku":"N8N-19683","price":39.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Xy386zCXd4iv45UO-wKWc_gmELCtgz.png?v=1789722693","url":"https:\/\/buyflowscripts.com\/products\/gmail-triage-workflow-gemini-calendar-sheets-discord","provider":"N8N Commerce","version":"1.0","type":"link"}