Document-based RAG chat assistant with Google Drive, Supabase & OpenAI
n8n32 modulesv1.0What is this? This RAG workflow allows you to build a smart chat assistant that can answer user questions based on any collection of documents you provide. It automatically imports and processes files from Google Drive, stores their content in a searchable vector database, and retrieves the most relevant information to generate accurate, context-driven responses. The workflow manages chat sessions and keeps the document database current, making it adaptable for use cases like customer support, i
At a glance
Document-based RAG chat assistant with Google Drive, Supabase & OpenAI is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects OpenAI, Google Drive. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- OpenAI, Google Drive
- Modules
- 32
- Price
- Free
- Version
- v1.0
About this workflow
What is this? This RAG workflow allows you to build a smart chat assistant that can answer user questions based on any collection of documents you provide. It automatically imports and processes files from Google Drive, stores their content in a searchable vector database, and retrieves the most relevant information to generate accurate, context-driven responses. The workflow manages chat sessions and keeps the document database current, making it adaptable for use cases like customer support, internal knowledge bases, or HR assistant etc. How it works 1. Chat RAG Agent - Uses OpenAI for responses, referencing only specific data from the vector store (data that is uploaded on google drive folder). - Maintains chat history in Postgres using a session key from the chat input. 2. Data Pipeline (File Ingestion) - Monitors Google Drive for new/updated files and automatically updates them in vector store - Downloads, extracts, and processes file content (PDFs, Google Docs). - Generates embeddings and stores them in the Supabase vector store for retrieval. 3. Vector Store Cleanup - Scheduled and manual routines to remove duplicate or outdated entries from the Supabase vector store. - Ensures only the latest and unique documents are available for retrieval. 4. File Management - Handles folder and file creation, upload, and metadata assignment in Google Drive. - Ensures files are organized and linked with their corresponding vector store entries. Getting Started - Create and connect all relevant credentials - Google Drive - Postgres - Supabase - OpenAI - Run the table creation nodes first to set up your database tables in Postgres - Upload your documents through Google Drive (or swap out for a different file storage solution) - The agent will process them automatically (chunking text, storing tabular data in Postgres) - Start asking questions that leverage the agent's multiple reasoning approaches Customization (optional) This template provides a solid foundation that you can extend by: - Tuning the system prompt for your specific use case - Adding document metadata like summaries - Implementing more advanced RAG techniques - Optimizing for larger knowledge bases - Note, if you're using a different nodes eg. file storage, vector store etc the integration may vary a little Prerequisites - Google account (google drive) - Supabase account - OpenAI APIs - Postgres account
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Create new files in Google Drive from new media responses in VideoAsk
Automate YouTube video SEO tagging with GPT and Slack notifications
AI privacy-minded router: PII detection for privacy, security, & compliance
💾 Backup automation for n8n workflows to Google Drive (daily or manual)
Manage Shopify store via conversational OpenAI assistant with SmartCommerce
Hacker News to video content
Generate & enrich LinkedIn leads with Apollo.io, LinkedIn API, Mail.so & GPT-3.5
Enrich LinkedIn profiles with Apollo and display candidate pages in the browser
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you