Telegram bot software for managing Google Sheets with data entry and updates in Python
112 USD ### 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.
-
2 days112 USD
1447 20 1 2 days112 USD
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.
-
5 days335 USD
4975 41 4 1 5 days335 USD
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.
-
2 days112 USD
165 6 0 2 days112 USD
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.
-
1 day357 USD
3853 24 0 1 day357 USD
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
-
1 day446 USD
8193 63 1 1 day446 USD
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!
-
5 days112 USD
236 5 days112 USD
Hello. I am ready to implement your Telegram bot, I have experience in integrating various Google services.
-
7 days112 USD
1982 47 7 2 7 days112 USD
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
-
3 days110 USD
923 53 2 1 3 days110 USD
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.
-
15 days223 USD
1616 8 0 15 days223 USD
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.
-
4 days112 USD
1017 2 1 4 days112 USD
The task is clear. I generally know how to do this, write to me. . . . . . .
-
7 days112 USD
1300 25 0 7 days112 USD
Hello. I am ready to complete your task. Overall, the task is clear, but there are some points that need clarification.
-
5 days112 USD
421 13 0 5 days112 USD
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.
-
7 days179 USD
9972 117 0 7 days179 USD
Hello.
I am developing bots for Telegram on NodeJS. I am ready to take it on. Write to me, we will discuss.
-
3 days112 USD
1803 31 0 3 days112 USD
Hello, I am ready to develop.
Write to me in private messages to discuss the details.
-
3 days45 USD
219 1 1 3 days45 USD
Hello,
Please write in private messages so we can do this project for you. I am waiting for a response in private messages.
-
1 day22 USD
3096 50 1 1 day22 USD
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
-
7 days223 USD
1993 12 0 7 days223 USD
Good day
I can develop such a bot, I have extensive experience
Write to me
-
ну чесно хто буде читати опис згенерований жпт? всі просто згенерують автоматичну відповідь
як жеж дістали з цим, 2 екрана просто води
-
Current freelance projects in the category Bot Development
We are looking for a developer to create a trading bot/chatbot.
We are looking for a developer to create a trading bot / chat bot. An IT specialist is needed who can develop a bot for market analysis 24/7 and send trading signals for gold, indices, Bitcoin, and Forex pairs. The main requirement is that the specialist must understand… Python, Bot Development ∙ 3 hours 9 minutes back ∙ 22 proposals |
Telegram bot for auto serviceGood afternoon. A Telegram bot needs to be created for an auto service. The bot should assist the mechanic in conducting a complete technical diagnosis of the vehicle using a checklist, adding photos/videos of malfunctions, The structure of the bot is written in the technical… Bot Development ∙ 8 hours 17 minutes back ∙ 75 proposals |
Restoration of access to the Telegram account.
223 USD
My Telegram was on a German number that has been inactive for 5 years. The email was not linked. Two-factor authentication was enabled for protection. The account has somehow logged out on all devices. I need help recovering the account. Bot Development, Apps for iOS (iPhone and iPad) ∙ 12 hours 12 minutes back ∙ 9 proposals |
Automatic posting of stories on InstagramGood day, I need help with setting up automatic posting of stories on Instagram. There are already stories in the Instagram archive that have been published, and they need to be reposted. AI & Machine Learning, Bot Development ∙ 15 hours 56 minutes back ∙ 23 proposals |
Automation bot for playerok.com
89 USD
1. Main Menu and Monitoring Dashboard screen updated in real-time (or by button): Status of key modules (On/Off). Current tasks: number of pending code/email deliveries from buyers, active orders. Financial summary for the current date (Total amount, net profit considering… Engineering, Bot Development ∙ 2 days back ∙ 37 proposals |
Kyiv