Route AI-powered customer support via email and Slack with PostgreSQL and Google Sheets

Go to Workflow
0 views
Built by yuta tokumitsu yuta tokumitsu
Created on June 11, 2026

Description

Automate intelligent customer support responses with AI and Slack

How it works
Receive request via webhook with customer question
Analyze sentiment and detect urgency using JavaScript
Send urgent alerts to Slack for critical cases
Search knowledge base and fetch conversation history from PostgreSQL
Generate AI response with context-aware prompts
Route intelligently: Auto-respond via email OR escalate to Slack
Log everything to Google Sheets and PostgreSQL for analytics

Setup steps
Slack webhooks: Replace YOUR_URGENT_WEBHOOK and YOUR_ESCALATION_WEBHOOK with your webhook URLs
Google Sheets: Replace YOUR_SPREADSHEET_ID with your spreadsheet ID and authenticate
Email: Configure SMTP/Gmail credentials in the email node
PostgreSQL (optional): Create support_conversations table or disable DB nodes
Production: Replace mock AI nodes with OpenAI/Anthropic API nodes

Key features
Multi-language support (Japanese & English)
Sentiment analysis with urgency detection
Smart escalation routing
Real-time Slack notifications
Comprehensive analytics logging

Nodes Used (5)

Code
n8n-nodes-base.code
Google Sheets
n8n-nodes-base.googleSheets
HTTP Request
n8n-nodes-base.httpRequest
Postgres
n8n-nodes-base.postgres
Send Email
n8n-nodes-base.emailSend