Extract Google Drive Documents and Build a Searchable Knowledge Base in Supabase
Loading workflow…
Workflow Description
Automates loading files from Google Drive, splitting them into processable text chunks, generating vector embeddings with OpenAI, and storing them in Supabase to create an intelligent search engine queryable through a chat interface.
How it works
- 1.Automatically load documents from Google Drive
- 2.Split text into manageable chunks
- 3.Generate vector embeddings using OpenAI
- 4.Store data in Supabase database
- 5.Respond to user queries based on loaded documents
Use cases
- Build an intelligent knowledge system that answers questions about company documents
- Convert a Google Drive document library into a searchable knowledge base
Requirements
- Google Drive account containing documents to process
- API keys for OpenAI and Supabase
- Direct connection between n8n and Google, OpenAI, and Supabase services
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (7)
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note
Question and Answer Chain
Chain Retrieval Qa
OpenAI Chat Model
OpenAI
Vector Store Retriever
Retriever Vector Store
Customize Response
Set
When chat message received
Chat Trigger
Retrieve by Query
Vector Store Supabase
Embeddings OpenAI Retrieval
OpenAI
Sticky Note4
Sticky Note
Fresh workflows, straight to your inbox
Get newly published DROPIDEA workflows, a clear overview of what they do, and a link to explore them.
- New workflows
- Clear overviews
- Setup guides