AI-powered chatbot RAG for your Google Drive documents...
Workflow Description
Build an intelligent agent that extracts files from Google Drive, transforms them into a searchable knowledge base, and answers user queries via Telegram or X based on document content using retrieval-augmented generation.
How it works
- 1.Load documents from Google Drive and split them into processable text chunks
- 2.Convert text segments into vectors stored in Qdrant for semantic search capability
- 3.Receive user queries through Telegram or X and route them to an AI agent powered by Gemini or OpenAI
- 4.Search the knowledge base and retrieve the most relevant document segments
- 5.Generate intelligent responses with contextual memory and deliver them back to the user
Use cases
- Create an intelligent assistant that answers employee questions based on company policies and stored documents
- Convert a file repository into a knowledge engine delivering accurate answers in real time
- Build an AI-powered customer support system grounded in your organization's knowledge base
Requirements
- Active Google Drive account with organized documents ready for processing
- API keys from Gemini, OpenAI, and Telegram or X for complete integration
- Running Qdrant vector database instance or configured cloud deployment
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