Automated Document Processing & AI Search Workflow

This comprehensive n8n workflow automates the entire process of managing and interacting with documents stored in Google Drive. It begins by monitoring a specified Google Drive folder for new files such as PDFs, CSVs, or Google Docs, automatically downloading and extracting their text content. The workflow employs AI models like Google Gemini to generate metadata titles and descriptions, and splits the documents into manageable chunks using intelligent algorithms. These chunks are then embedded into vector representations via OpenAI’s API and stored in a Supabase vector database for semantic search. The stored data enables advanced AI-powered chat interactions, where users can ask questions about their documents, and the system intelligently retrieves relevant information from the database to provide accurate and source-cited responses. This workflow is highly useful for organizations looking to create searchable document repositories and interactive AI assistants for internal knowledge management.