Staff check-in and check-out tracking in your messenger

Employees check in and out with a button in the messenger, and the scenario keeps the timesheet in a sheet — verifying the employee and preventing duplicates.

  • Check in and out with a button in the messenger
  • Verifies the employee and blocks duplicates
  • Keeps the timesheet as rows in a sheet
  • Employees can see their status for today
Google Sheets
Set it up for meScriptera

How it works

To move data from WhatsApp Business Cloud to Google Sheets automatically, use a ready-made scenario — no manual exports.

  1. Starts when: Telegram Trigger
  2. Check: IF /start|/menu
  3. If yes: Send Main Menu
  4. Check: IF menu_attendance
  5. If yes: Send Check In/Out Menu
  6. Check: IF menu_attendance_status
  7. If yes: Sheets Read (employee)
  8. Check: IF employee
  9. If yes: Sheets Read (Attendance Status)
  10. Then: Aggregate
  11. Then: Format Attendance Status
  12. Then: Reply Attendance Status
  13. If no: Reply Not Employee
  14. Check: IF callback_query
  15. If yes: Sheets Read (employee)1
  16. Check: IF Employee
  17. If yes: Sheets Read (duplicate attendance)
  18. Check: IF duplicate attendance
  19. If yes: Reply Duplicate Attendance
  20. If no: Sheets Append (Attendance)
  21. Then: Reply Attendance OK
  22. If no: Reply Not Employee1

You can launch this WhatsApp Business Cloud + Google Sheets integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios