This solution uses a Google Apps Script to automate the process of leave approval. The workflow is as follows:
- The user submits a leave request using a google form.
- Data from the form is sent to a linked sheet.
- As the form is submitted, the app script sends the information in the form to the approver.
- The approver can choose to accept or deny the request by clicking on either option in the email.
- The approver's response is recorded in the sheet and also sent to the requester.
- If the request was accepted, an out of office event is automatically created in the requester's calendar.
The instructions on how to deploy the solution can be found here: https://docs.google.com/document/d/1FRHyiDVgM2ngEdt_zD4nuqb7V_YKDojF3CtEUWufiu0
This script is an extension of the one step approval workflow app script here: https://github.com/Pawa-IT-Solutions/One-Step-Approval-AppScript