Extract Drive files, intelligently slice and store in Pinecone
Workflow Description
Automation that retrieves documents from Google Drive, splits them into context-aware chunks using Gemini, converts them to vector embeddings, and stores them in Pinecone to enable semantic search and precise question-answering capabilities.
How it works
- 1.Trigger the workflow manually and extract files from Google Drive
- 2.Process documents and intelligently split them while preserving context using Gemini
- 3.Convert chunks into embeddings and store them in Pinecone vector database for immediate retrieval
Use cases
- Build a searchable knowledge repository from multiple company files
- Deploy an advanced RAG system to answer employee queries from internal documents
- Archive and organize large digital content with efficient semantic indexing
Requirements
- Active Google Drive account containing documents to process
- Pinecone API key and active vector database instance
- Google Gemini API access credentials for embeddings and processing
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