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)
