Extract and analyze Google Drive documents with AI
Workflow Description
Automation receives chat queries, loads documents from Google Drive, splits text into chunks, converts them to OpenAI embeddings, stores vectors in Pinecone for intelligent search, then extracts and delivers relevant information to users.
How it works
- 1.Receive user question via chat interface
- 2.Load documents from specified Google Drive folders
- 3.Split text into processable chunks
- 4.Generate OpenAI embeddings and store in Pinecone
- 5.Search for chunks most relevant to the query
- 6.Extract answer and send to user
Use cases
- Answer questions about content stored in Google Drive files
- Perform intelligent search across thousands of documents
- Index and summarize large file archives efficiently
Requirements
- Google account with Google Drive access permissions
- OpenAI API key for embedding generation
- Pinecone account for vector storage and retrieval
- Documents in processable formats (PDF, DOCX, TXT)
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 (20)
When clicking "Execute Workflow"
Manual Trigger
Sticky Note
Sticky Note
Sticky Note2
Sticky Note
Sticky Note1
Sticky Note
Sticky Note4
Sticky Note
Pinecone Vector Store
Vector Store Pinecone
When chat message received
Chat Trigger
OpenAI Chat Model1
OpenAI
Set file URL in Google Drive
Set
Download file
Google Drive
Default Data Loader
Document Default Data Loader
Embeddings OpenAI2
OpenAI
Embeddings OpenAI
OpenAI
Recursive Character Text Splitter
Text Splitter Recursive Character Text Splitter
Set max chunks to send to model
Set
Get top chunks matching query
Vector Store Pinecone
Prepare chunks
Code
Answer the query based on chunks
Information Extractor
Compose citations
Set
Generate response
Set