Run an AI student helpdesk with OpenAI, Google Sheets, Slack, and Gmail
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 20 nodes and runs when a chat message arrives (plus 2 other triggers). Along the way it connects Slack, Google Sheets, OpenAI and Gmail.
How it runs
Trigger: When a chat message arrives (plus 2 other triggers).
- Extract Session & Message (Code): runs custom JavaScript code
- Read All Conversation Logs (Google Sheets): uses Google Sheets
- Slack: uses Slack
- Build Conversation Context (Code): runs custom JavaScript code
- Calculate Weekly Metrics (Code): runs custom JavaScript code
- Fetch Knowledge Base (Google Sheets): uses Google Sheets
- Merge: merges the data from its input branches
- Email Weekly Report to Admin (Gmail): uses Gmail
- Format Knowledge Base for Prompt (Code): runs custom JavaScript code
- Generate AI Reply via GPT-4o-mini (OpenAI): uses OpenAI
…plus 7 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 (10)
- Error Trigger
n8n-nodes-base.errorTrigger - Slack
n8n-nodes-base.slack - Chat Trigger
@n8n/n8n-nodes-langchain.chatTrigger - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Merge
n8n-nodes-base.merge - OpenAI
@n8n/n8n-nodes-langchain.openAi - If
n8n-nodes-base.if - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Gmail
n8n-nodes-base.gmail
From the author
Quick overview This workflow handles incoming student chat messages, answers questions using a Google Sheets knowledge base with OpenAI, escalates unresolved or distressed conversations to Slack, logs conversations and FAQ gaps back to Google Sheets, and…