RAG bot on n8n: answers questions from Google Drive doc

This automation enables instant, context-aware responses to user queries based on up-to-date documents stored in Google Drive, using a RAG architecture powered by OpenAI, LangChain, and the PGVector vector store. The system updates its knowledge base when files change and maintains chat history for coherent conversations.

## Who it´s for
- Companies using Google Drive for documentation who need automated Q&A.
- Support teams requiring fast access to internal knowledge.
- Developers implementing RAG systems without coding.
- IT departments automating file change processing.
- Training platforms integrating AI assistants with documentation.

## What the automation does
- Triggers on file creation or update in Google Drive.
- Extracts text and splits it into chunks using Recursive Text Splitter.
- Stores embeddings in PGVector (PostgreSQL) for semantic search.
- On receiving a query, retrieves relevant chunks and generates a response via OpenAI with chat memory.
- Deletes outdated entries when documents are updated to ensure data consistency.
- Supports triggering via chat interface or external execute trigger.

## What´s included
- Ready-to-use n8n workflow.
- Trigger logic: google_drive_file_created, google_drive_file_updated, execute_workflow_trigger.
- Integrations with Google Drive, PostgreSQL/PGVector, OpenAI API.
- Basic setup and adaptation guide.

## Requirements for setup
- n8n instance with PostgreSQL access.
- Google Drive API access (service account or OAuth).
- OpenAI API key.
- PostgreSQL database with PGVector extension enabled.

## Benefits and outcomes
- Instant access to knowledge without manual search.
- Up-to-date answers due to real-time document sync.
- Personalized interactions via chat memory.
- Reduced workload for support and internal teams.
- Flexible integration into chats, CRMs, or external apps.
- No-code solution using n8n and LangChain nodes.

## 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 Telegram: @gleb923.