Automate customer support with Gmail, Google Sheets, ERP data & GPT-4o AI
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 15 nodes and runs on Gmail events (plus 1 other trigger). Along the way it connects Gmail, OpenAI Chat Model, Google Sheets and Google Drive. It also calls run.mocky.io over HTTP.
How it runs
Trigger: On Gmail events (plus 1 other trigger).
- AI Information Extractor (Information Extractor): extracts structured fields from text with AI, with model: 🤖 OpenAI Model (Extractor)
- 📊 Historical Support Cases (Google Sheets): uses Google Sheets
- Aggregate: combines items into one
- 📚 Download Product Manual (Google Drive): download
- 📄 Extract PDF Content (Extract from File): extracts data from a file (pdf)
- 🏢 Check ERP System (HTTP Request): calls run.mocky.io
- 🤖 Generate Customer Response (Basic LLM Chain): sends a prompt to an LLM, with model: 🤖 OpenAI Model (Generator)
- 📧 Email or Chat? (If): checks a condition and branches into true / false
- 📧 Request Approval (Email) (Gmail): send and wait for a reply
- 📝 Format Chat Response (Edit Fields (Set)): sets 1 field: text
…plus 1 more step. See the full node list below.
Services it uses
HTTP calls to: run.mocky.io
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) (📧 Support Email Received).
Nodes used (13)
- Gmail Trigger
n8n-nodes-base.gmailTrigger - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Google Sheets
n8n-nodes-base.googleSheets - Aggregate
n8n-nodes-base.aggregate - Google Drive
n8n-nodes-base.googleDrive - Extract from File
n8n-nodes-base.extractFromFile - HTTP Request
n8n-nodes-base.httpRequest - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail - Edit Fields (Set)
n8n-nodes-base.set - Chat Trigger
@n8n/n8n-nodes-langchain.chatTrigger - Information Extractor
@n8n/n8n-nodes-langchain.informationExtractor
From the author
🌐 AI Customer Support Assistant - Cloud Version What this workflow does: This AI-powered customer support automation processes incoming support requests via email or chat, analyzes them using AI, retrieves relevant context, and generates draft responses for…