# Chat with documents from Google Drive: ask questions about PDF/CSV using RAG
This workflow automatically processes PDF and CSV files from Google Drive, extracts text, generates embeddings, and enables users to get accurate answers to queries via chat using a RAG system powered by n8n, LangChain, and AI agents. Ideal for teams needing instant access to document data without manual search.
## Who it´s for
- Companies needing internal document access via AI assistant
- Analysts working with PDF/CSV data requiring fast contextual search
- Developers implementing RAG systems without coding
- Product managers analyzing reports and documentation through a chat interface
## What the automation does
- Monitors a Google Drive folder for new PDF or CSV uploads
- Downloads files and extracts text content
- Splits text into chunks and enriches context using Google Gemini
- Generates vector embeddings via OpenAI and stores them in Supabase
- Allows users to ask questions in chat and receive precise answers based on real documents using GPT-4o-mini and RAG
## What´s included
- Ready-to-use n8n workflow with LangChain RAG pipeline
- Trigger logic: file creation in Google Drive and incoming chat messages
- Integrations with Google Drive, Supabase, OpenAI API, Google Gemini API
- Basic setup and adaptation guide
## Requirements for setup
- n8n instance with external API access
- Google Drive account with read/write permissions to target folder
- Supabase project with table for embedding storage
- Active API keys for OpenAI and Google Gemini
## Benefits and outcomes
- Reduces document search time to seconds
- Minimizes manual data processing and analysis effort
- Eliminates AI hallucinations by grounding responses in actual documents
- Enables scalable knowledge base expansion — just upload new files
- No reconfiguration needed when adding new documents
## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat
No feedback yet