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
9944 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
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 ∙ 1 day 7 hours back ∙ 64 proposals |
Telegram bot
268 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 back ∙ 115 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 ∙ 3 days 1 hour back ∙ 59 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 ∙ 3 days 4 hours back ∙ 63 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 ∙ 3 days 4 hours back ∙ 70 proposals |
Odessa