Templates / Answer multi-channel support queries with OpenAI RAG and Supabase

Answer multi-channel support queries with OpenAI RAG and Supabase

Ready for 3.0

by Țugui Dragoș ✓ · 8,088 views · created 2025-12-15 · Support Chatbot, AI RAG

Ready 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 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).

  1. Workflow Configuration (Edit Fields (Set)): sets 10 fields: confidenceThreshold, supabaseTable, maxRetrievalDocs…
  2. Ingestion Configuration (Edit Fields (Set)): sets 2 fields: supabaseTable, embeddingModel
  3. Weekly Configuration (Edit Fields (Set)): sets 6 fields: supabaseMetricsTable, googleSheetsDocId, googleSheetsLogSheet…
  4. Alert Workflow Failure (Slack): uses Slack
  5. Normalize Payload (Code): runs custom JavaScript code
  6. Load Source Documents (Code): runs custom JavaScript code
  7. Fetch Weekly Metrics (Google Sheets): uses Google Sheets
  8. Automated Email? (If): checks a condition and branches into true / false
  9. Purge Existing Docs (Supabase): delete
  10. Aggregate Weekly Metrics (Code): runs custom JavaScript code

…plus 46 more steps. See the full node list below.

Services it uses

WhatsApp Business CloudSlackOpenAI Chat ModelZendeskGoogle SheetsSupabase Vector StoreEmbeddings OpenAIDiscordPostgres Chat MemorySupabasePostgres

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)

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…

Excerpt from Țugui Dragoș's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.