Triage ops intake requests with Gemini, Google Sheets, Gmail, and Slack

by WeblineIndia ✓ · 1 views · created 2026-08-31 · Ticket Management, AI Summarization

What this workflow does

This AI workflow has 16 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Slack, Gmail, Google Sheets and Google Gemini.

How it runs

Trigger: When an HTTP POST request hits its webhook URL.

1. Normalize Intake Payload (Edit Fields (Set)): sets 7 fields: requester_name, requester_email, department…
2. Validate Required Fields (If): checks a condition and branches into true / false
3. Build Raw Request Text (Edit Fields (Set)): sets 1 field: full_request_text
4. Return Validation Error (Respond to Webhook): sends the response back to the webhook caller
5. Classify and Structure Request (Google Gemini): uses Google Gemini
6. Parse AI JSON Output (Code): runs custom JavaScript code
7. Calculate Priority Score (Code): runs custom JavaScript code
8. Create Task Record (Edit Fields (Set)): sets 8 fields: task_id, task_title, urgency_detected…
9. Check Duplicate Request (Google Sheets): uses Google Sheets
10. Check Duplicate Result (If): checks a condition and branches into true / false

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

Services it uses

SlackGmailGoogle SheetsGoogle Gemini

Before you upgrade to n8n 3.0

Nodes used (9)

• Webhookn8n-nodes-base.webhook
• Edit Fields (Set)n8n-nodes-base.set
• Coden8n-nodes-base.code
• Respond to Webhookn8n-nodes-base.respondToWebhook
• Slackn8n-nodes-base.slack
• Gmailn8n-nodes-base.gmail
• Google Sheetsn8n-nodes-base.googleSheets
• Google Gemini@n8n/n8n-nodes-langchain.googleGemini
• Ifn8n-nodes-base.if

From the author

Quick Overview This workflow receives ops requests via a webhook, uses Google Gemini to classify and summarize them, prevents duplicates using Google Sheets, then logs the task, emails the requester via Gmail, and alerts the ops team in Slack. How it works 1.…

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