Zakaria Ben
Workflows by Zakaria Ben
Build a RAG-powered AI assistant with OpenAI, Google Drive & Supabase Vector DB
## Target Audience This guide is designed for developers, data scientists, and AI enthusiasts who want to create intelligent chatbots capable of understanding and using custom data. Whether you are building a research assistant, a customer support bot, or an internal knowledge base tool, this workflow helps you integrate your own documents into an AI chat system. ## What Is RAG and Why Use It? Retrieval-Augmented Generation (RAG) is an AI architecture that combines information retrieval with text generation. Instead of relying solely on a model’s built-in knowledge, RAG retrieves relevant data from external sources—such as your uploaded documents—and feeds it into the AI’s reasoning process. This approach solves a major limitation of traditional language models: their inability to access or recall up-to-date or proprietary information. By using RAG, your chatbot can deliver accurate, context-aware answers drawn directly from your specific data. ## Use Case Example Consider a scenario where your organization has a collection of internal reports, manuals, or research documents. With RAG, your AI chatbot can answer detailed questions about these materials without exposing sensitive data externally. This setup is ideal for teams working in customer support, technical documentation, education, or data analysis. ## Workflow Overview #### Step 1: Upload Your Document Add your document to the Supabase Vector Store using the "Add Document" feature after downloading or linking it via Google Drive. #### Step 2: Data Retrieval The workflow retrieves and embeds your document’s content into the vector database for efficient search and retrieval. #### Step 3: AI Query Processing When you ask a question, the AI retrieves the most relevant context from the Supabase Vector Store based on semantic similarity. #### Step 4: Response Generation The AI combines the retrieved context with its generative capabilities to produce accurate, data-driven responses tailored to your input. ## Prerequisites Before setting up the workflow, ensure you have the following: A GitHub account A Supabase account A Google Drive document containing your data Basic understanding of APIs and environment configuration ## Setup Instructions ### Step 1: Create Accounts Create a GitHub account and clone the repository containing the workflow. Then, create a Supabase account and a new project to generate your API keys. ### Step 2: Prepare Your Data Upload your data to Google Drive and make it downloadable. Add the document to the Supabase Vector Store using the “Add Document” feature. ### Step 3: Configure the Environment Set your Supabase keys as environment variables in your workflow configuration. ### Step 4: Run the Workflow Execute the workflow to connect your document with the AI agent. Once configured, you can start chatting with the AI agent—your responses will now be powered by your own data.
Chatbot appointment scheduler with Google Calendar for dental assistant
This workflow template is designed for dental assistants and anyone looking to automate appointment scheduling. It integrates Google Calendar for booking appointments and Google Sheets as a database to store patient information. # How It Works The user interacts with the chatbot to schedule an appointment. The chatbot collects necessary details and checks availability via Google Calendar. If the requested time is available, the AI books the appointment. If unavailable, the AI suggests alternative time slots. Once booked, the AI logs the appointment details into Google Sheets for record-keeping. # Setup Instructions 📌 Watch this 🎥 [Setup Video](https://youtu.be/FKCmGhdP8oE) for detailed instructions on running and customizing this workflow. ### Step 1: Set Up Credentials OpenAI API Key (for chatbot functionality). Google Account (for Google Sheets & Google Calendar integration). ### Step 2: Choose the Right Tools Select the correct Google Calendar in the Google Calendar tool. Choose the appropriate Google Sheets file in the Google Sheets tool. ### Step 3: Test Run a test to ensure everything works correctly. Once tested. #### Example Templates Below are sample Google Sheets template to help you get started. 