Route and respond to support tickets with Google Sheets, Slack, and Gemini
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 48 nodes and runs when an HTTP POST request hits its webhook URL (plus 2 other triggers). Along the way it connects Google Sheets, Slack and Google Gemini Chat Model.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 2 other triggers).
- Normalize Input (Edit Fields (Set)): sets 2 fields: raw, received_at
- Format Error Slack (Edit Fields (Set)): sets 1 field: slack_message
- Read Support Logs (Google Sheets): uses Google Sheets
- Validate And Normalize (Code): runs custom JavaScript code
- Alert Workflow Failure Slack (Slack): uses Slack
- Aggregate Support Metrics (Code): runs custom JavaScript code
- Is Request Valid (If): checks a condition and branches into true / false
- AI Operations Analyst (Basic LLM Chain): sends a prompt to an LLM, with model: Operations Chat Model; output parser: Operations Output Parser
- Lookup Processed Event (Google Sheets): uses Google Sheets
- Respond Invalid Request (Respond to Webhook): sends the response back to the webhook caller
…plus 30 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (14)
- Webhook
n8n-nodes-base.webhook - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Respond to Webhook
n8n-nodes-base.respondToWebhook - Google Sheets
n8n-nodes-base.googleSheets - Information Extractor
@n8n/n8n-nodes-langchain.informationExtractor - Switch
n8n-nodes-base.switch - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Slack
n8n-nodes-base.slack - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Error Trigger
n8n-nodes-base.errorTrigger - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini
From the author
Quick Overview This workflow receives customer support requests via a webhook, validates and deduplicates them using Google Sheets, classifies and drafts replies with Google Gemini, escalates high-risk cases to Slack, logs every interaction back to Google…