Answer multi-channel support queries with OpenAI RAG and Supabase
Ready for 3.0What this workflow does
This AI workflow has 77 nodes and runs when a new email arrives over IMAP (plus 7 other triggers). Along the way it connects WhatsApp Business Cloud, Slack, OpenAI Chat Model and Zendesk and 7 more.
How it runs
Trigger: When a new email arrives over IMAP (plus 7 other triggers).
- Workflow Configuration (Edit Fields (Set)): sets 10 fields: confidenceThreshold, supabaseTable, maxRetrievalDocs…
- Ingestion Configuration (Edit Fields (Set)): sets 2 fields: supabaseTable, embeddingModel
- Weekly Configuration (Edit Fields (Set)): sets 6 fields: supabaseMetricsTable, googleSheetsDocId, googleSheetsLogSheet…
- Alert Workflow Failure (Slack): uses Slack
- Normalize Payload (Code): runs custom JavaScript code
- Load Source Documents (Code): runs custom JavaScript code
- Fetch Weekly Metrics (Google Sheets): uses Google Sheets
- Automated Email? (If): checks a condition and branches into true / false
- Purge Existing Docs (Supabase): delete
- Aggregate Weekly Metrics (Code): runs custom JavaScript code
…plus 46 more steps. See the full node list below.
Services it uses
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.
- Still check Slack Trigger requires a signing secret on the Slack API credential (Slack Trigger (Mentions)).
Nodes used (30)
- Edit Fields (Set)
n8n-nodes-base.set - Email Trigger (IMAP)
n8n-nodes-base.emailReadImap - Webhook
n8n-nodes-base.webhook - WhatsApp Trigger
n8n-nodes-base.whatsAppTrigger - Slack Trigger
n8n-nodes-base.slackTrigger - Code
n8n-nodes-base.code - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - If
n8n-nodes-base.if - Switch
n8n-nodes-base.switch - Send Email
n8n-nodes-base.emailSend - Zendesk
n8n-nodes-base.zendesk - Slack
n8n-nodes-base.slack - Google Sheets
n8n-nodes-base.googleSheets - Schedule Trigger
n8n-nodes-base.scheduleTrigger - AI Agent
@n8n/n8n-nodes-langchain.agent - No Operation, do nothing
n8n-nodes-base.noOp - Supabase Vector Store
@n8n/n8n-nodes-langchain.vectorStoreSupabase - Embeddings OpenAI
@n8n/n8n-nodes-langchain.embeddingsOpenAi - Respond to Webhook
n8n-nodes-base.respondToWebhook - Discord
n8n-nodes-base.discord - WhatsApp Business Cloud
n8n-nodes-base.whatsApp - Postgres Chat Memory
@n8n/n8n-nodes-langchain.memoryPostgresChat - Error Trigger
n8n-nodes-base.errorTrigger - Manual Trigger
n8n-nodes-base.manualTrigger - Default Data Loader
@n8n/n8n-nodes-langchain.documentDefaultDataLoader - Recursive Character Text Splitter
@n8n/n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter - Remove Duplicates
n8n-nodes-base.removeDuplicates - Supabase
n8n-nodes-base.supabase - Postgres
n8n-nodes-base.postgres
From the author
Quick overview Answers customer questions on Email, Live Chat, WhatsApp, Slack and Discord from your own documentation, retrieved through a Supabase vector store. Ungrounded answers, negative sentiment and explicit handover requests escalate to a human with a…