Attendance and deduction payroll, mailed to each employee

Once a month the scenario counts hours worked and deductions from the timesheet, prepares a report and emails each employee their own breakdown.

  • Counts hours and deductions from the timesheet
  • Prepares a clear summary for each person
  • Files the report into таблица
  • Mails each employee their breakdown at devino
Google Sheets
Set it up for yourselfScriptera

How it works

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

  1. Starts when: Schedule Trigger
  2. Then: Employees Attendant Sheet
  3. Then: Calculate hours per day
  4. Then: Employees Salary Sheet
  5. Check: Merge with Salary
  6. Then: Calculate Salary Deduction
  7. Then: Adding the report to new sheet
  8. Then: Generate AI Summary Report
  9. Then: Convert the result to JSON format
  10. Then: Send Salary Deduction Report Email
  11. Then: Save Email Log to Sheet
  12. Then: OpenAI Chat Model

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

Similar scenarios