RAG workflow for company documents stored in Google Drive
Workflow Description
An intelligent retrieval system that pulls documents from Google Drive, segments them into searchable chunks, generates embeddings using Gemini, stores vectors in a database, and answers employee questions about company policies and organizational information instantly.
How it works
- 1.Automatically retrieve documents from designated Google Drive folders
- 2.Split long documents into semantically logical, searchable segments
- 3.Generate embeddings for text chunks using Gemini models
- 4.Store vector representations in Pinecone for rapid retrieval
- 5.Answer employee inquiries using information from stored documents
- 6.Maintain conversation context for consistent, accurate interactions
Use cases
- HR self-service system answering questions about policies, leave, and benefits
- Internal search engine finding customer information, contracts, and project details
- Employee onboarding knowledge base providing procedures and company guidelines
- Customer support tool delivering reliable answers from product documentation
Requirements
- Active Google Gemini account with valid API credentials
- Google Drive access and folder URLs for document indexing
- Pinecone account with API key and environment configuration
- n8n nodes installed for text processing and vector operations
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