Problem
Managers manually transferred data into spreadsheets every day, spending up to several hours on this routine task.
Automation for Daily Analytics
The system automatically collects metrics across multiple profiles, updates spreadsheets, and sends summaries.
Solution
I developed a system for automatic analytics collection and publishing, with the option to manually check profiles through Telegram.
Result
The daily routine was almost completely removed, and the data started updating automatically.
01Automatic data collection
02Google Sheets updates
03Telegram summaries
04Manual profile checks
Gallery
If your team regularly moves data manually, I can help automate this process.
Technologies
PythonFastAPIaiogramGoogle Sheets API