Extract Google Drive Documents and Answer Questions Intelligently
Workflow Description
Automation that loads documents from Google Drive, splits them into chunks, stores them in a vector database, and answers user questions using OpenAI models with high accuracy. Perfect for organizations needing intelligent document retrieval and question-answering.
How it works
- 1.Trigger automation when receiving a query through the interface or webhook
- 2.Load documents from specified Google Drive folders automatically
- 3.Split document content into small, processable text chunks
- 4.Convert chunks to vectors and store them in Qdrant database
- 5.Search vectors to find content most relevant to the question
- 6.Send results with the question to OpenAI model and deliver the answer
Use cases
- Answer employee questions about company policies and instructions stored in Drive
- Analyze project reports and extract required information without manual reading
- Provide customer self-service support through intelligent knowledge base search
- Automate large document review and answer specific inquiries
Requirements
- Google Drive account containing documents to analyze
- OpenAI API keys for accessing language models and embeddings
- Qdrant configuration for efficient vector storage and retrieval
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 (17)
Sticky Note1
Sticky Note
When clicking "Execute Workflow"
Manual Trigger
Google Drive
Google Drive
Sticky Note
Sticky Note
Sticky Note2
Sticky Note
Default Data Loader
Document Default Data Loader
Recursive Character Text Splitter1
Text Splitter Recursive Character Text Splitter
Qdrant Vector Store
Vector Store Qdrant
When chat message received
Chat Trigger
Webhook
Webhook
Retrieval QA Chain
Chain Retrieval Qa
Vector Store Retriever
Retriever Vector Store
Qdrant Vector Store1
Vector Store Qdrant
OpenAI Chat Model
OpenAI
Embeddings OpenAI1
OpenAI
Embeddings OpenAI
OpenAI
Respond to Webhook
Webhook