AI Study Assistant with RAG - Google Gemini with Drive & Supabase Vector Search

How it works

A complete AI-powered study assistant system that lets you chat naturally with your documents stored in Google Drive:

The system has two connected workflows:

1. Document Indexing Pipeline (Sub-workflow): • Accepts Google Drive folder URLs • Automatically fetches all files from the folder • Converts documents to plain text • Generates 768-dimensional embeddings using Google Gemini • Stores everything in Supabase vector database for semantic search

2. Study Chat Agent (Main workflow): • Provides a conversational chat interface • Automatically detects and processes Google Drive links shared in chat • Searches your indexed documents using semantic similarity • Maintains conversation history across sessions • Includes calculator for math problems • Responds naturally using Google Gemini 2.5 Pro

Use Cases: Students studying for exams, researchers managing papers, professionals building knowledge bases, anyone needing to query large document collections conversationally.

Set up steps

Prerequisites: • Google Drive OAuth2 credentials • Google Gemini API key (free tier available) • Supabase account with Postgres connection • ~15 minutes setup time

Complete Setup:

Part 1: Document Indexing Workflow Add Google Drive OAuth2 credentials to the Drive nodes Configure Supabase Postgres credentials in the SQL node Add Supabase API credentials to the Vector Store node Add Google Gemini API key to the Embeddings node

Part 2: Study Agent Workflow Import the Study Agent workflow Verify the "Folder all file to vector" tool links to the indexing workflow Add Google Gemini API credentials to both Gemini nodes Configure Supabase API credentials in the Vector Store node Add Postgres credentials for Chat Memory Deploy and access the chat via webhook URL

How to Use: Open the chat interface (webhook URL) Paste a Google Drive folder link in the chat Wait for indexing to complete (~1-2 minutes) Start asking questions about your documents The AI will search and answer from your materials

Note: The indexing workflow runs automatically when you share Drive links in chat, or you can run it manually to pre-load documents.

System Components: Main Agent:** Gemini 2.5 Pro with conversational AI Vector Search:** Supabase with pgvector (768-dim embeddings) Memory:** Postgres chat history (10-message context window) Tools:** Document retrieval, Drive indexing, calculator Embedding Model:** Google Gemini text-embedding-004