Automate Intelligent Search Across Google Drive Documents
Workflow Description
Intelligent automation that processes Google Drive files using an AI agent. The system splits documents into searchable chunks, generates OpenAI embeddings, and stores them in a vector database. Users can query their file contents through an interactive chat interface powered by advanced AI reasoning.
How it works
- 1.Trigger automation via chat interface or manual activation
- 2.Retrieve files from Google Drive and extract their content
- 3.Split documents into logical, searchable chunks using recursive text splitting
- 4.Generate vector embeddings for all chunks via OpenAI API
- 5.Store embeddings in Pinecone vector database for efficient retrieval
- 6.Answer user queries using AI agent with access to stored documents
Use cases
- Search and find information across thousands of stored files without manual review
- Summarize and analyze large documents by asking natural language questions
- Build an intelligent assistant that understands your company's entire document repository
Requirements
- Connected Google Drive account integrated with n8n
- Valid OpenAI API key with embeddings and chat model access
- Active Pinecone account for vector storage and retrieval
- Read permissions for target Google Drive files
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 (15)
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note
When clicking 'Test Workflow' button
Manual Trigger
Pinecone Vector Store
Vector Store Pinecone
When chat message received
Chat Trigger
Question & Answer
Agent
Set Google Drive file URL
Set
Google Drive
Google Drive
Default Data Loader
Document Default Data Loader
Recursive Character Text Splitter
Text Splitter Recursive Character Text Splitter
Embeddings OpenAI1
OpenAI
Embeddings OpenAI
OpenAI
Pinecone Vector Store1
Vector Store Pinecone
OpenAI Chat Model
OpenAI