Telegram bot
Home Equipment Rental Service. We accept applications through the website or directly via phone, and client records and rental histories are maintained in a Google spreadsheet. The existing website is an online store on CMS Opencart (2 versions).
Currently, we need to constantly monitor the expiration of rental periods, contact clients, wait for responses, send payment details, record these payments, and update the final rental dates. All of this is currently done manually. But since the workload is constantly increasing, I want to automate this process somehow.
Create a "Tenant Cabinet" in a Telegram bot, where clients receive important information and can perform necessary actions.
It is necessary to create a Telegram chat bot that allows clients to:
(main content)
- Receive notifications when the rental period is approaching its end, reminders.
- Extend the rental (LiqPay or similar), make rental payments, or notify about the desire to return the rented item.
- View their rental period after payment or upon request.
Basically, this main idea is implemented in the provider's bot OurNet
These 3 points are the MAIN and first ones to discuss; everything else is additional options of the "would be good" category
Additionally, it would be good to implement the following as extra functionality:
Automatic calculation of buyout price from rental. Considering payment history and estimated value of the item. Formula.
Collecting feedback. (after certain triggers)
Display: Instructions for items / Rental terms / Contract template
(informational block)Advertising mailings to "inactive" clients in the bot.
All incoming information is stored in a Google spreadsheet.
Example of the rental end date:
There is a column in the Google spreadsheet with the end date of the item for each client, for example 01.08.2026
1 client = 1 row in the table (contract number, full name, phone, start date, end date, etc.)
Client logs into the bot.
Client receives a message that their rental period is approaching its end, for example, 7 days before the end date.
Client chooses "Pay for rental" and pays for the next 4 weeks of rental.
The bot informs them that the rental period has been extended until "28.08.2026".
At the same time, the Google spreadsheet where the end date is currently recorded should be updated with the new date.
We use this Google spreadsheet as a CRM for rental operations, and accordingly, we need to see the current information on all changes that will occur thanks to the Telegram bot.
In other words, the Telegram bot should be synchronized with the Google Sheets database and somehow record/update or separately display information about changes made by clients in the bot.
With change history, backups. If something goes wrong with the bot's operation, we should be able to track it, and it should not affect the working environment.
Link to the technical assignment in tabular form (possible bot structure)
Current CRM view
https://docs.google.com/spreadsheets/d/1wYQZ7Q_vnEh15O9-n3s14Jr9Uvvlxc0S6uuS8m9Dc-o/edit?gid=1907953533
- Clients should receive notifications when the rental period is approaching its end, reminders.
- Extend the rental (LiqPay or similar), make rental payments, or notify about the desire to return the item.
- View their rental period after payment or upon request.
Everything else is optional and can currently be disregarded, focusing on these main 3 points.
-
3 days134 USD
3 days134 USD
Hello, ready to complete your project qualitatively and quickly, I would like to discuss some points privately, waiting for feedback.
-
21 days602 USD
1762 19 0 1 21 days602 USD
Hello!
We are working on software development, websites, automation systems, and more.
We take on projects "from scratch" as well as technical refinement.
We work with a wide stack: WordPress, 1C, Opencart, Shopify, WIX, Python, JavaScript, C++, C#, Unity 3D, SQL, MSSQL, WPF, WinForms.
We have practical experience in:
– system and application programming
– business process automation
… – information security
– technical project management
After project delivery — we provide free technical support for 14 days.
We work quickly, precisely, and towards results.
We will be happy to cooperate!
-
10 days267 USD
310 2 1 10 days267 USD
Hello, Dmytro!
My name is Semen, I represent the company Wanord. We specialize in creating Telegram bots with Google Sheets integration for automating business processes.
📌 I propose a solution for your task focusing on 3 main functions:
✅ Reminding clients about lease expiration (for example, 7 days before the date from the sheet).
✅ Rent payment via LiqPay (or similar service) with automatic extension of the term in Google Sheets.
✅ Viewing the current lease term in the bot upon request.
✅ How the bot will work:
… — Client authorization by phone number/contract ID.
— Daily check of the sheet for clients with upcoming expiration dates — sending automatic reminders via Telegram.
— Client clicks "Pay" — redirects to LiqPay, after payment the bot updates the lease end date in the sheet (+28 days) and sends a confirmation.
— Command "My lease term" to view the current date.
✅ Additionally:
— Change history in a separate Google Sheet tab (log of all extensions and payments).
— Backup of Google Sheet before changes.
— Optional admin command to check the sheet status or manually run reminders.
✅ Main integrations:
— Google Sheets API: reading and updating lease terms.
— LiqPay (or other gateway): accepting payments.
— Telegram Bot API: communication with the client.
✅ Estimated cost: from $300 (depending on the payment gateway and functionality).
⏳ Estimated timeframe: 5–10 days.
✅ Experience:
— Bots for providers (payment reminders, contract status, CRM integration).
— Working with Google Sheets (reading, writing, change logs).
— Payment integration in Telegram via LiqPay, Fondy.
— Automation for subscription and rental services.
✅ Example functions:
— Telegram reminders with payment link.
— Auto-updating lease end date in the sheet after successful payment.
— Change logs and backups for control.
We can start this week. Write to me privately — we will discuss the details of your Google Sheet, reminder format, and payment logic. I will prepare a clear implementation plan for you.
Looking forward to cooperation!
Best regards, Semen
-
5 days22 USD
339 0 1 5 days22 USD
I can complete the main 3 points in 1-2 days (the bot will already be ready). Everything else will take an additional 2-4 days. Hosting is on you.
-
14 days332 USD
475 5 0 14 days332 USD
👋 Hello!
My team of specialists and I are ready to implement your project qualitatively and within a short timeframe.
🔧 We don't just complete tasks — we immerse ourselves in the client's goals, offering effective solutions and support at every stage.
Estimated cost from 14,900 to 21,900 UAH.
📩 We will be happy to discuss the details of your project in private messages!
-
12 days334 USD
1875 45 1 4 12 days334 USD
Good day
Very cool project, I want to develop this bot for you) I write bots in Python, I will be able to consider all your wishes and develop the bot architecture in such a way that its functionality can be expanded
I will be glad to cooperate)
-
21 days557 USD
2848 17 0 1 21 days557 USD
Good day, Dmytro!
There are two radically different ways to implement:
1. Create a button-based bot that will perform all necessary functions
2. Create an AI-powered bot that, at the beginning of communication, will tell the client what it can do, and then the client will communicate with it in free form. There are many advantages here, because it can answer non-standard client questions, include managers if necessary, and can be added to the website as a widget to provide 24/7 consultation.
Regarding work (very approximate):
- button-based +- $500
- AI bot +- $800
Regarding time:
- button-based +- 2 weeks
… - AI bot +- 3 weeks
-
3 days111 USD
648 5 0 3 days111 USD
Greetings!
The task is clear, I can implement it. I can do it with clean code, but I suggest using n8n so that it can be scaled later and have the ability to quickly make changes without rewriting.
Does the client have the ability to write from different tg.id? Is there already a payment system?
For other questions, I suggest clarifying privately. Write, always available.
In any case, good luck with finding a performer and implementing the project!
-
7 days334 USD
96760 1276 1 10 7 days334 USD
Hello. I have extensive experience in developing Telegram bots. Ready to cooperate
-
4 days67 USD
4028 11 0 2 4 days67 USD
Hello. I can fulfill your order on Python aiogram 3. Interaction with Google Sheets.
-
2 days67 USD
2937 73 4 2 2 days67 USD
Good day! I can create a bot that responds to the main 3 points in a couple of days!!!!!!! Contact me!!!!!
-
7 days178 USD
9927 117 0 7 days178 USD
Hello!
I develop bots for Telegram on NodeJS. Ready to take on. Write, we will discuss.
-
4 days45 USD
3367 84 0 4 days45 USD
"The existing website is an online store on CMS Opencart (version 2)."
Does it have any API for interaction with the bot?
Google Sheets as a database, in my opinion, is a very bad idea.
Unless as a temporary solution.
Write to me privately, I will explain.
Current freelance projects in the category Bot Development
I am looking for a strong specialist in trading bots and agents.
250 USD
It is important to start - TODAY I need a person who has experience in writing trading bots on DEXs (needed on the BSC network) with an understanding of transaction costs, gas, etc. I want to test several trading strategies on a real trading agent I need to quickly… Cryptocurrency & Blockchain, Bot Development ∙ 10 hours 2 minutes back ∙ 14 proposals |
Creation of a TikTok farm with income generation
602 USD
Looking for a person who can write software for a TikTok farm, so we can generate traffic and earn income. We are seeking a ready-made solution with a full cycle. Python, Bot Development ∙ 1 day 12 hours back ∙ 15 proposals |
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 ∙ 2 days 12 hours back ∙ 19 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 ∙ 2 days 14 hours back ∙ 41 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 ∙ 2 days 15 hours back ∙ 16 proposals |
Kyiv