Search and Answer Company Documents from Google Drive
Workflow Description
A workflow that retrieves documents from Google Drive, converts them into searchable vector embeddings, and answers employee questions using Gemini AI while maintaining conversation history for contextual responses.
How it works
- 1.Automatically fetch documents from a specified Google Drive folder
- 2.Split lengthy texts into manageable paragraphs
- 3.Convert text segments into numerical vectors and store them in Pinecone
- 4.Search for relevant information based on user queries
- 5.Generate accurate responses using Gemini with source attribution
- 6.Retain conversation history for continuous context
Use cases
- Enable employees to instantly access policies and procedures from company documentation
- Quickly summarize lengthy documents and locate specific information within them
- Provide customer support with verified information from company knowledge base
Requirements
- Google account with access permissions to Google Drive
- Gemini API key from Google Cloud
- Pinecone account or equivalent vector database service
- Well-formatted source documents stored in the source folder
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 (18)
Pinecone Vector Store
Vector Store Pinecone
Embeddings Google Gemini
Gemini Model
Default Data Loader
Document Default Data Loader
Recursive Character Text Splitter
Text Splitter Recursive Character Text Splitter
AI Agent
Agent
Vector Store Tool
Tool Vector Store
Pinecone Vector Store (Retrieval)
Vector Store Pinecone
Embeddings Google Gemini (retrieval)
Gemini Model
Download File From Google Drive
Google Drive
Sticky Note2
Sticky Note
Google Drive File Updated
Google Drive Trigger
Google Drive File Created
Google Drive Trigger
Window Buffer Memory
Memory Buffer Window
When chat message received
Chat Trigger
Sticky Note
Sticky Note
Google Gemini Chat Model
Gemini Model
Google Gemini Chat Model (retrieval)
Gemini Model
Sticky Note1
Sticky Note