Loading... Loading... Loading... Loading... Loading... United Arab Emirates, Dubai
RAG · AI Automation · Case Study

CloudSellPOS · Intelligent Support System

AI-Powered
Chatbot & RAG Automation

Transforming CloudSellPOS's entire knowledge base into an AI-driven support engine — delivering instant, hallucination-free answers with source links, and automatically escalating unresolved queries to the technical team via Microsoft Teams.

ClientCloudSellPOS
System TypeRAG · AI Agent · Support Automation
Core Stackn8n · OpenAI · Supabase · Teams
Orchestrationn8n with AI Nodes
0%
Responses Grounded in Real Documentation
0 AI
Hallucinations — Context-Only Answers
0/7
Instant Technical Support Coverage
0
Metadata Fields Per Chunk for Precise Retrieval
2
Automated n8n Pipelines (Ingestion + Retrieval)

01 — Overview

Executive Summary

The CloudSellPOS Docs ChatBot transforms the company's knowledge base articles and technical documentation into an advanced AI-powered "knowledge memory." This is achieved by extracting data, chunking it, converting it into vector embeddings, and storing it in a Supabase vector database.

The system provides an AI Agent capable of delivering instant and accurate responses to customer inquiries, complete with direct source links for verification — eliminating AI hallucination entirely.

When the knowledge base cannot answer a query, an automation sub-workflow captures customer details and escalates the request to the technical support team via a formatted Microsoft Teams notification — ensuring no customer inquiry falls through the cracks.

The Problem

Key Challenges

🔍
Traditional Search Limitations

Users struggled to locate specific information within articles exceeding 3,000 words — keyword search returned irrelevant results and required users to read entire documents.

🧠
AI Hallucination Risk

General LLMs fabricate plausible-sounding but incorrect answers. CloudSellPOS required responses strictly derived from their own documentation — not the model's general training data.

🌙
After-Hours Support Gap

Complex queries arriving outside business hours had no resolution path. There was no automated mechanism to capture, log, and route these requests to the appropriate team.

02 — Live System

The AI Assistant
in Action

Embedded directly into the CloudSellPOS platform, the chatbot greets users with a natural conversational interface. Every response is generated from the vector knowledge base — never from general AI knowledge — and includes a direct link to the source article for full transparency.

  • Answers in the same language the user writes in (Arabic / English)
  • Retrieves the top 3–5 most semantically relevant documentation chunks
  • Always cites the source article URL alongside the answer
  • Detects unanswerable queries and triggers the escalation sub-workflow
  • Collects customer name, email, and phone before escalating
RAG Architecture GPT-4o-mini LangChain Source Citations
AI
CloudSellPOS Assistant
● Online · Powered by RAG
Live
CloudSellPOS AI Chatbot — live interface embedded in the platform
Instant Answers Vector Search Source Links Auto-Escalation

03 — Data Architecture

Embedding Pipeline & Chunking Strategy

Every article is processed, sliced, enriched with metadata, and converted into searchable vector embeddings before being stored in Supabase.

Chunking Strategy

Instead of feeding entire articles into the model (which degrades retrieval accuracy), content is divided into focused, overlapping chunks that preserve context continuity.

800–1000
Characters per Chunk
100–150
Character Overlap

Overlap ensures context continuity between adjacent chunks — so answers spanning paragraph boundaries are never truncated or lost.

Metadata Mapping Per Chunk

Each chunk is stored in Supabase alongside a structured JSONB metadata object — enabling the AI Agent to filter, cite, and route responses with precision.

Field Purpose
article_idOriginal article identifier — de-duplication key
titleArticle title to anchor AI Agent context window
urlDirect source link surfaced in every response
categoryClassification (Technical, Invoices, General) for filtered search
last_updatedEnsures the model relies on the most current documentation

04 — Technical Workflow

n8n Automation Pipelines

Two dedicated n8n pipelines handle the full lifecycle — from raw article ingestion to intelligent real-time retrieval and human escalation.

Pipeline 1

Data Ingestion

🗄DBExtract Articles
(MySQL/PG)
›
⚙️JS NodeClean & Chunk
+ Metadata
›
🧮OpenAIGenerate
Embeddings
›
🗃SupabaseStore Vectors
+ JSONB
Pipeline 2

Retrieval & Smart Escalation

💬UserCustomer
Question
›
🧮OpenAIQuery
Embedding
›
🗃SupabaseVector Search
Top 3–5
›
🧠GPT-4o-miniContext
Injection
›
✅AnswerResponse +
Source Link
›
🚨EscalationTeams Alert
+ Sheets Log
n8n Workflow Canvas — Full Automation Pipeline
Both pipelines: Ingestion + Retrieval & Escalation
Live Build
n8n workflow canvas — CloudSellPOS RAG chatbot automation pipeline

05 — Escalation System

Smart Escalation to
Microsoft Teams

When the AI Agent cannot find a satisfactory answer in the knowledge base, it doesn't simply say "I don't know." Instead, it triggers a customer follow-up sub-workflow — collecting the prospect's details and routing the request to the right person instantly.

1
Detect Unresolvable Query

The AI Agent identifies that no relevant chunks exist in the vector store and shifts to data-collection mode.

2
Collect Customer Details

Conversationally requests the customer's name, email, and phone number before escalating.

3
Log to Google Sheets

Stores customer details and a summary of the request in the escalation ledger for tracking and follow-up.

4
Instant Teams Notification

Fires a formatted HTML alert to the technical support channel in Microsoft Teams — ensuring a human responds rapidly.

CS
Support Escalation Alert
Microsoft Teams — Technical Support Channel
Escalated
Microsoft Teams escalation notification — CloudSellPOS chatbot support alert

↑ Actual Teams notification triggered by the escalation sub-workflow — includes customer details, query summary, and a direct action prompt for the support team.

06 — Technology

Stack & Integration Matrix

⚙️
n8n (AI Nodes)
Core orchestration engine for both ingestion and retrieval pipelines — all conditional logic, error handling, and sub-workflow triggers
Self-Hosted · Encrypted Vaults
🗃
Supabase + pgvector
Vector database storing all embeddings with JSONB metadata. HNSW index ensures sub-millisecond retrieval across hundreds of thousands of records
Supabase Service Role Key
🧠
OpenAI GPT-4o-mini
AI Agent for context injection, reasoning, and generating accurate responses with strict prompt instructions to stay within the provided documentation
Bearer Token · TLS 1.3
🧮
text-embedding-3-small
OpenAI's embedding model — converts both document chunks and user queries into dense vector representations for semantic similarity search
OpenAI API Key
🔗
LangChain
Provides the retrieval-augmented generation framework — manages context window injection, retrieval chain, and prompt templating for the AI Agent
Integrated via n8n AI Nodes
💬
Microsoft Graph API
Delivers formatted HTML escalation alerts to the Teams technical support channel when customer queries cannot be resolved automatically
Azure OAuth2 · Client Credentials
📋
Google Sheets API
Escalation ledger — logs customer details, query summaries, timestamps, and resolution status for every unanswered inquiry
Google Cloud Service Account
⚡
HNSW Index
Hierarchical Navigable Small World index applied to Supabase vector fields — ensures ultra-fast approximate nearest-neighbour search at scale
pgvector Extension

07 — Results

Business Impact

🎯

Zero Hallucinations

Every answer is strictly grounded in CloudSellPOS's own documentation. Strict prompt instructions prevent the model from drawing on general training knowledge — building customer trust through verifiable, source-linked responses.

⚡

Instant 24/7 Coverage

Technical questions that previously required a support agent are now answered in seconds at any hour — dramatically reducing ticket volume and freeing the team for complex escalations only.

🔍

Precision Filtered Search

Category metadata enables the AI Agent to restrict searches to specific article types (e.g., "Technical Only") — delivering laser-focused answers without noise from unrelated documentation sections.

🔗

Source Transparency

Every response includes a direct link to the source article, allowing users to read the full context independently. This turns the chatbot into a navigation tool, not just an answer machine.

🚨

Zero Missed Escalations

The automated escalation workflow ensures that every unresolved query is captured, logged, and instantly routed to a human — no query disappears after business hours without a follow-up trail.

📈

Scalable Knowledge Base

The HNSW-indexed Supabase vector store scales to hundreds of thousands of chunks without performance degradation — the system grows automatically as CloudSellPOS adds new documentation.

Ready to build your AI support system?

Turn Your Documentation
Into an AI Knowledge Engine

Let's build a RAG-powered chatbot tailored to your product's documentation, your support team's workflow, and your customers' language.

Start Your Project