Build a product catalog chatbot with Mistral AI, Google Drive & Supabase RAG

AI Product Catalog Chatbot with Google Drive Ingestion & Supabase RAG Overview This workflow builds a dual-system that connects automated document ingestion with a live product catalog chatbot powered by Mistral AI and Supabase. It includes: - Ingestion Pipeline: Automatically fetches JSON files from Google Drive, processes their content, and stores vector embeddings in Supabase. - Chatbot: An AI agent that queries the Supabase vector store (RAG) to answer user questions about the product catalog. It uses Mistral AI for chat intelligence and embeddings, and Supabase for vector storage and semantic product search. --- Chatbot Flow - Trigger: When chat message received or Webhook (from live website) - Model: Mistral Cloud Chat Model (mistral-medium-latest) - Memory: Simple Memory (Buffer Window) — keeps last 15 messages for conversational context - Vector Search Tool: Supabase Vector Store - Embeddings: Mistral Cloud - Agent: product catalog agent - Responds to user queries using the products table in Supabase. - Searches vectors for relevant items and returns structured product details (name, specs, images, and links). - Maintains chat session history for natural follow-up questions. --- Document → Knowledge Base Pipeline Triggered manually (Execute workflow) to populate or refresh the Supabase vector store. Steps 1. Google Drive (List Files) → Fetch all files from the configured Google Drive folder. 2. Loop Over Items → For each file: - Google Drive (Get File) → Download the JSON document. - Extract from File → Parse and read raw JSON content. - Map Data into Fields (Set node) → Clean and normalize JSON keys (e.g., pagetitle, comprehensivesummary, keytopics). - Convert Data into Chunks (Code node) → Merge text fields like summary and markdown. → Split content into overlapping 2,000-character chunks. → Add metadata such as title, URL, and chunk index. - Embeddings (Mistral Cloud) → Generate vector embeddings for each text chunk. - Insert into Supabase Vectorstore → Save chunks + embeddings into the websitemark table. - Wait → Pause for 30 seconds before the next file to respect rate limits. --- Integrations Used | Service | Purpose | Credential | |----------|----------|------------| | Google Drive | File source for catalog JSON documents | Google Drive account dbt | | Mistral AI | Chat model & embeddings | Mistral Cloud account dbt | | Supabase | Vector storage & RAG search | Supabase DB account dbt | | Webhook / Chat | User-facing interface for chatbot | Website or Webhook | --- Sample JSON Data Format (for Ingestion) The ingestion pipeline expects structured JSON product files, which can include different categories such as Apparel or Tools. Apparel Example (T-Shirts) Tools Example (Drill Bits) --- Agent System Prompt Summary > “You are an AI product catalog assistant. Use only the Supabase vector database as your knowledge base. Provide accurate, structured responses with clear formatting — including product names, attributes, and URLs. If data is unavailable, reply politely: ‘I couldn’t find that product in the catalog.’” --- Key Features - Automated JSON ingestion from Google Drive → Supabase - Intelligent text chunking and metadata mapping - Dual-workflow architecture (Ingestion + Chatbot) - Live conversational product search via RAG - Supports both embedded chat and webhook channels --- Summary > A powerful end-to-end workflow that transforms your product data into a searchable, AI-ready knowledge base, enabling real-time product Q&A through a Mistral-powered chatbot. Perfect for eCommerce teams, distributors, or B2B companies managing large product catalogs. --- Need Help or More Workflows? Want to customize this workflow for your business or integrate it with your tools? Our team at Digital Biz Tech can tailor it precisely to your use case — from automation pipelines to AI-powered product discovery. 💡 We can help you set it up for free — from connecting credentials to deploying it live. Contact: rajeet.nair@digitalbiz.tech Website: LinkedIn: You can also DM us on LinkedIn for any help. ---