Google Drive to Supabase AI Knowledge Base Ingestion
detail.loadingPreview
This n8n workflow automates the ingestion of files from Google Drive into a Supabase-powered AI knowledge base. It handles file creation and updates, extracts content from various document types, generates AI embeddings, and stores both metadata and vector data for powerful search and RAG applications.
About This Workflow
This robust n8n workflow provides a comprehensive solution for seamlessly transforming your Google Drive files into an intelligent, searchable knowledge base powered by Supabase and AI embeddings. It automatically detects new or updated files, intelligently processes diverse document formats like PDFs, CSVs, XLSX, DOCs, and RTFs, extracts their core content, and then leverages OpenAI to generate vector embeddings. These embeddings, along with rich metadata, are then stored in your Supabase database, ready for advanced AI applications like Retrieval Augmented Generation (RAG) or semantic search. The workflow includes crucial features such as duplicate detection, error logging, and notifications, ensuring data integrity and operational transparency. Build your AI knowledge hub effortlessly.
Key Features
- Automated Google Drive Monitoring: Triggers automatically on new file uploads or updates in specified Google Drive folders.
- Multi-Format Document Extraction: Supports content extraction from a wide range of file types, including PDF, CSV, XLSX, DOC, RTF, and TXT.
- AI-Powered Summarization & Embeddings: Integrates with OpenAI to summarize extracted content and generate high-quality vector embeddings for semantic search capabilities.
- Supabase Integration for Knowledge Base: Stores file metadata in PostgreSQL tables and vector embeddings in Supabase's vector store, forming a powerful AI-ready knowledge base.
- Duplicate File Detection & Notification: Prevents redundant data by checking for existing files and sending alerts for detected duplicates.
- Robust Error Handling: Includes logging to Supabase and email notifications for any workflow failures or processing errors.
How To Use
- Configure Google Drive Triggers: Connect your Google Drive account and specify the folders to monitor for
File CreatedandUpdate to Fileevents. - Set Up Supabase Credentials: Provide your Supabase project URL, API key, and database connection details for both metadata storage (Postgres) and vector store integration.
- Integrate OpenAI API Key: Add your OpenAI API key to the
Embeddings OpenAInode to enable text summarization and vector generation. - Customize File Validation & Extraction: Adjust the
Validate Filenode conditions as needed, and ensure theSwitchnode correctly routes different file types to their respectiveExtract from Filenodes. - Configure Notifications (Optional): Set up the
Log DuplicateandError Loggernodes with your Supabase table details, and customizeSlack Duplicate Notification(or a generic notification node) andError Notification(Gmail) nodes to receive alerts. - Deploy and Monitor: Activate the workflow to begin automatic ingestion and monitor its execution logs for any issues.
Apps Used
Workflow JSON
{
"id": "8b3d0ec8-747f-4c8c-8a74-75a1b8f152b7",
"name": "Google Drive to Supabase AI Knowledge Base Ingestion",
"nodes": 14,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 8b3d0ec8-747f...
About the Author
Free n8n Workflows Official
System Admin
The official repository for verified enterprise-grade workflows.
Statistics
Related Workflows
Discover more workflows you might like
Google Sheets to Icypeas: Automated Bulk Domain Scanning
This workflow streamlines the process of performing bulk domain scans by integrating your Google Sheets data directly with the Icypeas platform. Automate the submission of company names from your spreadsheet to Icypeas for comprehensive domain information, saving valuable time and effort.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.