AI Agents
Workflow analyzer and vector storage system n8n
13 nodes
223
132
Scheduled trigger
Workflow Description
An intelligent workflow analysis system that runs on schedule, extracting n8n workflow data from Google Drive, generating embeddings via OpenAI, storing them in Pinecone for smart retrieval, logging results in Postgres, and sending status updates through Telegram notifications.
How it works
- 1.Execute scheduled trigger to initiate workflow analysis cycle
- 2.Retrieve and extract workflow files from Google Drive with validation
- 3.Process and prepare data structure for embedding generation
- 4.Create semantic embeddings using OpenAI's embedding models
- 5.Store vectors and metadata in Pinecone vector database
- 6.Log transactions and results in Postgres, notify via Telegram
Use cases
- Automatic analysis and archiving of workflow patterns and documentation
- Semantic search across historical workflows and processes
- Real-time monitoring and alerting of workflow processing status
Requirements
- Google Drive API credentials with file access permissions
- OpenAI and Pinecone API keys configured
- PostgreSQL database instance for persistent logging
- Telegram bot token and chat ID for notifications
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Google Drive
Vector Store
Postgres
Telegram
OpenAI
Details
Trigger
Scheduled trigger
Nodes
13
Apps
5
Views
223
Downloads
132
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 (13)
/
Is New or Updated?
If
Download Workflow File
Google Drive
Analyze Workflow Structure
Code
Prepare Vector Data
Code
Store in Pinecone
Vector Store Pinecone
Update Processing Record
Postgres
Send Success Notification
Set
Edit Fields
Set
Embeddings OpenAI
OpenAI
Merge
Merge
Search files and folders
Google Drive
Schedule Trigger
Schedule Trigger
Execute a SQL query
Postgres