🧠 DriveToRAG - Turn Your Google Drive into an AI Agent Ready RAG Knowledge Base - n8n workflow

Transform your Google Drive files into intelligent, searchable knowledge with this powerful n8n workflow. DriveToRAG automatically monitors your Google Drive folders and converts documents into vector embeddings for advanced retrieval augmented generation (RAG) applications.

🚀 Key Features

• Automatic Document Processing: Monitors Google Drive folders for new, updated, or deleted files
• Multi-Format Support: Processes Google Docs, PDFs, HTML, Google Sheets, Excel files, and images
• Advanced OCR Integration: Extracts text from images and scanned PDFs using OCR technology
• Intelligent Vector Database: Stores embeddings in Supabase for semantic search and RAG applications
• Change Detection: Smart hash-based system only updates embeddings when content changes
• Metadata Preservation: Maintains file metadata for improved context during retrieval
  

💡 Use Cases

• Create AI assistants that can answer questions from your documentation
• Build intelligent search across your organization's knowledge base
• Develop chatbots that can reference your company's internal documents
• Implement semantic search for legal documents, research papers, or technical documentation
• Automate knowledge extraction from your growing document collection

⚙️ Requirements

• n8n instance (cloud or self-hosted)
• Google Drive account
• OpenAI API key
• Supabase account
• Mistral AI API key (for advanced OCR)

🔧 Easy Setup

The workflow comes with comprehensive documentation that guides you through:

• Setting up required credentials
• Configuring Google Drive folder monitoring
• Creating the necessary Supabase tables
• Testing and verifying the workflow

💬 FAQ

Q: Can this workflow handle large documents?

A: Yes! The workflow uses recursive character splitting to break large documents into manageable chunks while preserving context.

Q: How many documents can it process?

A: The workflow can handle thousands of documents, limited only by your Supabase and OpenAI API quotas

Q: Is the RAG vector database updated in real-time when files are added, deleted, or modified in the Google Drive folder?

A: Yes, the workflow continuously monitors your Google Drive folders and automatically updates the vector database whenever changes occur. The system uses efficient change detection to process only modified content, ensuring your knowledge base stays current with minimal processing overhead.

Q: Can I adapt this workflow for other storage systems like Dropbox, OneDrive, or SharePoint?

A: Absolutely! The workflow's modular design allows you to substitute the Google Drive trigger node with nodes for other storage platforms. You'll need to configure the appropriate credentials and adjust some data mapping, but the core document processing and embedding pipeline remains the same.

Q: Where are the RAG vector embeddings stored?

A: By default, the workflow stores all vector embeddings in Supabase using the provided database schema. However, the modular design allows you to easily integrate with other vector databases (like Pinecone, Weaviate, or Milvus) by modifying the database connection nodes.

Q: How does the OCR functionality work?

A: The workflow leverages Mistral AI's advanced OCR capabilities to extract text from images and scanned PDFs. This enables semantic search across all your visual documents, making previously inaccessible information retrievable.

Q: Do I have to use all the functionality provided in the workflow?

A: No, you don't have to use everything! The workflow is designed to be fully modular, allowing you to customize it to your specific needs. You can easily:

• Remove components you don't need (e.g., disable OCR processing by removing the Mistral AI nodes)
• Replace components with alternatives (e.g., swap OpenAI with another embedding provider)
• Add new components to extend functionality
• Configure existing components through the intuitive n8n interface

📞 Support

Need assistance? Connect with me on Twitter/X[@victor_explore](https://x.com/victor_explore) and send a DM for:

• Personalized setup assistance with this workflow
• Custom workflow development for your specific needs

Transform your documents into intelligent knowledge with DriveToRAG today!