Task system (ticket/task) based on telegram bot & google sheets
A. Purpose
- the bot is needed to implement a ticketing system (task assignment within the team, among its members)
- Telegram is chosen as the input and output interface for tasks because it is the most native way for employees (there is no need to navigate through Trello tabs, everything happens within the environment where they already assign tasks to each other - in the messenger)
B. What should be
1. How I envision the process of creating and sending a ticket
- a person opens Telegram, opens the bot, and selects the menu item "send ticket / create task"
- a list (buttons) is built from a range of Google Sheets with employees
- a window "task title" pops up - the person enters it - clicks next
- a window "task description" pops up - here, in addition to text, it would be great to attach video/audio/files - the person enters - clicks next (attachments of audio/video/files can be made as a separate question)
- a calendar window pops up, where the person specifies the deadline
2. How I envision the process of receiving a ticket
- if someone sends me a ticket, I receive a notification with complete information about the task (title, description, deadline, from whom it was received)
- I have the option to set 3 statuses: "read", "started", "deferred", "done".
- for the options "deferred" and "done", there should also be a next step to write a comment (ideally, if there is an option to attach voice/files)
- after selecting a status / writing a comment, feedback should be sent with this status / comment to the person who assigned the task
3. How to close a ticket
- I open the bot - click the button "my tasks" - a list of clickable buttons is built (button name = task name) - clicking on the button takes us to the task itself (where there is a description, deadline, from whom it was received, current status (selected in the previous step)) - the same choice "read" / "started" / "deferred" / "done" - I choose "done" - add a comment / voice / file - click send - a notification is sent to the person who assigned the task
4. Google Sheets as backend
- all manipulations are recorded in Google Sheets, where there are columns:
- timestamp (when the ticket was sent)
- who sent it (TG id)
- who it was sent to (TG id)
- task title (for example: create a report for January 2025)
- task description
- deadline (date + time format)
- status (which is updated by the person responsible for completing the ticket)
- comment / voice (if it can be uploaded to Google Drive and the link brought here) / file
5. How it should work.
- Telegram as frontend (input, updating, and output tool for data)
- Google Sheets as backend (repository with tickets, 1 row = 1 ticket)
-
3 days134 USD
3 days134 USD
I have already implemented different parts of the required functionality in other projects. If you're interested, we can discuss the implementation details. It would generally be better to use a full-fledged database instead of Google Sheets, as they tend to crash from time to time, but I think there is a possibility to introduce an error event handler and retries for connecting to the sheets.
I have worked with APIs and know the package that simplifies working with sheets, which is why I will be able to develop quite quickly. I will be writing in NodeJS.
-
10 days178 USD
122 10 days178 USD
Hello!
I am ready to develop a Telegram bot for managing a ticketing system with Google Sheets integration as the backend.
✅ Creating and sending tasks – selecting an employee, entering a title, description, attaching files, choosing a deadline.
✅ Receiving and updating task status – automatic notifications, ability to change status and add comments/files.
✅ Closing tasks – access to the list of active tasks, updating status, sending feedback.
✅ Integration with Google Sheets – all actions are automatically recorded in the sheet (sender, recipient, status, deadline, comments, files).
✅ Flexible management system via Telegram – the entire process takes place in a convenient messenger format.
…
💰 Cost: from 8,000 UAH (depends on details)
⏳ Timeline: 10-14 days
Ready to start working immediately! 🚀
-
10 days223 USD
259 10 days223 USD
Hello!
We are ready to create a Telegram bot for task management that will integrate into your team's workflow and eliminate unnecessary tabs and complex systems. All tasks – right in Telegram, with simple management through buttons and convenient integration with Google Sheets.
✅ Easy ticket creation – choose the performer, enter the title, description, attach files, and specify the deadline.
✅ Quick task acceptance – notifications about new tickets, status changes ("Reviewed", "Started", "Deferred", "Done"), feedback with comments and attachments.
✅ Full transparency – the bot automatically records all actions in Google Sheets, logging time, responsible persons, and completion status.
✅ Flexibility and scalability – can be customized for any business processes, and data is always at hand.
We will take care of all the development: from setting up the logic to deploying the bot and integrating it with your Google document. You will only need to use it! We are ready to discuss the details and get started.
-
10 days178 USD
798 3 0 10 days178 USD
Good day
I am the founder of the IT company Zentriflex.
In my team, there are Full Stack developers who write quality code using the latest technologies.
We work with technologies such as Node.js, Nest.js for the Back-end part.
We are ready to implement your idea.
We will be able to accurately assess the cost and timeline for development after agreeing on all the details.
-
5 days62 USD
369 1 0 5 days62 USD
Hello! I will do it with high quality and well-structured code! I have an identical job (you can take a look at my portfolio, go to GitHub and see the structure) I will be happy to collaborate with you :)
-
10 days89 USD
316 6 0 10 days89 USD
I am ready to write you a bot in Python. I have experience in creating bots, here are some examples of my bots: MuzykaFreeBot ZobrazhenyaConvertBot CreateQRCode_robot AudioRizakBot
-
5 days178 USD
4058 39 0 5 days178 USD
Good day. I can create such a bot. Why not use a database? Why a Google spreadsheet?
-
4 days89 USD
1476 14 1 4 days89 USD
Hello, I am ready to develop a bot with a task system, write to me in private messages, we will discuss the details.
-
2 days89 USD
9927 117 0 2 days89 USD
Hello.
I am developing bots for Telegram using NodeJS. I have experience with Google Sheets. I am ready to take it on. Write to me, we will discuss.
-
6 days111 USD
1792 9 0 6 days111 USD
Good day!
I professionally develop bots in Telegram and web applications in JavaScript.
I am ready to implement such a bot for you + deploy it on the server.
Write to me in private messages, we will clarify the details.
-
Якщо 25к підходить, можу показати схожого бота і оговорити нюанси.
-
Current freelance projects in the category Bot Development
Pocket Option trading bot
71 USD
I need a bot and your expertise who has already been able to create a similar bot when the bets are correct, they are read from Pocket Option I am interested in Brent Oil I do not need a beginner or someone who will just write code for the sake of it I need someone who knows… AI & Machine Learning, Bot Development ∙ 18 hours 39 minutes back ∙ 11 proposals |
TG BOT for Auto Ria
156 USD
We are interested in creating a bot that can send 1000+ exchange offers per day from one account. Authorization through Ria login and password, with characteristics exclusively those listed on the portal. The ability to limit the number of exchange requests. Also, monitoring… Bot Development ∙ 20 hours 19 seconds back ∙ 31 proposals |
Integration of Viber in 8.3
223 USD
Need Viber integration into own CRM (1C 8.3)About the Company The company "Domofon System" is engaged in the installation and maintenance of intercom systems. Base of over 40,000 subscribers. We work on our own customized system based on 1C 8.3. We are looking for a specialist… Databases & SQL, Bot Development ∙ 20 hours 57 minutes back ∙ 10 proposals |
Development of a Telegram store for a clothing brand. Product catalog, sizes, cart, order processing.
178 USD
A Telegram channel is needed with a warehouse from the KCRM system, showing stock balances, and full payment to the IBAN account. Bot Development ∙ 2 days 6 hours back ∙ 65 proposals |
Telegram bot
266 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 ∙ 3 days 23 hours back ∙ 115 proposals |
Odessa