Automate Google Drive
Workflow Description
An intelligent automation template that monitors Google Drive files, extracts content using AI embeddings, stores data in a vector database, and enables chatbot-style queries against your documents through OpenAI-powered retrieval chains.
How it works
- 1.Monitor Google Drive for new or modified documents via active trigger
- 2.Load and recursively split document content into manageable text chunks
- 3.Generate vector embeddings for text segments using OpenAI's embedding model
- 4.Store embeddings in Pinecone vector database for semantic search
- 5.Answer user queries using retrieval-augmented generation chain with LLM
Use cases
- Automatically analyze contracts and legal documents to extract specific clauses or obligations
- Enable employees to ask questions about company policies stored in Drive
Requirements
- Active Google Drive account with API access and proper authentication
- Valid API keys for OpenAI and Pinecone vector database service
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 (16)
Google Drive
Google Drive
Recursive Character Text Splitter
Text Splitter Recursive Character Text Splitter
Embeddings OpenAI
OpenAI
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Default Data Loader
Document Default Data Loader
Sticky Note2
Sticky Note
Question and Answer Chain
Chain Retrieval Qa
OpenAI Chat Model
OpenAI
Embeddings OpenAI2
OpenAI
Vector Store Retriever
Retriever Vector Store
Read Pinecone Vector Store
Vector Store Pinecone
Insert into Pinecone vector store
Vector Store Pinecone
When clicking 'Chat' button below
Chat Trigger
When clicking 'Test Workflow' button
Manual Trigger
Set Google Drive file URL
Set