Triage Ops Requests Automation: Gemini, Sheets, Gmail & Slack

Triage Ops Requests in Seconds: Gemini + Sheets + Gmail + Slack Automation

This n8n workflow automatically receives ops requests through a webhook, uses Google Gemini to classify and summarize them, prevents duplicates with Google Sheets, then sends confirmation via Gmail and notifies your ops team in Slack.

What this workflow does

• Receives requests via webhook: Accepts a POST payload containing requester name, email, department, subject, and message.
• Validates inputs: Normalizes and checks required fields, returning an error response if key data is missing.
• Classifies with Gemini: Combines department, subject, and message into one text block and sends it to Google Gemini to generate structured JSON (request type, summary, urgency, owner suggestion, and checklist).
• Generates task details: Parses Gemini output, calculates a priority score/level, and creates a task ID and task metadata.
• Prevents duplicates with Sheets: Checks Google Sheets for an existing record using the requester email and a derived channel ID; if found, it returns a duplicate error.
• Registers, acknowledges, and escalates: Appends the new task to the Google Sheets “Task Register,” sends an acknowledgement email via Gmail, posts an internal alert in Slack, and returns structured task details to the webhook caller.

Use cases

• Turn internal ops request form submissions into prioritized tasks with owner suggestions.
• Ensure no duplicate tickets are created for the same requester/channel using Google Sheets checks.
• Provide instant requester confirmation while keeping your ops team synced in Slack.

Technical details

• n8n nodes: webhook, if, set, code, gmail, slack.
• Integrations: Google Gemini (PaLM/Google AI), Google Sheets (Task Register), Gmail, and Slack.
• Setup: Configure the source app/form to POST JSON to the webhook and add credentials for Gemini, Sheets, Gmail, and Slack in n8n.