Budget: 8000 UAH Deadline: 7 days
Hello.
I am developing bots for Telegram on NodeJS. I am ready to take it on. Write to me, we will discuss.
### Technical assignment (TA) for the development of a Telegram bot with an admin panel and integration with Google Sheets
#### 1. **Task description**
Develop a Telegram bot with an admin panel through which Google Sheets can be linked for monitoring and processing data entered by users into cells. The main goal of the bot is to track and manage the status of Telegram usernames entered into the sheets (starting with `@ username`), and their constant automatic updating in the database.
#### 2. **Functional requirements**
##### 2.1. **Linking Google Sheets**
- The administrator can link the necessary Google Sheets to the bot through the control panel.
- Each linked sheet must be available for real-time change monitoring.
- Ability to monitor multiple sheets simultaneously.
##### 2.2. **Data monitoring**
- Continuous monitoring of data entry in the cells of the sheets, tracking the appearance of new data (usernames).
- Monitoring all pages and tabs of the sheets (all data in the sheets must be covered).
##### 2.3. **Username processing**
- **Adding usernames**:
- If the entered username is new (not present in the database), it is added to the database.
- The cell with this username in the sheet is colored green for **7 days** (indicator of reserved username).
- Information is recorded in the database that this username is reserved for a week.
- If the entered username is already reserved - the cell turns red.
- **Occupancy status**:
- If another user enters the same username in their sheet, their cell turns red (indicating that the username is temporarily occupied by another user).
- **End of reservation period**:
- When the reservation period (7 days) for the username expires, the username becomes "free" in the database.
- In the sheet:
- The cell of the user who originally added the username is colored yellow. This signals that the old username needs to be removed and re-entered to update the data.
- In the sheets of other users, the cell with this username is colored green again (indicating that the username is now free).
##### 2.4. **Working with the database**
- **Main table (database)**:
- Stores all usernames entered during the entire use of the system.
- The second column of the database contains the usernames corresponding to the usernames entered by users.
- The third column shows the time until the username's activity ends (calculates the remaining time until the end of the 7-day period).
- **Connection with Google Sheets**:
- The table linked to a specific Google Sheet is dynamically updated to display the status of each username:
- Red color — username occupied.
- Green color — username free.
- Yellow color — activity time expired, re-entry required.
##### 2.5. **Color indicators**
- Green cell color — username is new, reserved for 7 days.
- Red color — username occupied by another user.
- Yellow color — reservation period expired, update required (removal and re-entry of the username).
#### 3. **Admin panel**
- Ability to add/remove Google Sheets.
- View linked sheets.
- Control the current state of the database (view all active and released usernames).
- Ability to edit and reset the database.
- Set the data monitoring interval (e.g., once a minute).
- View statistics for each sheet and user (the worker who manages this sheet, which has its own name)
- Configure and change the reservation period for each sheet
- User-friendly and simple interface with inline buttons and commands, as well as information output.
#### 5. **Workflow algorithm**
1. **Linking the sheet**: The administrator links the sheet through the admin panel, and the bot starts monitoring it.
2. **Data entry**: The user enters a username in the Google Sheet.
3. **Database check**:
- If the username is new — it is added to the database, and the cell is colored green.
- If the username already exists and is reserved — the cell is colored red.
4. **Status monitoring**:
- After 7 days, the username is released, and the cell color changes.
5. **Updating sheets**: All changes are synchronized between the database and Google Sheets.
Budget: 8000 UAH Deadline: 7 days
Hello.
I am developing bots for Telegram on NodeJS. I am ready to take it on. Write to me, we will discuss.
Budget: 5000 UAH Deadline: 2 days
Good day,
I am an experienced Telegram bot developer with over 4 years of experience, an impressive portfolio, and a desire to achieve quality results quickly and accurately. I have reviewed your task and can execute it efficiently and effectively.
Portfolio Freelancehunt
I offer a full range of services to make your project successful and easy to develop further. My goal is to provide quality development that not only meets your requirements but also exceeds expectations. I handle everything from development and testing to deploying all necessary components. You will receive a ready-made "turnkey" project, and you won't need to look for additional specialists.
Moreover, I provide full support at every stage. Together with you, we will discuss all important aspects, and I will help you think through the logic and functionality of your project to make it user-friendly and intuitive.
By collaborating with me, you gain not only a developer but also a reliable partner who is invested in your success. Ready to create something special together? Let's discuss your project in more detail!
My task is to provide reliable support throughout the entire project and after its completion. Rest assured, I am always available, ready to answer your questions and solve any tasks in real-time.
I am open to new exciting projects and ready to contribute to their successful implementation. I look forward to the opportunity to discuss the details and start our collaboration.
Budget: 15000 UAH Deadline: 5 days
Good evening!
I professionally develop bots in Telegram and web applications in Python.
I am ready to create such a bot for you + deploy it on the server.
Message me privately, and we will clarify the details.
Budget: 5000 UAH Deadline: 2 days
Good day!
I am interested in your offer and would be happy to take on this project.
I don't have much experience, but I am willing to work for a lower payment to build my rating.
Budget: 16000 UAH Deadline: 1 day
Good day,
I am ready to take on your project. I have experience in developing websites, web applications, and bots. I can help in creating a Telegram bot with an admin panel and integration with Google Sheets. I will implement the functionality for linking tables, data monitoring, username processing, and working with the database according to your requirements.
My rate is $16 per hour.
Sincerely,
Maxim
Budget: 20000 UAH Deadline: 1 day
Good afternoon!
I am ready to implement your project for creating a Telegram bot with an admin panel and integration with Google Sheets. I look forward to the opportunity to discuss the details and start working!
Budget: 4999 UAH Deadline: 5 days
Hello. I am ready to implement your Telegram bot, I have experience in integrating various Google services.
Budget: 5000 UAH Deadline: 7 days
Hello!
I can develop a Telegram bot with Google Sheets integration that will track entered usernames, automatically change their status and cell colors depending on availability, and also maintain a database for monitoring. The admin panel will allow managing the tables, viewing active/released usernames, and changing settings.
I am ready to discuss the implementation details and timelines.
Best regards, Pavlo
Budget: 4950 UAH Deadline: 3 days
Good day, Andrey.
I have a few questions regarding the task.
I am ready to start today. I will make minor adjustments and install on the server for free, payment upon project completion.
About me, my experience, and my portfolio — in my profile.
Budget: 10000 UAH Deadline: 15 days
Hello, I am interested in your project to create software for a Telegram bot.
I can implement your project within 15 days.
The cost of the work is 10,000 UAH.
I am ready to discuss the project details. I am waiting for your response in private messages.
Budget: 5000 UAH Deadline: 4 days
The task is clear. I generally know how to do this, write to me. . . . . . .
Budget: 5000 UAH Deadline: 7 days
Hello. I am ready to complete your task. Overall, the task is clear, but there are some points that need clarification.
Budget: 5000 UAH Deadline: 5 days
Hello!
I work with Excel and Google Sheets.
I am ready to help using formulas or macros (scripts).
Connection with Telegram bot and e-mail with Google Sheets.
I will be happy to collaborate.
Hello.
I work with Excel and Google Sheets.
I am ready to help using formulas or macros (scripts).
Connection with Telegram bot and e-mail with Google Sheets.
I will be happy to collaborate.
Budget: 5000 UAH Deadline: 3 days
Hello, I am ready to develop.
Write to me in private messages to discuss the details.
Budget: 2000 UAH Deadline: 3 days
Hello,
Please write in private messages so we can do this project for you. I am waiting for a response in private messages.
Budget: 1000 UAH Deadline: 1 day
Good day
I have worked with Google Sheets online and regular ones
I can help you with your task
Write to me, I will be happy to help
Budget: 10000 UAH Deadline: 7 days
Good day
I can develop such a bot, I have extensive experience
Write to me
ну чесно хто буде читати опис згенерований жпт? всі просто згенерують автоматичну відповідь
як жеж дістали з цим, 2 екрана просто води
36 proposals 12:12
Python 69 proposals 31 July
60 proposals 30 July
AI & Machine Learning 58 proposals 30 July
Data Parsing 38 proposals 30 July