Connect Google Drive with Supabase
Workflow Description
Advanced template integrating Google Drive documents with AI-powered Supabase database. Automatically loads files, splits them into manageable chunks, creates vector embeddings via OpenAI, and stores them in Supabase for intelligent querying and data-backed answers.
How it works
- 1.Activate trigger upon receiving a chat query from the user interface
- 2.Fetch documents from the specified Google Drive folder
- 3.Load and analyze document content using default data loader
- 4.Split text into balanced chunks using recursive character splitter
- 5.Convert chunks into numerical embeddings via OpenAI API
- 6.Store vectors and document metadata in Supabase for fast retrieval
Use cases
- Build an automated Q&A system based on company documents stored in Drive
- Create an intelligent search engine delivering precise results from large text databases
- Automate processing and semantic classification of legal or technical documents
- Empower customer support with self-service powered by updated company documentation
Requirements
- Active Google Cloud account with Drive API enabled and folder access permissions
- Supabase account with valid API key and prepared database
- Valid OpenAI API key for embedding generation and intelligent responses
- n8n workflow with internet connection and sufficient permissions for third-party integrations
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