An automated order analytics workflow built with n8n, Google Sheets, JavaScript, and Telegram.
This project demonstrates how business order data can be processed automatically to generate employee reports, monitor active orders, and send real-time notifications.
- 📊 Processing order analytics
- 👤 Employee-specific reporting
- 💰 Revenue & average order calculation
- 🛍 Product statistics
- 📨 Telegram notifications
- 📈 Report history logging
- 📋 Processing queue synchronization
- ⏰ Scheduled execution
- 🔄 Manual execution for testing
- n8n
- JavaScript
- Google Sheets
- Telegram Bot API
The workflow:
- Reads orders from Google Sheets
- Filters active processing orders
- Calculates business metrics
- Sends a Telegram report
- Saves report history
- Updates the processing queue
The workflow calculates:
- Processing Orders
- Processing Revenue
- Average Order Value
- Total Items
- Top Employee
- Top Product
workflow/
orderpulse-workflow.json
screenshots/
README.md
- Import the workflow into n8n.
- Connect your Google Sheets credentials.
- Connect your Telegram Bot.
- Replace placeholder values with your own IDs.
- Execute the workflow.
This public version has been sanitized before publishing.
All credentials, IDs and sensitive information have been removed.
MIT
