Sales analytics automation (n8n + Google Sheets + Telegram)
Enterprise Resource Planning (ERP)
Automated workflow for collecting and analyzing sales data using n8n.
The system retrieves data from Google Sheets, filters records by the selected month and year, calculates key business metrics, and sends a structured report to Telegram.
Functionality:
* Integration with Google Sheets (data retrieval)
* Flexible report period settings (month/year)
* Data filtering and validation
* Metric calculations:
* Number of orders
* Total revenue
* Average order value (AOV)
* Conditional logic:
* sending a report when there are sales
* notification if there are no sales
* Automatic report sending to Telegram
Technologies:
n8n · Google Sheets API · JavaScript · Telegram Bot API
Result:
A fully automated sales analytics process that replaces manual data processing and ensures quick report generation.
Can be adapted for CRM, e-commerce, or financial reports.
The system retrieves data from Google Sheets, filters records by the selected month and year, calculates key business metrics, and sends a structured report to Telegram.
Functionality:
* Integration with Google Sheets (data retrieval)
* Flexible report period settings (month/year)
* Data filtering and validation
* Metric calculations:
* Number of orders
* Total revenue
* Average order value (AOV)
* Conditional logic:
* sending a report when there are sales
* notification if there are no sales
* Automatic report sending to Telegram
Technologies:
n8n · Google Sheets API · JavaScript · Telegram Bot API
Result:
A fully automated sales analytics process that replaces manual data processing and ensures quick report generation.
Can be adapted for CRM, e-commerce, or financial reports.