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.
What this workflow does
This workflow has 18 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Postgres and Google Sheets. It also calls hooks.slack.com over HTTP.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Extract & Enrich Data (Edit Fields (Set)): sets 8 fields: questionId, userQuestion, userEmail…
- Sentiment & Context Analysis (Code): runs custom JavaScript code
- Urgency Check (If): checks a condition and branches into true / false
- Send Urgent Alert (HTTP Request): calls hooks.slack.com (POST)
- Merge: merges the data from its input branches
- Fetch Conversation History (Postgres): run a query
- Search Knowledge Base (Code): runs custom JavaScript code
- Build AI Context (Code): runs custom JavaScript code
- AI Response Generator (Code): runs custom JavaScript code
- Process & Analyze Response (Code): runs custom JavaScript code
…plus 7 more steps. See the full node list below.
Services it uses
HTTP calls to: hooks.slack.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
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
From the author
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…