AI Knowledge Assistant Using Sheets, OpenAI & Supabase Vector Search

Say goodbye to generic chatbot replies!

This smart conversational AI system delivers deeply contextual responses by combining live user input, past conversation history, vector-based knowledge retrieval, and real-time web search — all managed through Google Sheets.

Perfect for support agents, internal knowledge assistants, or AI-powered productivity tools that require accurate, evolving answers.

What it does:

📨 Detects new messages via Google Sheets trigger

🧠 Retrieves chat history and builds contextual prompts

🔍 Searches a Supabase vector database for relevant info using OpenAI embeddings

🌐 Uses web search via SerpAPI when data isn’t found in the knowledge base

🗣️ Generates natural responses using GPT-4 through a LangChain agent

📄 Logs the reply and assigns a unique ID in Google Sheets

Need help setting it up? We offer full configuration and testing for a one-time fee.