Telegram bot CRM for car service stations and auto services
Developed a comprehensive ecosystem based on Telegram for automating the work of car service stations and auto repair shops. The bot fully covers the life cycle of vehicle maintenance: from the first customer request about a breakdown to the final notification "Repair completed."
The project transforms a regular Telegram into a powerful CRM system with role distribution (Client, Mechanic, Administrator).
Main features and implemented functionality:
For clients:
"Personal garage": Intuitive 11-step car registration. When a client contacts again, they simply select the saved car using In-Line buttons, skipping the data entry stage.
Media files: Ability to add photos and videos of damages, which are instantly sent to the mechanics.
Status tracking: The client sees the history of their orders and receives automatic notifications about status changes (Pending, In progress, Completed).
For mechanics:
Workspace automation: For each new order, the bot automatically creates a separate topic (Forum Topic) with the car number (e.g., #12 [AB1234CD] Toyota Camry).
Interactive cards: A detailed order card with media files and control buttons (Take to work, Complete repair) is sent to the topic. Upon completion of the repair, the topic is automatically closed to avoid cluttering the work chat.
Admin panel and Analytics:
Full CRUD in Telegram: Management of the user database, editing car data, ability to forcibly change order statuses or ban users directly from the chat.
Live statistics: Dashboard with key metrics (total number of clients, cars, most popular car brand at the service station, workload by months).
Data export (Google Sheets API): Built-in generation of CSV reports and integration with Google Sheets via OAuth 2.0. One-click export creates/updates a table on the administrator's Google Drive and sends a direct link in the chat.
Technical stack:
Language: Python 3.12+
Framework: aiogram 3.x
Databases: PostgreSQL + SQLAlchemy 2.0 (fully asynchronous interaction)
Integrations: Google Sheets API, Google Drive API
Deployment: Docker & Docker Compose
#python #telegrambot #aiogram #crm #postgresql #docker #autorepair #automation #googlesheets #backend
The project transforms a regular Telegram into a powerful CRM system with role distribution (Client, Mechanic, Administrator).
Main features and implemented functionality:
For clients:
"Personal garage": Intuitive 11-step car registration. When a client contacts again, they simply select the saved car using In-Line buttons, skipping the data entry stage.
Media files: Ability to add photos and videos of damages, which are instantly sent to the mechanics.
Status tracking: The client sees the history of their orders and receives automatic notifications about status changes (Pending, In progress, Completed).
For mechanics:
Workspace automation: For each new order, the bot automatically creates a separate topic (Forum Topic) with the car number (e.g., #12 [AB1234CD] Toyota Camry).
Interactive cards: A detailed order card with media files and control buttons (Take to work, Complete repair) is sent to the topic. Upon completion of the repair, the topic is automatically closed to avoid cluttering the work chat.
Admin panel and Analytics:
Full CRUD in Telegram: Management of the user database, editing car data, ability to forcibly change order statuses or ban users directly from the chat.
Live statistics: Dashboard with key metrics (total number of clients, cars, most popular car brand at the service station, workload by months).
Data export (Google Sheets API): Built-in generation of CSV reports and integration with Google Sheets via OAuth 2.0. One-click export creates/updates a table on the administrator's Google Drive and sends a direct link in the chat.
Technical stack:
Language: Python 3.12+
Framework: aiogram 3.x
Databases: PostgreSQL + SQLAlchemy 2.0 (fully asynchronous interaction)
Integrations: Google Sheets API, Google Drive API
Deployment: Docker & Docker Compose
#python #telegrambot #aiogram #crm #postgresql #docker #autorepair #automation #googlesheets #backend
Kyiv 
Available for hire