AI ticket analysis
Classifies category, sentiment, urgency, summary, and suggested reply.
Automated customer support ticketing with n8n, AI classification, Supabase storage, customer replies, urgent alerts, and a working admin dashboard.
Live Ticket
#1024
I paid but my account is still not upgraded. I need access today.
AI Result
Billing, urgent, angry sentiment
01
Webhook
02
Validate
03
AI classify
04
Save ticket
05
Auto reply
06
Admin alert
Classifies category, sentiment, urgency, summary, and suggested reply.
n8n receives requests, runs OpenAI, writes to PostgreSQL, and routes alerts.
Dashboard, filters, ticket detail view, status updates, logs, and CSV export.
PostgreSQL tables are included with a demo fallback for local presentation.
How it works
The website submits a request to n8n, n8n enriches it with AI, saves it in PostgreSQL, sends customer communication, and escalates urgent issues to the admin team.
The support form posts name, email, subject, and message to n8n.
n8n checks required fields before spending AI or database work.
OpenAI returns category, priority, sentiment, summary, and reply JSON.
Supabase stores the ticket record and audit log entries.
The customer receives a confirmation email with the ticket ID.
High and critical tickets are escalated by email, Slack, or Telegram.
Demo screens
Admin Overview
6
Total
3
Open
2
Critical
1
Resolved
Automation Layer
Webhook
Receives POST request
OpenAI
Returns JSON analysis
Postgres
Stores ticket and logs
Gmail / Slack
Sends reply and alert