Development of a Telegram bot for processing service requests with integration

Developed a Service Desk system for internal use by a network of stores. The bot replaced chaotic calls and messages in messengers with a structured ticketing system.

Functionality:
- Application submission: Convenient wizard (selection of location, problem category, priority).
- Multimedia: Ability to add photos/videos of the malfunction to the application.
- Role model: Interface for staff (submission) and engineers (processing).
- Statuses: Tracking the lifecycle of the application (New → In Progress → Completed/Rejected).
- Reporting: Team /report for the manager with statistics for the period.

And!!! Integration: Google Sheets API:
All applications are automatically duplicated in Google Sheets in real-time. This allows for tracking expenses, analyzing the most common malfunctions, and monitoring the work of contractors.

Technology stack: Python, Aiogram, Google Drive API, Google Sheets API.
#python #telegrambot #automation #googlesheets #servicedesk #botdev