Automate Google Drive
Workflow Description
An intelligent automation template integrating OpenAI with Google Drive for automated document processing. Extracts and analyzes text using advanced language models, then stores embeddings in a vector database for fast semantic search and retrieval.
How it works
- 1.Trigger the workflow manually or via chat interface to start document processing
- 2.Extract content from Google Drive files and split text into manageable chunks
- 3.Convert text into numerical embeddings using OpenAI models
- 4.Store vector data in Pinecone for semantic search capability
- 5.Process user queries through LLM chains and return contextually relevant results
Use cases
- Intelligent search across large company document repositories using natural language
- Build an automated Q&A system based on Google Drive content
- Continuously classify and index administrative documents with semantic understanding
Requirements
- Valid API keys for OpenAI, Google Drive, and Pinecone services
- Sufficient permissions to access and read folders and files in Google Drive
- Stable and secure connection to processing and storage infrastructure
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 (22)
When clicking "Execute Workflow"
Manual Trigger
Embeddings OpenAI
OpenAI
Sticky Note
Sticky Note
Default Data Loader
Document Default Data Loader
Set file URL in Google Drive
Set
Sticky Note2
Sticky Note
Add in metadata
Code
Download file
Google Drive
Chat Trigger
Chat Trigger
Prepare chunks
Code
Embeddings OpenAI2
OpenAI
OpenAI Chat Model
OpenAI
Set max chunks to send to model
Set
Structured Output Parser
Output Parser Structured
Compose citations
Set
Generate response
Set
Sticky Note1
Sticky Note
Answer the query based on chunks
LLM Chain
Sticky Note4
Sticky Note
Get top chunks matching query
Vector Store Pinecone
Add to Pinecone vector store
Vector Store Pinecone
Recursive Character Text Splitter
Text Splitter Recursive Character Text Splitter