Index Google Drive files into a Supabase vector store with OpenAI embeddings
n8n26 modulesv1.0Full walkthrough video: Author: Cole Medin Who it's for This workflow is for developers, data engineers, and knowledge management teams who need to automatically ingest documents stored in Google Drive into a searchable vector database — supporting RAG (retrieval-augmented generation) pipelines or semantic search applications. How it works 1. One-time setup: A chat trigger runs SQL queries to create the required Postgres tables (documents, documentmetadata, documentrows) and the vector similari
At a glance
Index Google Drive files into a Supabase vector store with OpenAI embeddings 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
- 26
- Price
- Free
- Version
- v1.0
About this workflow
Full walkthrough video: Author: Cole Medin Who it's for This workflow is for developers, data engineers, and knowledge management teams who need to automatically ingest documents stored in Google Drive into a searchable vector database — supporting RAG (retrieval-augmented generation) pipelines or semantic search applications. How it works 1. One-time setup: A chat trigger runs SQL queries to create the required Postgres tables (documents, documentmetadata, documentrows) and the vector similarity match function in Supabase/Postgres. 2. Trigger: Two Google Drive triggers detect newly created or updated files in a watched folder and pass them into a batch loop. 3. Clean old data: For each file, stale document rows and vector embeddings are deleted from Supabase before re-processing. 4. Metadata upsert & download: Document metadata (ID, title, URL) is upserted into Postgres, then the file binary is downloaded from Google Drive. 5. Route by file type: A Switch node directs each file to the correct extractor — PDF, Word/Office document, Excel spreadsheet, or CSV. 6. Tabular data storage: Excel and CSV rows are inserted as raw JSONB records into Postgres and aggregated into a summary. 7. Embedding & storage: All extracted text (documents, PDFs, tabular summaries) is chunked with a character text splitter, embedded via OpenAI, and inserted into the Supabase vector store. How to set up - [ ] Connect Google Drive OAuth2 credentials to the two trigger nodes and the download node - [ ] Add Supabase credentials to the delete and vector store insert nodes - [ ] Add Postgres credentials to all Postgres nodes (table creation, metadata upsert, schema update, row insert) - [ ] Set your OpenAI API key in the OpenAI Embeddings node - [ ] Run the setup flow once via the chat trigger to create all database tables and the vector match function - [ ] Set the Google Drive folder ID to watch in both trigger nodes - [ ] Tune the Character Text Splitter chunk size and overlap to fit your document sizes Requirements - Google Drive account (OAuth2) - Supabase project with pgvector extension enabled - Postgres database (can be the Supabase Postgres instance) - OpenAI API key How to customize - Add file types: Extend the Switch node with additional branches (e.g., PowerPoint, plain text) and pair each with an appropriate extractor. - Swap the embedding model: Replace text-embedding-3-small with a larger OpenAI model or an alternative provider (e.g., Cohere, Mistral) in the embeddings node. - Connect a RAG chatbot: Pipe the Supabase vector store into an AI Agent or chain node to build a document Q&A assistant on top of the ingested files.
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
Auto-follow-up for canceled Calendly meetings with GPT-4, Loom & Asana
Manage Google Calendar via WhatsApp with GPT-4 virtual assistant
Create Facebook ads copy with Google Sheets and ChatGPT: BAB formula
Turn your portfolio into an AI assistant with OpenAI, Claude, Pinecone and Gmail
✨🤖Automate Multi-Platform Social Media Content Creation with AI
Extract specific website data with form input, Gemini 2.5 flash and Gmail
Build enterprise RAG system with Google Gemini file search & retell AI voice
Auto-generate Facebook posts from video insights using Dumpling AI + GPT-4o
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