AI Agent RAG Architecture Diagram

Google Sheet (Data Source)

(Realtime Data)

Flask API (Python)

gspread
Google Sheet API

dotenv
Env Management

RAG Pipeline

ChromaDB
Vector Store

LangChain
LLM Orchestration

sentence-transformers
Embeddings

LLM: Google Gemini (via LangChain)

Prompt Engineering: Narasi Insight

Frontend / API Client

(HTML+JS, Integrasi Platform Lain)

Legend

Google Sheet: Sumber data utama, diakses real-time via API.
Flask API: Backend Python, handle request, filtering, agregasi, dan orchestrasi pipeline.
RAG Pipeline: Retrieval-Augmented Generation, menggabungkan vector store (ChromaDB), LLM, dan embeddings.
LLM: Gemini: Model AI generatif, menghasilkan insight narasi berbasis data.
Frontend/API Client: UI web atau integrasi ke platform lain.