Build a RAG knowledge chatbot with OpenAI, Google Drive, and Supabase
Ready for 3.0What 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).
- Set File ID (Edit Fields (Set)): sets 1 field: file_id
- RAG AI Agent (AI Agent): runs an AI agent, with model: OpenAI Chat Model; 1 tool (RAG Vector store); memory: Postgres Chat Memory
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Delete a row (Supabase): delete
- Download the file (Google Drive): download
- Extract from File: extracts data from a file (text)
- Supabase Vector Store: stores documents in the Supabase vector store, with embeddings: Embeddings OpenAI; document loader: Default Data Loader
Services it uses
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)
- Google Drive Trigger
n8n-nodes-base.googleDriveTrigger - Edit Fields (Set)
n8n-nodes-base.set - Extract from File
n8n-nodes-base.extractFromFile - Supabase Vector Store
@n8n/n8n-nodes-langchain.vectorStoreSupabase - Default Data Loader
@n8n/n8n-nodes-langchain.documentDefaultDataLoader - Recursive Character Text Splitter
@n8n/n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter - Embeddings OpenAI
@n8n/n8n-nodes-langchain.embeddingsOpenAi - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Supabase
n8n-nodes-base.supabase - Google Drive
n8n-nodes-base.googleDrive - Postgres Chat Memory
@n8n/n8n-nodes-langchain.memoryPostgresChat - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Chat Trigger
@n8n/n8n-nodes-langchain.chatTrigger - AI Agent
@n8n/n8n-nodes-langchain.agent
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…