HR bot in your messenger: attendance, salary and absences

Employees clock in and out and ask about salary and advances right in the messenger, while the bot uses AI to handle it all and keep records in a sheet.

  • Clock-in, clock-out and hours tracked automatically
  • Salaries, advances and onboarding — via the bot
  • A daily absentee report to your messenger
  • All HR records in a single sheet
Google Sheets

How it works

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

  1. Starts when: Telegram_Trigger
  2. Check: Route_New_vs_Existing
  3. If yes: Msg_Ask_New_Emp_Data
  4. Then: Agent_Onboarding
  5. Then: Validate_New_Emp_JSON
  6. Check: Filter_Valid_Data
  7. Then: Register_New_Emp
  8. Then: Msg_Registration_Success
  9. If no: Agent_Classifier
  10. Then: Parse_AI_Response
  11. Check: Route_Intent
  12. If yes: Lookup_Employee
  13. Check: Check_Employee_Found
  14. If yes: Route_Action_Type
  15. If yes: Get_Arrival_Time
  16. Then: Calc_Departure_Stats
  17. Then: Log_Departure
  18. Then: Msg_Departure_Success
  19. If no: Log_Advance
  20. Then: Msg_Advance_Success
  21. If no: Log_Transaction
  22. Then: Msg_Attendance_Success
  23. If no: Msg_Employee_Not_Found
  24. If no: Fetch_Salary
  25. Then: Fetch_Movement_History
  26. Then: Agent_Financial
  27. Then: Msg_Analysis_Report
  28. Then: Memory_Chat
  29. Then: Memory_Analyst
  30. Then: Memory_Onboarding
  31. Then: Model_Onboarding
  32. Then: Model_Classifier
  33. Then: Model_Analyst
  34. Then: Model_Gemini
  35. Starts when: Daily_Trigger
  36. Then: Fetch_Today_Logs
  37. Check: Filter_Today_Attendance
  38. Check: Merge_Lists
  39. Then: Calc_Absentees
  40. Then: Msg_Absentee_Report
  41. Then: Fetch_All_Employees

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