Automate Google Drive
Workflow Description
An automation workflow that connects Google Drive with an intelligent agent to process documents automatically. Loads files, splits them into manageable text segments, generates semantic embeddings via OpenAI, and stores them in Pinecone for smart retrieval.
How it works
- 1.Trigger the workflow manually or via chat interface
- 2.Load documents from Google Drive using the data loader
- 3.Split text content into processable chunks with TextSplitter
- 4.Generate OpenAI embeddings and store in Pinecone vector store
- 5.Activate the AI agent to answer questions about stored documents
Use cases
- Build a searchable knowledge repository from Google Drive files using semantic search
- Automatically answer employee questions based on stored document content
Requirements
- Active Google Drive account with access permissions
- API keys for OpenAI and Pinecone services
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