Extract Google Drive Documents and Build Knowledge Base in Supabase
Workflow Description
Automation that loads documents from Google Drive automatically, splits them into text chunks, converts them to semantic vectors via OpenAI, and stores them in Supabase to answer intelligent questions powered by AI retrieval.
How it works
- 1.Trigger automatic document loading from specified Google Drive folder
- 2.Split text content into manageable chunks for processing
- 3.Convert text chunks into semantic vectors using OpenAI embeddings
- 4.Store vectors in Supabase vector database for semantic search
- 5.Receive user questions through chat interface
- 6.Retrieve and respond with answers based on stored document content
Use cases
- Build an intelligent assistant that answers employee questions about company policies and procedures from stored documents
- Search and extract precise information from legal documents, compliance reports, or extensive knowledge bases instantly
Requirements
- Google Drive account with full access permissions to target documents
- OpenAI API keys for generating semantic embeddings
- Supabase database configured and ready for vector storage operations
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 (21)
Google Drive
Google Drive
Default Data Loader
Document Default Data Loader
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
Recursive Character Text Splitter1
Text Splitter Recursive Character Text Splitter
Customize Response
Set
When chat message received
Chat Trigger
Retrieve by Query
Vector Store Supabase
Embeddings OpenAI Retrieval
OpenAI
Embeddings OpenAI Insertion
OpenAI
Placeholder (File/Content to Upsert)
Set
Embeddings OpenAI Upserting
OpenAI
Insert Documents
Vector Store Supabase
Retrieve Rows from Table
Supabase
Sticky Note4
Sticky Note
Update Documents
Vector Store Supabase