Automate Google Drive
Workflow Description
A template that integrates an AI agent with Google Drive for automated document processing. Extracts text content, segments it, stores it in a vector database, and answers user queries through an intelligent chat interface powered by advanced language models.
How it works
- 1.Monitor Google Drive folders and trigger the workflow when new files are uploaded
- 2.Extract document content and split it into manageable text chunks for processing
- 3.Generate embedding vectors for text segments and store them in Pinecone vector database
- 4.Process user queries through the chat interface using Gemini language model
- 5.Search the vector store and retrieve relevant content to provide accurate responses
Use cases
- Intelligent search engine for Google Drive documents that instantly answers user questions
- Automated processing of reports and contracts to extract and classify key information
- Virtual assistant supporting your team in answering document-related queries
Requirements
- Google account with access permissions to Google Drive
- Pinecone API key for vector storage
- Gemini and Open Router credentials for language models
- Text documents in supported formats (PDF, Word, plain text)
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