Templates / Build a RAG knowledge chatbot with OpenAI, Google Drive, and Supabase

Build a RAG knowledge chatbot with OpenAI, Google Drive, and Supabase

Ready for 3.0

by Babish Shrestha ✓ · 1,315 views · created 2025-09-04 · Internal Wiki, AI RAG

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This AI workflow has 17 nodes and runs on Google Drive events (file created) (plus 2 other triggers). Along the way it connects Google Drive, Supabase Vector Store, Embeddings OpenAI and Supabase and 2 more.

How it runs

Trigger: On Google Drive events (file created) (plus 2 other triggers).

  1. Set File ID (Edit Fields (Set)): sets 1 field: file_id
  2. RAG AI Agent (AI Agent): runs an AI agent, with model: OpenAI Chat Model; 1 tool (RAG Vector store); memory: Postgres Chat Memory
  3. Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
  4. Delete a row (Supabase): delete
  5. Download the file (Google Drive): download
  6. Extract from File: extracts data from a file (text)
  7. Supabase Vector Store: stores documents in the Supabase vector store, with embeddings: Embeddings OpenAI; document loader: Default Data Loader

Services it uses

Google DriveSupabase Vector StoreEmbeddings OpenAISupabasePostgres Chat MemoryOpenAI Chat Model

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (14)

From the author

🚀 Build Your Own Knowledge Chatbot Using Google Drive Create a smart chatbot that answers questions using your Google Drive PDFs—perfect for support, internal docs, education, or research. 🛠️ Quick Setup Guide Step 1: Prerequisites - n8n instance (cloud or…

Excerpt from Babish Shrestha's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.