AI-powered chatbot RAG for your Google Drive documents...
Workflow Description
An intelligent agent that indexes Google Drive documents into a searchable knowledge base and answers user questions via Telegram or X using retrieval-augmented generation with Gemini or OpenAI models.
How it works
- 1.Load documents from Google Drive and split them into processable chunks
- 2.Store text segments in a vector database (Qdrant) for semantic search
- 3.Receive questions through Telegram or X and provide answers using LLM models
- 4.Maintain conversation context with built-in memory system
Use cases
- Build a smart assistant for answering questions about internal company documentation
- Deploy automated customer support based on an updated knowledge base
- Analyze large contracts or reports and respond to inquiries instantly
Requirements
- Google Drive account containing documents to be analyzed
- Telegram and/or X account for user interaction
- API keys for OpenAI and/or Google Gemini services
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (50)
Data Loader
Document Default Data Loader
Token Splitter
Text Splitter Token Splitter
Qdrant Vector Store
Vector Store Qdrant
Loop Over Items
Split In Batches
Wait
Wait
When clicking ‘Test workflow’
Manual Trigger
Google Gemini Chat Model
Gemini Model
Merge
Merge
Extract Meta Data
Information Extractor
Get File Contents
Extract From File
Download File From Google Drive
Google Drive
Find File Ids in Google Drive Folder
Google Drive
text-embeddings-3-large
OpenAI
Google Folder ID
Set
gpt-4o-mini1
OpenAI
Delete Qdrant Points by File ID
Code
Qdrant Collection Name
Set
File Id List
Summarize
Merge1
Merge
Merge2
Merge
Sticky Note
Sticky Note
Confirm Qdrant Delete Points
Set
If
If
Sticky Note1
Sticky Note
Send Declined Message
Set
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note
Sticky Note4
Sticky Note
Sticky Note5
Sticky Note
Sticky Note6
Sticky Note
Sticky Note7
Sticky Note
Sticky Note8
Sticky Note
Webhook
Webhook
AI Agent
Agent
Window Buffer Memory
Memory Buffer Window
When chat message received
Chat Trigger
Google Gemini Chat Model1
Gemini Model
text-embeddings-3-large1
OpenAI
Sticky Note9
Sticky Note
Sticky Note10
Sticky Note
Sticky Note11
Sticky Note
Sticky Note12
Sticky Note
Google Drive
Google Drive
Respond to User
Set
Sticky Note13
Sticky Note
Update Chat History
Google Docs
Qdrant Vector Store Tool
Vector Store Qdrant
OpenAI Chat Model
OpenAI
Send Completed Message
Set
Sticky Note14
Sticky Note