Asks the employee's manager to approve each time off request in a sheet, then updates the row and tells the employee.
Uses
Gmail
Google Sheets
Approve time off requests from a sheet
Google SheetsWhen a row is added to the Time off tab. Save it as request.When a row is added to the Time off tab. Save it as request.
Ask the manager to approveRequest approval: Time off for request.fields["Employee name"] Save it as decision.
Who to ask: request.fields["Manager email"]
Prepared by: request.fields["Employee email"]request.fields["Employee name"] would like time off from request.dates["Start date"] to request.dates["End date"]. Reason: request.fields.Reason
Approved or DeclinedUse Approved if decision.approved is yes, otherwise Declined and save it as outcome.Set the row's StatusSet Status: outcome on row request.row_number of request.sheet_name in request.spreadsheet_url. Save it as marked.Google SheetsEmail the employeeSend an email to request.fields["Employee email"]. Save it as emailed.
Subject: Your time off request: outcomeHi request.fields["Employee name"],
Your time off request for request.dates["Start date"] to request.dates["End date"] has been outcome.Gmail