Leave Request Approval
An employee submits a leave form, the manager approves or rejects by email, approved leave is added to the team calendar, and the employee's balance is reduced in Google Sheets. The employee is told the result by email.
Steps in this flow
- Leave request form
- Manager approval
- Calendar end date (+1 day)
- Google Calendar: add the leave
- Google Sheets: read balance
- Days between the dates
- Calculate the new balance
- Google Sheets: update balance
- Email: leave approved
- Email: leave rejected