Telegram bot for accounting and automatic salary calculation
Developed a Telegram bot for automating the accounting of employee work in the sewing workshop. The solution allows masters to quickly enter data about completed work through a convenient menu without manual calculations and spreadsheets.
- Masters select the product model and operation and enter the number of completed units
- The bot automatically calculates payment based on rates stored in Google Sheets
- All data is instantly recorded in a table: Full Name, date, quantity, amount
- The administrator receives centralized accounting without manual control
- Stable synchronization with Google Sheets API has been implemented
As a result, the client received a simple tool for production accounting, minimizing errors and saving time on calculations.
Technologies:
- Python,
- aiogram,
- Telegram Bot API,
- Google Sheets API,
- asyncio
- Masters select the product model and operation and enter the number of completed units
- The bot automatically calculates payment based on rates stored in Google Sheets
- All data is instantly recorded in a table: Full Name, date, quantity, amount
- The administrator receives centralized accounting without manual control
- Stable synchronization with Google Sheets API has been implemented
As a result, the client received a simple tool for production accounting, minimizing errors and saving time on calculations.
Technologies:
- Python,
- aiogram,
- Telegram Bot API,
- Google Sheets API,
- asyncio