Build a cost estimation chatbot with Mistral AI, OCR & Supabase

AI Cost Estimation Chatbot (Conversational Dual-Agent + OCR Workflow)

Overview This workflow introduces a conversational AI Cost Estimation Chatbot with built-in OCR document analysis and interactive form guidance. It helps users and teams handle pricing, measurement, and product configuration for multiple categories such as fabrics and tiles — whether data comes from an uploaded invoice, a stored RFQ, or live user input.

The system blends Mistral AI’s reasoning with n8n’s native tools — OCR Extract, Calculator, Supabase, and Gmail — to deliver clear, step-by-step cost calculations. It automatically retrieves or parses OCR data, confirms details conversationally, performs unit conversions, and returns accurate estimates in real time. Escalation and recordkeeping are handled via Gmail and Supabase.

---

Chatbot Flow

Trigger: Chat message (from n8n Chat UI) or Webhook (from a live site). Model: Mistral Cloud Chat Model (mistral-medium-latest) Memory: Simple Memory (Buffer Window, 15-message history)

Tools: - OCR Extract: Reads and converts invoices, receipts, and RFQs into structured data. - Supabase: Stores and retrieves OCR data for re-use in future calculations. - Calculator: Performs all material, area, and cost computations. - Gmail: Escalates customer queries or sends quote summaries. - Agent: ai agent cost estimate

Workflow Behavior: - Retrieves or parses OCR data, confirms and completes missing details interactively. - Guides users step-by-step through product setup (Fabric or Tile). - Calculates costs transparently using MATERIALCOSTS and PROCESSINGCOSTS. - Handles GSM ↔ sqm, area, and weight conversions automatically. - Escalates support or order confirmations via Gmail when requested.