Telegram bot for monitoring employee attendance
1. General Task
A Telegram bot is needed for tracking the working hours of employees (approximately 15 people) for a catering establishment.
Functionality:
- record the fact of employee arrival and departure;
- ensure that the person is physically at work and not marking attendance from home;
- automatically calculate the number of hours worked;
- store all data in a table (Google Sheets) for salary calculation;
- provide convenient reports to the employee and the owner.
2. Logic for Integrity Control (Presence at the Location)
A simple and reliable option is needed:
- A QR code "Start Shift" is placed at the entrance/inside the establishment.
- When scanning the QR code, the bot opens and marks the start of the shift.
- Similarly, create a QR code "End Shift".
Integrity requirements:
- The employee should not be able to simply type a command manually and "mark attendance from home".
- Any messages like "/start_shift" typed manually should be ignored; only marks that come through QR/correct scenarios should be counted.
- If you have a simpler and more reliable option (for example, geolocation check, wifi network, etc.) — it can be considered.
3. Functionality for the Employee
3.1. Marking the Start and End of the Shift
Scenario:
- The employee arrives at work → scans the QR "Start Shift".
- The bot registers the start of the shift and responds, for example:
"✅ Shift started at 09:54". - At the end of the shift:
- either scans the QR "End Shift",
- or presses a button/command in the bot (option at the discretion of the performer, but with protection against "double shifts").
- The bot registers the end of the shift, calculates the duration, and writes, for example:
"✅ Shift ended at 18:12. You worked 8.3 hours today".
Important:
- A new shift cannot be started until the previous one is closed.
- A shift cannot be closed if there is no open one.
3.2. Viewing Hours for the Month
The employee should have the ability to request:
- "How many hours did I work this month?"
For example, through the command /my_month or the button "My working hours":
The bot responds:
"From the 1st to the 30th, you worked 152 hours."
4. Functionality for the Owner/Manager
4.1. Storing All Data in a Table
One table (Google Sheets) is needed, where for each shift there is a row with the fields:
- Date
- Shift Start Time
- Shift End Time
- Employee (name / nickname / ID)
- Number of hours worked during the shift
The table is needed for:
- monthly salary calculation;
- checking disputed moments (when someone arrived/departed).
It should be done so that:
- data is written automatically;
- when reworking (adding new employees), the table continues to fill correctly.
4.2. Daily Report to the Owner
Every evening (for example, at 00:00), the bot should send the owner/manager one general report for all employees for the day:
Example:
"📊 Report for 12.11
Alex — 12.0 hours
Marina — 7.5 hours
Vanya — 6.0 hours
Total: 25.5 hours"
The report recipient — two Telegram accounts
4.3. Ability to View Employee Hours for the Month
- command for the owner like /report_month
→ the bot sends a summary table like:
"November report:
Alex — 168 hours
Marina — 152 hours
Vanya — 140 hours
…"
Format — text summary.
5. Employees and Access
- About 15 employees.
- Only employees from the whitelist (by Telegram ID or username) can mark attendance.
- Others may receive a response from the bot: "This bot is only for restaurant employees".
A convenient way needs to be implemented:
- to add/remove an employee from the list
Client's review of cooperation with Oleksandr Gluhovsky
Telegram bot for monitoring employee attendanceEverything is great! Very fast and high quality, thank you!
Freelancer's review of cooperation with Margarita Margo
Telegram bot for monitoring employee attendanceIt was convenient and pleasant to work, the task was set clearly and understandably, I recommend!
-
Ready to implement such a bot.
The user enters the bot either by scanning a QR code at the entrance or uses a previously activated bot. The bot asks to send the geo location and compares it with the reference value.
In my implementations, I have a similar bot for tracking working hours for employees of a sewing enterprise.
-
Hello, I have extensive experience in implementing bots for restaurants, which allows me to complete your project quickly and efficiently. I would like to clarify the details in person and start the work. I look forward to your response.
-
14 Hello! I propose a more reliable option for implementing your task. We will exclude the possibility of transmitting the QR code and spoofing the geolocation (Fake GPS).
I suggest setting up a phone/tablet/laptop with a working front camera at the workplace. Employees are issued badges with unique QR codes.
Logic of operation:
An employee approaches the device with the open Telegram Mini App. The camera reads the QR code on the badge. The system takes a photo, opens the work shift, and the photo is sent to the administrator in Telegram (for example: "Photo + Sergey has arrived for the shift").
In this way, colleagues will not be able to mark each other, and the employee will not be able to scan the code remotely.
All other tasks of the project, I am ready to perform.
-
1860 21 0 Hello. I can do it within 1-2 days, I will set up and configure the server, and I can also provide additional time for testing in real conditions, and at the same time we will fix any errors that may arise.
Regarding the implementation. I can offer different options.
1. Telegram bot + printed QR code, which simply encodes a link to the Telegram bot. By scanning the QR code, the employee will be able to quickly access the bot. Employee identification on-site will occur through an internal mini-application within the Telegram bot (web app), where they will need to take a photo of the QR code right here and now (it is important that it is right here and now), after which this photo is sent to the server and published in a separate Telegram chat for possible additional manual control, in case the employee decided to take a photo of the QR code in an unauthorized place (for example, at home, having previously copied it). I consider this option simple and not very reliable due to the need for inconvenient manual control.
2. Telegram bot + computer/laptop that is always in the establishment, which will serve as the identifying device. Each time the employee comes or leaves the workplace, they will use a special program on the computer/laptop, which will generate a unique QR code, and within a short time, the employee will need to scan it with a standard camera and authorize within the Telegram bot. This option is also simple, relatively reliable, fully automatic, but requires a computer/laptop in the establishment.
3. Mobile application (without Telegram bot). It can combine geolocation verification (which we do not trust due to the ease of forgery) and checking the MAC address of the Wi-Fi router inside your establishment. This option will be significantly more complicated to implement than the above-mentioned ones. But it is also relatively reliable.
4. Telegram bot + a separate device (terminal) + key card or phone with NFC support. All interactions for the start and end of the workday will occur through this terminal, while information and control will happen through the Telegram bot. This is an expensive, reliable, and quite cool way to organize such control, but it is unlikely to suit you.
ADDED:
5. Telegram bot + reprogramming the router inside the establishment, which will serve as the device verifying the employee's location. This will also be an absolutely reliable option.
…
These are the options that come to mind for now. I am ready for further discussion.
-
172 1 1 Hello! I am ready to complete this project and have extensive experience in developing various applications.
-
1034 6 0 Good day, I would be happy to take on your bot project, here are a few options for the QR code mechanism.
Option 1: Dynamic QR Code ⏱️
How it works:
At the entrance, there is a tablet/phone with a QR code that automatically updates every minute. Each new QR code is valid for only 60 seconds, after which it becomes invalid.
Protection:
Even if an employee takes a photo of the QR code, it will not work after a minute. Check-in can only be done physically at the entrance by scanning the current code.
Pros: Reliable, simple, requires nothing from employees except scanning.
What is needed: One tablet/old phone at the entrance with the bot's page open.
…
Option 2: QR + Geolocation 📍
How it works:
The employee scans a regular QR code, after which the bot requests geolocation. The check-in is counted only if the person is within a radius of 50-100 meters from the establishment.
Protection:
It is impossible to check in from home — even with a photographed QR code, the geolocation will show that the person is not on site.
Pros: Maximum reliability, no tablet needed at the entrance.
Cons: Access to geolocation must be granted each time (which may be inconvenient).
Option 3: QR + WiFi 📶
How it works:
When checking in, the bot checks if the employee is connected to the establishment's WiFi. Check-in only occurs if the person is on the restaurant's network.
Protection:
Check-in can only be done while inside and connected to the working WiFi.
Pros: Simple and works reliably.
Cons: Stable WiFi is needed in the establishment.
Choose the one that is more convenient for you and I am ready to get started.
-
2049 13 0 Good day, I have extensive experience in developing complex Telegram bots with branching logic and interface, I am ready to complete your project.
-
1762 19 0 1 Hello!
We are working on the development of software, websites, automation systems, and more.
We accept projects for development "from scratch" as well as for technical refinement.
We work with a wide stack: WordPress, 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, clearly, and with results.
We look forward to collaborating!
-
2138 22 2 Hello
I have 2 more options on how to make the check more "fair," including with geolocation.
Write to me, we will discuss everything else and I will provide a more accurate estimate.
-
1822 10 0 Good day, I have experience working with Python as well as Telegram bots, I can complete everything quickly and efficiently, write to discuss the details.
-
2211 18 3 Good day. I am engaged in the development and setup of Telegram bots, automating processes in Python. I have experience in creating bots for process automation in enterprises. I can develop a bot for you to monitor attendance with reporting. I would also like to draw your attention to some points regarding implementation:
- if it is possible to allocate a simple tablet, it is better to use a dynamic QR code
- for the database, it is better to use a hybrid scheme combining SQLite + Google Sheets, this will ensure the stability and security of all logs and reports
- I also propose to implement a reminder system for shift closure, or it can be implemented to force close shifts if there are any that were not closed from the previous day, and mark them as "require verification" in the reports
- for user administration, I will implement a simple and convenient admin panel
Write to me - I will be happy to assist you in the implementation of the project.
-
3439 10 0 Hello. I can create the bot in one to two days and set it up to work correctly in real conditions. For honesty control, there are two convenient options. The first is a dynamic QR code that updates every thirty seconds. It cannot be photographed and used elsewhere, so you won't be able to check in from home. The second option is a regular static QR code, but after scanning it, the bot requests geolocation and checks that the person is indeed at the establishment. Both solutions are simple and reliable, and you can choose any. I will also fully implement the main functionality with shifts, reports, and recording in a table. If the project is relevant, I am ready to start.
-
99 Hello. The employee does not even need to scan a QR code to check in. When a person starts their shift, it will only be necessary to request their geolocation and compare it with the location of the food service. Otherwise, it seems that there are no inconsistencies in the technical specifications, and everything is quite clearly outlined. I can take on this project. I have considerable experience in developing Telegram bots and more.
-
1872 16 0 Hello. Ready for collaboration. I will create a mini app for TG in PHP. I will implement all functionality according to the technical specifications. I will show an example of a similar implementation that I recently did. Feel free to reach out.
-
4206 53 1 1 Hello Margarita, I did a similar project for a warehouse.
I will write such a bot and help with placement on the server.
Write to me, we will discuss the details.
-
1545 9 0 Hello! I can easily write such a bot in Python. However, I think the marking system needs to be improved somehow, as a worker can take a photo of the code and scan it from home. For example, creating new codes daily. Another option is additional verification through geolocation. We can discuss other options as well.
I will do everything perfectly and as quickly as possible!
-
4611 52 1 Good evening, I am a Python developer. I have experience in creating Telegram bots of various complexity, I can create a Telegram bot according to your technical specifications. I will do everything with quality. Write to me - we will discuss the details, I will host the bot on my own server for 24/7 operation.
-
3597 11 0 My team and I offer a complete turnkey development cycle. The team consists of experienced developers, which allows us to create a user-friendly and functional product that meets all your requirements. We will discuss the deadlines and price in private messages once we have a complete understanding of the scope of work. I expect feedback from you.
-
9927 117 0 Hello.
I am developing bots for Telegram using NodeJS. I am ready to take on the task. Write to me, and we will discuss.
-
3390 24 0 Margarita, good afternoon.
I can help you with your task.
I have extensive experience in developing Telegram bots and automation.
Deadline: 4 days
Cost: 4100.
Write to me, we will discuss the details.
-
310 2 1 Hello!
My name is Semen, I am the manager of the company Wanord. We create Telegram bots for tracking changes/staff + integration with Google Sheets.
📌 What is needed:
A Telegram bot for tracking the working hours of ~15 employees in the establishment: start/end of shifts only through QR, protection against "clocking in from home," hour calculation, recording in Google Sheets, reports for the employee and the owner (2 accounts).
🔧 What we will do:
Implement QR Start / QR End (deep-link with a one-time token/signature), ignore manual commands like /start_shift.
…
Shift logic: cannot open a second shift, cannot close without an open one, anti-duplicate measures.
Google Sheets: record each shift in a row (date/time start/end/employee/hours).
Commands: for the employee “My month hours,” for the owner /report_month + daily report at 00:00 to 2 accounts.
Whitelist: add/remove an employee through a simple admin menu (by Telegram ID/username).
💰 Budget: $350–800
⏱️ Deadline: 5–10 days (with deployment 24/7)
Questions (briefly, to immediately fix the estimate):
Will there be one QR for the establishment or for each location/point?
What is the time zone (currently in the specification 00:00, for which country)?
Access to Google Sheets: is it okay through a service account (the most reliable)?
We will do everything — write to me in private messages, we will discuss the details and get started.
-
1292 36 0 Good day, I will quickly and efficiently create such a bot for you. I have extensive experience in developing bots for Telegram. Specifically, I do not have a ready-made solution for a bot that tracks work time, but I can quickly create one and will take all requests into account. I can start immediately. The price and deadlines in the bid are current. I hope for cooperation!
-
957 5 0 1 Good day.
My name is Oleksiy.
I have extensive experience in developing bots, scripts, and automation systems.
I have previously worked multiple times with similar technologies and have ideas for improving your project.
If you are interested, please write in private messages, and we will discuss all the details of the project.
I would be happy to collaborate!
-
475 5 0 Hello 👋
I am Anya, the founder of a digital agency that helps businesses grow through smart chatbots.
🔧 We create bots that take on routine tasks: consultations, bookings, appointments, order tracking. This allows companies to work faster and more efficiently, while customers receive service 24/7.
📈 Our clients' bots have already helped reduce the workload on managers and increase sales conversions.
💬 We would be happy to discuss your project in messages and find a solution specifically for your niche.
-
937 5 0 1 Greetings!
I am engaged in the development of Telegram bots using NodeJS and Python, as well as connecting to various API services, databases, and visual tables.
I have done validation using QR codes, specifically in the event ticketing system, example - https://freelancehunt.com/showcase/work/nova-party-telegram-bot/1981732.html
I propose to discuss the details of your project, after which we will agree on a budget and deadlines that are convenient for both parties. Upon completion of the work, I guarantee the writing of instructional materials for use, as well as support for 10 days.
My portfolio and ready-made solutions can be found on the website – https://vaysed.me/
Or in my profile on the freelance platform.
… I would be happy to collaborate with you!
-
5556 12 0 Hello, I carefully studied your assignment. And I will say it as it is, the QR code is not reliable for ending shifts in any case, as QR = link or static data, the employee can simply write down this data and then do everything from home. In this regard, I propose another solution:
1) Generation of QR codes by the shift manager or another responsible employee through a Telegram bot
2) Tracking that the employee has arrived for the shift by sending their location
3) Attaching a photo showing that the employee has arrived for the shift and reporting in such a format.
If you want to get a truly quality solution to your task - write in private messages, we will discuss the details and get started.
-
558 4 0 Hello! I can create such a bot for you. I have experience in writing such bots, I made a similar one for the Zina chain of stores.
-
645 8 1 Good day, very interesting project, and at the same time very simple to implement, I am ready to take it on to complete it quickly, and most importantly, with quality, if there are clarifications or details, write!
-
1945 7 0 I will create a Telegram bot for you that will manage the working hours in the restaurant: employees will check in/out only through QR codes at the location, with no option to "check in from home." The owner and manager will be able to receive a daily report on hours and a monthly text summary for each employee.
First, we will agree on the structure of the table, the format of the reports, and the list of roles (employees/admins), then I will implement the bot and test it on your real scenarios. I am ready to discuss the details and get started.
-
5084 37 2 Hello! I am ready to develop a Telegram bot for tracking working hours with QR check-ins and automatic reports.
I will implement:
start/end of shift only through QR (protection against "checking in from home");
automatic hour calculation;
saving all shifts in Google Sheets;
…
daily report to the owner + monthly reports;
whitelist of employees (approximately 15 people);
a convenient command for the employee: "my hours for the month."
I am ready to collaborate and can start immediately.
-
955 5 0 Ready to develop a Telegram bot for time tracking according to your technical specifications. Turnkey work: a bot for check-ins via QR, protection against manual check-ins, hour counting, shift recording in Google Sheets, personal requests from employees, and reports to the owner.
Ready to discuss the details and start immediately after access is agreed upon.
-
У входа/внутри заведения размещается QR-код “Начать смену”. - если его сфоткать то его можно будет просто из дома сканировать когда захочется
-
Тоже подумал об этом. Тогда нужно по гео проверять. Например, запрашивать при сканировании куар-кода местоположение юзера и сверять его с тем местом, где находится общепит. Если оно совпадает, значит человек пришел. Если нет, или юзер отказываться давать доступ, то тогда кто-то решил сегодня остаться дома)
-
QR-код краще було зробити щоб він був на екрані і генерувався новий через кожні 10 сек, тобто життя QR-кода буде 10 сек, далі він не дійсний буде якщо хтось зробить фото.
-
Чому ви тільки про QR думаєте, є ще безліч способів які буде або неможливо обійти або просто треба дуже багато мороки, і люди просто не захочуть цим займатися.
-
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 ∙ 15 hours 13 minutes back ∙ 18 proposals |
Creation of a TikTok farm with income generation
601 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 17 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 18 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 19 hours back ∙ 43 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 20 hours back ∙ 16 proposals |