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

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