Extract Google Drive Documents and Intelligently Slice into Pinecone
Workflow Description
Advanced automation that retrieves documents from Google Drive, intelligently chunks them using Gemini embeddings, and stores semantic vectors in Pinecone for context-aware retrieval and precise question-answering capabilities.
How it works
- 1.Automatically fetch documents from Google Drive folders
- 2.Intelligently partition content using recursive text splitting
- 3.Generate semantic embeddings via Gemini model
- 4.Store processed chunks with embeddings in Pinecone
- 5.Execute contextual search and retrieve relevant information instantly
Use cases
- Build a question-answering system from your company's document repository
- Extract relevant information from stored reports and contracts efficiently
Requirements
- Active Google Drive account with documents ready for processing
- Pinecone API key and credentials with an operational vector database
- Access credentials to Gemini model via OpenRouter or Google Cloud API
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)
When clicking ‘Test workflow’
Manual Trigger
Loop Over Items
Split In Batches
OpenRouter Chat Model
Lm Chat Open Router
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
Get Document From Google Drive
Google Drive
Extract Text Data From Google Document
Extract From File
Split Document Text Into Sections
Code
Prepare Sections For Looping
Split Out
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
AI Agent - Prepare Context
Agent
Concatenate the context and section text
Set
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note