Retrieve and analyze company documents from Google Drive using RAG
Workflow Description
Intelligent workflow that retrieves documents stored in Google Drive, splits them into text segments, converts them to embeddings using Gemini, and stores them in Pinecone vector store to enable smart responses to employee and customer inquiries.
How it works
- 1.Receive query through chat interface or manual trigger
- 2.Fetch relevant documents from Google Drive and split into text chunks
- 3.Convert chunks to semantic embeddings via Gemini and store in Pinecone
- 4.Search vector store for documents closest to the user's query
- 5.Generate response backed by original documents through AI agent
Use cases
- Automatically answer employee questions about company policies and procedures
- Provide accurate information from lengthy documents without manual search
Requirements
- Google Drive account containing company documents in text-compatible formats
- API keys for accessing Gemini and Pinecone 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 (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