Google Drive to Supabase Knowledge Base Automation

🚀 Google Drive to Supabase Knowledge Base Automation

Turn your documents into a searchable, AI-ready knowledge base — effortlessly.

Build a powerful backend for AI assistants, document Q&A bots, or internal tools using this ready-to-deploy n8n automation. It connects Google Drive to Supabase and brings structure, scalability, and intelligence to your docs.

🔧 What This Automation Does

This workflow bridges your cloud storage with vector search technology to power modern AI tools:

• 📂 Ingests documents from your Google Drive
• 🧠 Processes content with OpenAI or Gemini
• 📦 Stores data in a Supabase vector database
• 🔁 Automatically updates when documents change — no duplication
• 🆕 Handles new documents as they’re added
• 🔌 Modular setup — easy to expand for other file types (Word, HTML, etc.)

🛠️ Setup Instructions

Here’s how to get everything connected and running:

1️⃣ Connect Google Drive to n8n

To allow n8n to read your files:

• 🔑 Set up a Google OAuth app
• 🔗 Connect it to your n8n instance
• 🗂️ Use the Google Drive node to access documents

📺 Video Guide: How to connect Google Drive to n8n (5 min)
📚 Docs: Google Drive Node – n8n

2️⃣ Set Up Supabase + pgvector

Supabase stores your documents in vector format, enabling semantic search:

• 🆓 Create a free Supabase account
• ⚙️ Set up a project
• 🧩 Enable the pgvector extension

📚 Docs:

• Getting Started with Supabase
• How to Enable pgvector

3️⃣ Add Your OpenAI (or Gemini) API Key

An LLM is used to convert text into embeddings:

• 🛠️ Create an OpenAI API key (or use Gemini)
• 🔐 Add the key to n8n’s credentials section under “OpenAI”

📺 Video: Connect OpenAI with n8n
📚 Docs: OpenAI Credentials in n8n

4️⃣ Import and Run the Workflow

Everything’s pre-built and ready to deploy:

• 📥 Load the provided n8n workflow
• 🔗 Connect all credentials (Drive, Supabase, OpenAI)
• ⚙️ Choose mode: , , or
• ✅ Click Test Workflow — you're done!

💡 Use Cases

This automation is ideal for projects that need scalable, AI-enhanced document handling:

• 🤖 AI Assistants with memory from internal docs
• 💬 Chatbots with document-aware replies
• 🎙️ Voice interfaces that pull context dynamically
• 🛠️ Customer support tools with embedded knowledge

✅ Key Benefits

• 🧩 No-code friendly — powered by n8n
• ⚡ Fast setup — get going in minutes
• 🔍 Searchable knowledge — vector-powered for accuracy
• 🔄 Always up-to-date — syncs as docs change
• 🔐 LLM-compatible — works with OpenAI, Gemini & more
• 🧱 Fully modular — extend to more formats and platforms