AI Customer Inquiry Classifier: n8n Webhook → Sheets & Slack

Turn incoming customer messages into categorized, trackable tickets—automatically

This n8n workflow listens for customer inquiries through a Webhook, validates the submitted name (isim), email, and message (mesaj), then uses OpenAI (gpt-4o-mini) to classify each request by category and urgency. It logs everything to Google Sheets and sends Slack alerts for complaints, while returning a JSON confirmation response.

What this workflow does

• Receives inquiries via POST webhook with fields: isim, email, and mesaj.
• Validates inputs: ensures all fields are present, checks email format, and flags suspiciously short messages.
• Classifies with OpenAI (gpt-4o-mini): extracts a category (Satış/Destek/Şikayet/Genel), urgency (düşük/orta/yüksek), and a one-sentence summary.
• Parses the model’s JSON output and merges the classification back with the sender details.
• Appends a new row to Google Sheets with sender info, summary, category, urgency, and a timestamp.
• Alerts on complaints: if the category is Şikayet, it posts an alert to a configured Slack channel.
• Returns a JSON webhook response confirming receipt (the response is similar across categories).

Use cases

• Route customer support messages from a website form into a Google Sheet “inbox,” automatically categorized.
• Escalate complaints in real time by sending Slack alerts for Şikayet with AI-generated summary + urgency.
• Reduce manual triage for SaaS teams by converting free-text inquiries into structured data.

Technical details

• Webhook (POST) for inbound requests
• Code for validation and JSON handling
• OpenAI node using gpt-4o-mini for classification
• Switch to route by category (including complaint handling)
• Google Sheets to append inquiry rows
• Slack to post complaint alerts to a specific channel

Includes setup steps for OpenAI credentials, Google Sheets OAuth, Slack credentials, and configuring the webhook URL in your form or source system—ideal for n8n users, automation engineers, and SaaS operators building reliable customer inquiry workflows.