Gmail Triage Workflow: Gemini, Calendar, Sheets & Discord

Turn unread Gmail inquiries into triaged tasks—automatically

This Gmail Triage Workflow: Gemini, Calendar, Sheets & Discord watches your inbox for unread messages with the subject “Inquiry Received”, then uses Google Gemini to classify, summarize, draft a reply, calculate an SLA, and immediately log everything in Google Calendar, Google Sheets, and Discord for urgent escalation.

What this workflow does

• Monitors Gmail every minute for unread emails matching the subject “Inquiry Received”.
• Uses Google Gemini to analyze the sender, subject, and body, returning structured JSON with category, priority, a short summary, and an AI reply draft.
• Calculates an SLA deadline based on priority:
  • High: +4 hours
  • Medium: next day at 18:00
  • Low: +3 days at 18:00
• Creates a Google Calendar event from the received time to the SLA deadline, including inquiry details in the event description.
• Appends the ticket to Google Sheets (including the Calendar event link) in your specified worksheet.
• Generates a Gmail draft reply in the original email thread using the Gemini reply text.
• Alerts a Discord channel when the inquiry priority is High.

Use cases

• SaaS support inbox triage: classify inbound inquiries and ensure SLAs are tracked.
• Lead routing for sales teams: summarize requests, draft responses, and escalate urgent items.
• Operational control: maintain a live log of inquiries in Google Sheets with Calendar links.

Technical details

• Gmail Trigger: unread messages with subject “Inquiry Received”
• Google Gemini: returns structured JSON (category, priority, summary, reply draft)
• Code + SLA logic: SLA deadline calculation by priority
• Google Calendar: event creation using received time and SLA deadline
• Google Sheets: append ticket details and Calendar event link
• Gmail: create a draft reply in the original thread
• Discord webhook: urgent alerts for High priority