Route AI-powered customer support via email and Slack with PostgreSQL and Google Sheets
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.
Nodes used (10)
- Webhook
n8n-nodes-base.webhook - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - HTTP Request
n8n-nodes-base.httpRequest - Merge
n8n-nodes-base.merge - Postgres
n8n-nodes-base.postgres - Send Email
n8n-nodes-base.emailSend - Google Sheets
n8n-nodes-base.googleSheets - Respond to Webhook
n8n-nodes-base.respondToWebhook
What it does
Automate intelligent customer support responses with AI and Slack How it works 1. Receive request via webhook with customer question 2. Analyze sentiment and detect urgency using JavaScript 3. Send urgent alerts to Slack for critical cases 4. Search knowledge base and fetch conversation history from PostgreSQL 5. Generate AI response with context-aware prompts 6. Route intelligently: Auto-respond via email OR escalate to Slack 7. Log everything to Google Sheets and PostgreSQL for analytics Setup steps 1. Slack webhooks: Replace YOURURGENTWEBHOOK and YOURESCALATIONWEBHOOK with your webhook URLs 2. Google Sheets: Replace YOURSPREADSHEETID with your spreadsheet ID and authenticate 3. Email: Configure SMTP/Gmail credentials in the email node 4. PostgreSQL (optional): Create supportconversations table or disable DB nodes 5. 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