{"product_id":"n8n-support-automation-ollama-rag-supabase-kbs-to-slack-gmail","title":"n8n Support Automation: Ollama RAG + Supabase KBs to Slack\/Gmail","description":"\u003ch3\u003eTurn support tickets into instant, source-backed replies—using Ollama RAG + Supabase, delivered to Slack or Gmail\u003c\/h3\u003e\n\u003cp\u003eThis n8n support automation workflow ingests incoming support requests via webhook, validates and rate-limits them in \u003cstrong\u003eSupabase\u003c\/strong\u003e, then uses an \u003cstrong\u003eOllama-powered LangChain agent\u003c\/strong\u003e with \u003cstrong\u003ethree Supabase vector knowledge bases\u003c\/strong\u003e (and optional \u003cstrong\u003eWikipedia\u003c\/strong\u003e search) to generate answers. High\/medium-confidence responses go to \u003cstrong\u003eSlack\u003c\/strong\u003e, \u003cstrong\u003eGmail\u003c\/strong\u003e, or an \u003cstrong\u003eHTTP callback\u003c\/strong\u003e; low-confidence or human handovers are escalated to operators.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives webhook support requests\u003c\/strong\u003e (POST) and validates the \u003ccode\u003ex-api-key\u003c\/code\u003e header—returns \u003cstrong\u003e401\u003c\/strong\u003e if missing\/invalid.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes and logs requests in Supabase\u003c\/strong\u003e to enforce \u003cstrong\u003eper-session rate limiting\u003c\/strong\u003e, returning \u003cstrong\u003e429\u003c\/strong\u003e when limits are exceeded.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRejects invalid\/duplicate messages\u003c\/strong\u003e: checks for an empty body, enforces a \u003cstrong\u003e2000-character limit\u003c\/strong\u003e, and deduplicates by \u003ccode\u003emessage_id\u003c\/code\u003e in Supabase.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReturns \u003ccode\u003e202 Accepted\u003c\/code\u003e immediately\u003c\/strong\u003e while it processes: sanitizes customer queries to mask common PII patterns and detects explicit requests to speak with a human.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns a LangChain agent on Ollama\u003c\/strong\u003e with \u003cstrong\u003ePostgres chat memory\u003c\/strong\u003e, retrieving context from \u003cstrong\u003ethree Supabase vector KBs\u003c\/strong\u003e (and using \u003cstrong\u003eWikipedia\u003c\/strong\u003e when needed).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRoutes outputs\u003c\/strong\u003e based on the agent’s JSON confidence: sends replies to \u003cstrong\u003eSlack\u003c\/strong\u003e, \u003cstrong\u003eGmail\u003c\/strong\u003e, or an \u003cstrong\u003eHTTP callback\u003c\/strong\u003e, and writes a scrubbed audit log with sources and confidence to Supabase.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEscalates when confidence is low\u003c\/strong\u003e or a human is requested—queues escalation in Supabase and alerts operators in Slack during business hours (emails on-call off-hours).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomated L1 support for SaaS: answer FAQs with internal KBs and citations.\u003c\/li\u003e\n  \u003cli\u003ePrevent support overload: rate-limit and deduplicate inbound messages.\u003c\/li\u003e\n  \u003cli\u003eSmart routing: send confirmed answers to Slack\/Gmail while escalating uncertain cases.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\/Nodes:\u003c\/strong\u003e \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003cstrong\u003eGmail\u003c\/strong\u003e, \u003cstrong\u003eSlack\u003c\/strong\u003e, \u003ccode\u003eswitch\u003c\/code\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI layer:\u003c\/strong\u003e Ollama + LangChain agent, Postgres chat memory, retrieval from 3 Supabase vector knowledge bases, optional Wikipedia\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData control:\u003c\/strong\u003e Supabase request logging, rate limiting, deduplication, and audit\/escalation queues\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45962014818483,"sku":"N8N-19217","price":5.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/WzjLQYMQ1zbJ_unJ-zFUC_moW38gbq.png?v=1788599360","url":"https:\/\/buyflowscripts.com\/products\/n8n-support-automation-ollama-rag-supabase-kbs-to-slack-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}