Automate Google Drive document processing with AI
Loading workflow…
Workflow Description
Advanced automation that monitors Google Drive, extracts file content automatically, and processes it through an AI model (Gemini) for analysis and Vector Store indexing. Users can then query the processed data through a conversational chat interface powered by language models.
How it works
- 1.Monitor Google Drive folder and detect new file uploads
- 2.Extract text content from uploaded documents
- 3.Split text and generate embeddings using Gemini AI
- 4.Store processed data and embeddings in Vector Store (Pinecone)
- 5.Receive user queries through chat interface
- 6.Return intelligent answers based on indexed document content
Use cases
- Automatically process large document collections for fast semantic search
- Build a knowledge base chatbot answering employee questions about company policies
- Extract and index data from reports and contracts uploaded in real-time
Requirements
- Active Google Drive account with folder access permissions
- Gemini API key and Pinecone account for embeddings storage
- OpenRouter account for accessing advanced language models
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 (14)
AI Agent
Agent
Monitor Google Drive for New Files
Google Drive Trigger
Download File from Google Drive
Google Drive
Extract PDF Content
Extract From File
Insert Document into Pinecone Vector Store
Vector Store Pinecone
Generate Document Embeddings (Google Gemini)
Gemini Model
Clean and Normalize PDF Text
Code
Load Document Data for Processing
Document Default Data Loader
Split Document Text into Chunks
Text Splitter Recursive Character Text Splitter
Chat Message Trigger
Chat Trigger
Retrieve Relevant Documents from Pinecone
Vector Store Pinecone
Generate Query Embeddings (Google Gemini)
Gemini Model
Generate Chat Prompt with Context
Code
OpenRouter Chat Model Interface
Lm Chat Open Router
Fresh workflows, straight to your inbox
Get newly published DROPIDEA workflows, a clear overview of what they do, and a link to explore them.
- New workflows
- Clear overviews
- Setup guides