Telegram bot + Google Sheets for a cleaning company (via Make)

Hello! I can fully set up the Google Sheets + Make + Telegram bot "turnkey", including the structure of the sheets, formulas, auto-calculations, reports, and access restrictions for employees.
What I will do
1) Complete table structure (all sheets and connections)
I will set up and standardize the sheets:
Employees (rate, role, activity, calculation fields)
Clients (client card, addresses, contacts, status)
Orders (main flow of orders from Telegram)
Schedule (daily/weekly schedule from Orders)
Payroll (salary for the period)
… And additional sheets from the update:
Inventory + conditional formatting (In stock < Min level → red)
Fines / Bonuses (fines/bonuses) accounted in Payroll
Equipment (what each person has)
Clients History (order frequency, amount, last order — automatically from Orders)
Dashboard (summary KPI for the owner)
2) Telegram → Make → Orders (normal text parsing)
I will connect Telegram to Orders through Make so that a message like:
"Tomorrow 10-14 Shevchenko 12 Petro 2400"
is automatically parsed into fields:
date (tomorrow/today/specific date)
time (10–14) → hours
address
employee
amount
payment status (default "not paid", can be changed by command)
I will implement error protection (incomplete message, unknown employee, incorrect time) — so that the scenario does not break.
3) Automatic calculation of hours / rate / salary
In Orders / Payroll, the following will be calculated automatically:
worked hours (from time)
employee rate (from Employees)
amount to be paid for the order
total for the period by employee
+ accounting for fines/bonuses from Fines/Bonuses
if necessary: "deductions/premiums", "paid/not paid", "commission", etc.
4) "My Schedule" — so that everyone sees only their own
I will create My Schedule:
either through separate "personal" sheets/views,
or through publication/filter view + restrictions,
or by providing each employee with a separate link/file that pulls only their shifts (the safest option to really "see only their own").
5) Owner's Dashboard
I will compile a sheet with key indicators:
orders today
unpaid orders
income for the day/month
who is working today
employees' salaries for the selected period
What you need to start
access to Google Sheets
access/rights to the Make scenario
example of 10–20 real messages from Telegram (or current format)
list of employees and rates (150/160)
If you want — I can also add:
Make error log (where to write if the message did not parse)
buttons/commands in Telegram for "paid", "cancel"

Show original

Translate

Good day, Ilya!

I can fully set up the system for the cleaning company on Google Sheets and Make.com, using the already existing script and Telegram bot.

I would be happy to discuss the details to offer the optimal solution.

Show original

Translate

Hello Ilya

work examples:
https://freelancehunt.com/showcase/work/tg-bot-dlya-uchitelya/2014869.html
https://freelancehunt.com/showcase/work/tg-bot-dlya-igryi-zhizn/2014873.html
and there are more.

also have experience with dashboard
https://freelancehunt.com/showcase/work/parsing-vizualizatsiya-dannyih-dlya-prodazhi/2014205.html

Show original

Translate

Good day!
The task is clear — this is exactly the case where Google Sheets + Make + Telegram work perfectly together 👍

I can fully set up the system "turnkey," not just connect the bot.

What I will do:

I will design and set up all Google Sheets:
Employees, Clients, Orders, Schedule, Payroll + Inventory, Fines/Bonuses, Equipment, Clients History, Dashboard
… I will write formulas:

automatic hour counting
salary calculation considering rates, fines, and bonuses
summary by periods
I will connect Telegram → Orders through Make
(processing messages like: Tomorrow 10-14 Shevchenko 12 Petro 2400)
I will set up My Schedule — so that the employee sees only their schedule
I will create a Dashboard for the owner with key indicators
Conditional formatting for inventory (minimum stock levels)
I will structure everything neatly so that the system can be easily scaled

Deadlines

⏱ 5–7 working days

Cost

💰 200–250 $ (depends on the final logic of calculations and formulas)

After delivery:

a short instruction
I will explain where to change what
the system will be ready for real work without further modifications

I am ready to start immediately and, if necessary, connect to your Make scenario.

Show original

Translate

Good afternoon, I recently did something similar: a Telegram bot with Google Sheets integration, statistics, and an admin panel. There is an opportunity to use a Google service account and scripts to avoid the intermediary of Make, it will be cheaper. Write to discuss the details.

Show original

Translate

Good day.
I have made enough of such and similar bots, specifically through the services you have described. Feel free to contact me, we will discuss all the details and get started.
I am looking forward to it!

Show original

Translate

Hello. I have already created exactly the same bots as you describe. I have been working with Make for a long time and know how to optimally build the scenario to save credits and get the maximum benefit. I am ready to start today.

Show original

Translate

Hello! My name is Vladislav. I have experience in building automation and data management systems, so I am happy to implement this ecosystem for your cleaning company.

My project implementation plan:

Google Sheets Architecture (10+ sheets): I will set up not just tables, but an interconnected database. The Payroll and Dashboard sheets will automatically aggregate data from Orders, Employees, and Fines/Bonuses using complex formulas (QUERY, SUMIFS, ARRAYFORMULA).

Intelligent parsing through Make: I will configure the scenario so that a text message from Telegram is correctly distributed across the columns of the Orders sheet. I will use regular expressions (Regex) to ensure the system understands the date, time, address, and amount, even if they are written in plain language.

Inventory and Equipment Control: I will set up the Inventory sheet with conditional formatting (red highlighting at critical levels) and a system for tracking equipment for each employee.
…
Owner's Dashboard: I will create a visually understandable report where you will see real-time income, the number of orders, and the current payroll fund.

Personal Schedule: I will implement the My Schedule sheet so that data is filtered for a specific employee.

Why you should choose me:

I have experience working with Make and n8n, which allows for building reliable connections between Telegram and spreadsheets.

I have a deep understanding of the logic of Google Sheets as a database (avoiding duplicates, automatic calculations).

I am focused on making the system "resilient" to input errors.

Show original

Translate

Hello!

The task is clear: you need not just a connection with Telegram, but a full-fledged accounting logic with automation of calculations, inventory, and analytics. I have experience in building similar systems where Google Sheets work as a database.

What I will do:

Table architecture: I will set up all 10 sheets with the correct data types and inter-sheet relationships (VLOOKUP/QUERY/FILTER).

Scenario in Make: I will set up parsing of text messages from Telegram for automatic distribution of data into the Orders sheet.
…
Payroll & Fines logic: I will implement automatic salary calculation, taking into account rates, hours worked, bonuses, and fines.

Inventory and Equipment: I will set up conditional formatting for monitoring stock levels and inventory accounting.

Dashboard: I will display key metrics (revenue, orders, charts) on a separate panel for operational management.

The system will be scalable and protected from manual input errors.

Show original

Translate

Hello. I have extensive experience in developing Telegram bots. I am ready for collaboration.

Show original

Translate

Hello!

The task is clear — it is necessary to build a full accounting system for a cleaning company based on Google Sheets with automatic calculations.

I have practical experience in creating similar solutions:
— building the structure of Google Sheets as an operating system
— integrating a chatbot with Google Sheets for automatic order saving
— calculating worked hours, rates, and salaries
— work schedules, bonuses, and penalties
… — pivot tables and dashboards for the owner

Example: https://freelancehunt.com/project/development-and-setup-of-a-telegram-bot-for-accounting/1529838.html

How I see the implementation:

1. complete structure of tables (Employees, Clients, Orders, Schedule, Payroll, Inventory, Equipment, History, Dashboard)
2. automatic filling of Orders from the chatbot
3. formulas for calculating salaries, bonuses, and penalties
4. personal schedules for employees
5. basic dashboard for the owner

For accurate assessment, it is important to clarify:

1. do all orders come in the same message format?
2. is salary accounting done daily or for a period (week/month)?

Show original

Translate

Good day! I have experience working with both no-code tools (Make/n8n) and development in Python. However, for your case, implementation through code will be more effective for several reasons:

- Complex Payroll Logic: Calculating salaries considering bonuses and penalties is more reliably implemented with code. This will help avoid confusion in Make scenarios, which become cumbersome with a large number of conditions.

- Security and Data Access: Unlike standard solutions, a bot in Python can act as a "filter." You will be able to set everything up so that employees only see their orders and addresses, without having access to the entire customer database or financial reports in the spreadsheet.

- Stability under Load: With an active flow of applications, direct integration through API works faster and does not require constant expenses for paying for subscription packages of third-party platforms.

I suggest discussing the details of your business processes in private messages. This will help us determine the optimal approach and objectively assess the volume of work.
…
I look forward to your feedback. Please write.

Show original

Translate

Good day! I have a very large experience in working with spreadsheets!!!! Feel free to contact me!!!!!!!!

Show original

Translate

Good day! I have studied the task, this is my area of expertise. I have experience working as a financial director and operational director in an engineering company, so I will set up not only the integration but also the correct architecture for management accounting.

What I offer:

Make + Telegram: I will set up parsing of incoming messages so that the data is clearly distributed across columns (Date, Time, Address, Employee, Amount).

Logic Sheets: I will create an automatic payroll calculation taking into account the sheets for fines/bonuses and rates from the employee's profile.

Dashboard: I will display key metrics (income, debts, workload) on one screen for you.
…
Security: I will set up access rights (Protected sheets/ranges) so that employees only see their own schedules.

I am ready to discuss the details and start today. I will create a structure that is scalable for future growth.

Show original

Translate

Good
Had experience creating bots for cleaning companies
I will create all necessary sheets in Google Sheets and set up their operation through scripts, formulas
Ready to collaborate

Show original

Translate

Good evening, I will do it clearly, qualitatively, and quickly. I have already had work with this, so write to me.

Show original

Translate

Ilya, good day.
Why do you need to use intermediary platforms like Make when everything can be done directly in Google Sheets (linking a bot with all parameters)?
Feel free to reach out, the task is simple, I can offer you more interesting and flexible options.
Point 4 requires detailed discussion, as there is no standard solution to prevent the document user from seeing other data (besides primitive tricks that can be undone in a couple of clicks).
P.S. If needed, we can meet in Prague.

Show original

Translate

Ready to quickly complete the task, have experience working with Google API for generating tables from a Telegram bot.

Show original

Translate