SCM Assistant - Flowise RAG Chatbot

Summary

Built a single Flowise chatbot for the supplied supply-chain CSV and governance PDF. The chatbot retrieves relevant context from MongoDB Atlas vector search and answers supplier-performance and policy questions in one chatflow.

Data Used

• supplier_performance_data.csv
• SupplyChain_Governance_Policy_v3.2.1.pdf

Final Setup

• Embeddings: Google Gemini Embedding
• Embedding model: gemini-embedding-001
• Embedding task type: RETRIEVAL_DOCUMENT
• Vector store: MongoDB Atlas Vector Search
• Chat model: Google Gemini (gemini-2.5-flash)
• Retriever: MongoDB Retriever
• QA chain: Conversational Retrieval QA Chain
• Temperature: 0.2
• Retriever Top K: 10

MongoDB Configuration

• Database: flowise
• Collection: avinash
• Index name: avi_vector_index
• Content field: text
• Embedded field: embedding

Build Process Followed

1. Created the Flowise Cloud account.
2. Uploaded the CSV and PDF into Flowise document stores.
3. Configured Google Gemini Embedding with gemini-embedding-001 and RETRIEVAL_DOCUMENT.
4. Upserted the documents into MongoDB Atlas and verified the stored embedding arrays were populated.
5. Built one chatflow with Google Gemini, MongoDB Retriever, and Conversational Retrieval QA Chain.
6. Tuned the retriever and prompt until both supplier-data and policy questions worked correctly.
7. Published the chatbot publicly and verified the share link.
8. Exported the chatflow JSON for submission.

Chunking

• CSV: Recursive Character Text Splitter, chunk size 500, overlap 50
• PDF: Recursive Character Text Splitter

Public Chatbot URL

https://cloud.flowiseai.com/chatbot/391e701b-cfb5-4403-9f2d-0724fee3e4a1

Validation Q&A

1. Which Tier-3 suppliers have an active disruption flag, and what response level applies per policy?
   11 Tier-3 suppliers: Dravex Components India, Plataforma Metales SA, Maghreb Castworks, Helios Pack Greece, Cerromax Mineria, Orinoco Pack SAPI, Quetzal Textiles, Sibertek Molding, Archipelago PCB Corp, Varna Electronics EAD, Deltaforge Vietnam.
   All are High Risk with an active flag → Level 3 Activate per Policy §9.

2. Which suppliers qualify for the annual Volume Rebate Program and how many are there?
   19 suppliers qualify: Borealis Composites, Crestline Chemical Supply, Fenwick Alloy Solutions, Hanguk Circuit Works, Hokkaido Alloy Tech, Krauss-Polymex GmbH, Lakeshore Components, Lumivex Semiconductor NL, Maplewood Polymer Corp, Norbec Alloy Works, Nordloom Finland Oy, Orrentek Precision Mfg, Ostwind Composites AG, PrecisionForge Taiyuan, Solveig Eco Packaging, Straits Packaging Hub, Tasman Circuit Boards, Toreval Electronics, Valdoro Special Alloys.

3. Which region has the highest total PO value, and does it breach the concentration limit?
   EMEA at $193,987,179.91. Yes, it breaches the 45% regional concentration cap.

4. Which suppliers are on Supplier Watch List (SWL) status and what does it restrict?
   Deltaforge Vietnam, Maghreb Castworks, Helios Pack Greece, Cerromax Mineria, Orinoco Pack SAPI, Varna Electronics EAD, Quetzal Textiles, Plataforma Metales SA, Archipelago PCB Corp, Dravex Components India, Sibertek Molding.
   SWL restricts new PO issuance to 20% of prior quarter volume.

5. Which product category has the highest average defect rate and does it exceed the Tier-2 limit?
   Mechanical Components — average 2.12%. No, it does not exceed the Tier-2 limit of 2.50%.

Submission Files

• scm_assistant.json
• README.md
• /screenshots/
• .gitignore excluding .env and API key files