Triage support emails and draft AI replies with Gmail, Google Sheets and OpenAI
Ready for 3.0What this workflow does
This AI workflow has 12 nodes and runs on Gmail events. Along the way it connects Gmail, OpenAI Chat Model and Google Sheets. It also calls hooks.slack.com over HTTP.
How it runs
Trigger: On Gmail events.
- Set FAQ and Policies (Edit Fields (Set)): sets 1 field: faq
- Classify Request with AI (Text Classifier): classifies text into categories with AI, with model: OpenAI Support Model
- Tag as Question (Edit Fields (Set)): sets 1 field: category
- Tag as Billing Issue (Edit Fields (Set)): sets 1 field: category
- Tag as Urgent (Edit Fields (Set)): sets 1 field: category
- Post Alert to Slack (HTTP Request): calls hooks.slack.com (POST)
- Log Ticket in Sheets (Google Sheets): append
- Generate AI Reply Draft (Basic LLM Chain): sends a prompt to an LLM, with model: OpenAI Support Model
- Send Draft Via Gmail (Gmail): work with draft
Services it uses
HTTP calls to: hooks.slack.com
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.
- Still check Gmail Trigger below v1.4 runs as v1.4 (drafts skipped, max emails per poll) (When Support Email Arrives).
Nodes used (9)
- Gmail Trigger
n8n-nodes-base.gmailTrigger - Edit Fields (Set)
n8n-nodes-base.set - Text Classifier
@n8n/n8n-nodes-langchain.textClassifier - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - HTTP Request
n8n-nodes-base.httpRequest - No Operation, do nothing
n8n-nodes-base.noOp - Google Sheets
n8n-nodes-base.googleSheets - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Gmail
n8n-nodes-base.gmail
From the author
Quick overview This workflow polls a Gmail support inbox, uses OpenAI to classify each email, logs non-spam requests to Google Sheets, drafts FAQ-grounded replies back into the original Gmail thread, and sends urgent-complaint alerts to Slack via an incoming…