Connect Google Drive with Supabase
Workflow Description
An automation template that links Google Drive documents to Supabase database, extracting text content and converting it into vector embeddings for intelligent search and retrieval through an OpenAI language model.
How it works
- 1.Receive documents from Google Drive or trigger queries via chat interface
- 2.Split document content into indexable text chunks using a recursive text splitter
- 3.Convert text chunks into vector embeddings via OpenAI and store them in Supabase
- 4.Retrieve the most relevant chunks from the database based on query similarity
- 5.Process the query and retrieved chunks through an LLM chain to generate evidence-backed answers
Use cases
- Build an intelligent search system for documents stored in Google Drive with instant answers to questions
- Create a smart assistant that understands large collections of files, contracts, and reports and responds efficiently
- Automate processing of massive documents and organize them in a searchable and rapidly retrievable format
Requirements
- Active Google Drive account with access to the files you want to process
- Supabase account with a database and vector store capability enabled
- OpenAI API key for embeddings and natural language processing
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