The second stage of the development of the Telegram bot
Globally: 1) Add configuration files. 2) Switch to aiogram. Driver bot: 1) Buttons "End work day" and "Start work day". If the work day has not started, points do not come to the driver. 2) After a point arrives, the driver clicks "Accept" and the manager, dispatcher, and client receive a notification that the driver has departed. 3) Create a separate bot for clients, authorization by phone number. 4) Button "Temporarily not completed": - For TVP it will move the route from 1 to 3 place; - For VGV it will give the route the status "Not completed" and it will become available for assignment to another driver; - For VGV at the landfill it is not needed; 5) Button "Breakdown", which frees all routes attached to this driver and sends a notification to the manager and dispatcher. Free routes will be in the dispatcher bot under the button "Free routes". 6) After the driver arrives at the point, he must provide data on the cubic capacity/number of containers taken (photo/video/text). The data acceptance function will work only until the driver clicks "Completed", "Not completed", "Temporarily not completed" or "Breakdown". The data is added to the "Information" field in the table and is linked to the route for which the data was provided. 7) If the driver clicked "Not completed", then the driver must send text/photo/video explaining why it was not completed. The data is added to the "Reason" field in the table and is linked to the route for which the data was provided. 8) When adding a route, ask for the address/coordinates (make it so that 2 options are available) and generate a link to Google Maps. 9) Create separate systems for TVP and VGP using the following technology: - The dispatcher selects the type - TVP or VGV when adding a route; - If the type is TVP, the routes go one after another until they reach the type VGV; - If the type is VGV, the bot will immediately ask the dispatcher to specify the route to the landfill. After each completed/not completed on VGV, the bot will drop a point at the landfill; - The landfill will be considered a separate point of the route, so it will support "Completed", "Not completed" and "Breakdown". 9.1) Create a separate table "Auto", which will contain complete information about the car. 9.2) When creating a route, the dispatcher selects a car for this route. 9.3) When sending a report on the number of containers taken, it is necessary to indicate how many out of how many have already been loaded. 10) On the VGV route, there are 3 stages - "Departed", "Arrived" and "Completed"/"Not completed"/"Breakdown". If more than 20 minutes pass between "Arrived" and "Completed", the dispatcher and manager receive a notification that the vehicle is idle. 11) On each type of route and at each stage of the route, add a button "Pause", which will change the driver's status and not send notifications for idling. But it will work for a maximum of 1 hour pause. 12) If on the way to the landfill the driver clicked "Not completed", then: - The driver clicks "Not completed" on the route to the landfill; - Information about this comes to the dispatcher; - The bot asks to enter a new landfill address; - Sends the new address to the driver. 13) Make the map transition button a button. Dispatcher bot: 1) Add a button to view free routes and make it possible to link them to the driver. 2) Add a button that will open a menu with active points and allow the dispatcher to edit the point. 3) Add a button that will open a menu with clients and their data. Manager bot: 1) Create a Google spreadsheet where the manager will enter client data. 2) Client storage system: - Every 3 minutes the bot will parse values from the table and save them to the database (using Google Sheets entirely as a database is an unreliable option) - The dispatcher will have the ability to view the list of all clients (and their data) by button; - When adding a route, the dispatcher will specify the client ID or something else (to be discussed); 3) Priority system (1 - urgent 2 - priority 3 - by route 4 - not urgent): - These numbers will be added by the manager to the Google spreadsheet in a separate column; - The bot will not process these numbers automatically, but will only save them and show them to the dispatcher; - The priority system for the dispatcher will not be touched, it will remain as it is; 4) Ability to generate reports for a certain period of time. 5) In reports, add all new data (why not completed, information about containers, etc.). 6) Ability to view the distribution of routes by clients.
-
4216 53 1 1 Hello Gennady, I specialize in developing Telegram bots (I have 3 years of experience and over 100 projects) I write in Python, Aiogram 3 I will help with server deployment and provide long-term technical support
-
296 Good day!
This is a large and technically complex project.
Approximately:
— MVP term: 2–4 weeks (depends on access to the code and the complexity of integrations).
— Estimated cost of the full project: 20,000–45,000 UAH (exact estimate after technical discussion).
I am ready to discuss the technical specifications in detail and prepare a step-by-step work plan with exact timelines and estimates. Please provide access/inform about priorities — we will prepare a technical plan and budget.
-
61 Hello! 👋
I have extensive experience in developing complex Telegram bots using aiogram with integration of Google Sheets, databases, and dynamic logic management.
I am ready to implement everything according to your technical specifications — from transitioning to aiogram and configuring settings to a complete system of three bots (driver, dispatcher, manager) with integration of tables, routes, statuses, timers, and notifications.
I will do it cleanly, structured, and with convenient management through a menu.
I am ready to discuss the details and start working.
-
2930 8 0 1 Hello! 👋
I can fully implement the described system on aiogram with the logic divided among three bots — driver, dispatcher, manager, as well as with configuration files for convenient scaling.
I will foresee:
a complete route cycle with all statuses (“Completed”, “Not completed”, “Breakdown”, “Pause”);
automatic data synchronization between bots;
…
integration with Google Sheets + database (PostgreSQL or SQLite);
a system of priorities, reports, and notifications about downtimes;
support for TVP and VGV with polygon logic;
dynamic status updates and storage of data about containers, photos, videos, etc.
I will develop everything turnkey, with testing and documentation.
-
9944 117 0 Hello!
I develop bots for Telegram using NodeJS. I am ready to take on the task. Write to me, we will discuss.
-
957 5 0 1 Good day.
Very large and interesting project.
I am ready to take on the execution of this project,
as I have extensive experience in executing large projects.
As a result, I promise structured, stable working code.
Please send a private message to discuss all the details.
I will be happy to collaborate!
-
172 1 1 Hello! I am ready to complete this project with extensive experience in developing various applications.
-
656 9 0 Good morning, Gennady!
In general, the task is clear, but for an accurate response regarding the deadlines and price, I would like to clarify some questions that arose after analyzing your task.
Please write in private messages – we will discuss the details and your wishes.
Current freelance projects in the category Bot Development
Software maintenance
111 USD
It is necessary to make adjustments to the software and maintain it in the future; the software places orders based on specified parameters and sends them to a Telegram bot. Python, Bot Development ∙ 3 hours 3 minutes back ∙ 46 proposals |
Telegram bot
269 USD
It is necessary to completely replicate the interface and functionality, but without the payment platform. It needs to be done in a short time. Bot Development ∙ 1 day back ∙ 101 proposals |
Automatic video posting on social media according to a scheduleTechnical Assignment (TA) Automatic video publication on social media according to a scheduleProject Description A script/bot (Python preferred, or any other solution of your choice — the main thing is stability and ease of maintenance) is needed, which automatically publishes… Python, Bot Development ∙ 1 day 2 hours back ∙ 54 proposals |
Bot for receiving/searching applications
28 USD
In short: Create a bot where users can create and find profiles, the bot should have referral links, etc. Everything is detailed below. Client-side bot: Before the /start button, text in the center of the chat: What can this bot do? Welcome to Sugar Secret Agency! -Premium… Python, Bot Development ∙ 1 day 4 hours back ∙ 58 proposals |
Signal bot with automation in Google SheetsA bot is needed that will accept an application and automatically place it in Google Sheets, for example: store1, 26.06, 500kg or 200kg, and it will automatically mark 500 or 200 in the cell of the date on the store's line in the table. Bot Development ∙ 1 day 4 hours back ∙ 61 proposals |