Sales analytics automation (n8n + Google Sheets + Telegram)

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.