AI Student Helpdesk n8n Workflow: OpenAI, Sheets, Slack, Gmail

Turn student questions into instant answers—and escalate when it matters

The AI Student Helpdesk n8n Workflow automatically responds to incoming student chat messages using OpenAI + a Google Sheets knowledge base, logs every conversation, escalates unresolved or distressed cases to Slack, and emails a weekly metrics report via Gmail.

What this workflow does

• Receives student messages through an n8n Chat trigger, extracting session ID, student name, and message text.
• Maintains conversation context by building/updating a per-session conversation history and turn count across messages.
• Uses a Google Sheets knowledge base to fetch Q&A entries and format them into prompt-ready context.
• Generates a constrained reply with OpenAI (gpt-4o-mini) using the student message, conversation history, and knowledge base.
• Detects unresolved or distressed signals in the AI reply; escalates to Slack when the student appears distressed or when the issue remains unresolved after two turns.
• Logs outcomes to Google Sheets: appends each exchange to a conversation log and records unresolved questions to a dedicated “FAQ Gaps” sheet for knowledge base updates.
• Emails weekly metrics every Monday at 9 AM by reading the conversation log from Google Sheets, calculating metrics, and sending an HTML report to the admin using Gmail.

Use cases

• SaaS or education teams that want an AI-powered helpdesk for student support inquiries.
• Operators who need conversation logging and FAQ gap tracking to continuously improve coverage.
• Support workflows that must escalate urgently (distressed signals) and still measure weekly performance.

Technical details

• Integrations: Google Sheets, OpenAI, Slack, Gmail (OAuth2 credentials).
• Workflow logic: conversation history per session, AI response evaluation for unresolved/distressed markers, and escalation rules after two turns.
• Key node types referenced: if, code, merge, slack, gmail, sticky note.

Setup includes adding credentials for Google Sheets (OAuth2), OpenAI (API key), Slack (OAuth2), and Gmail (OAuth2), and creating a Google Sheets spreadsheet with tabs for the knowledge base (and supporting sheets like “FAQ Gaps” and the conversation log).