Approve time off requests from a sheet
Asks the employee's manager to approve each time off request in a sheet, then updates the row and tells the employee.
Apps it connects
Authenticate each one once and the workflow is ready to run.
What it does
Each integration step this workflow runs, in order, what it is for, and the conditions and loops that decide when it runs.
- 1Google SheetsNew row triggerStarts when a request row is added to the Time off tab and reads its start and end dates the way a person writes them.
- 2Google SheetsUpdate rowSets the row's Status to Approved or Declined.
- 3GmailSendEmails the employee the outcome and the dates.
How it works
What happens on each run, in plain English.
Time off requests get lost in chat and nobody records the answer. When a row is added to your Time off tab, the employee's manager is asked to approve or decline it, and the person who asked cannot approve their own request.
The row's Status becomes Approved or Declined and the employee is emailed. Your tab needs columns named Employee name, Employee email, Manager email, Start date, End date and Reason.
You may also be interested in
Offboard a leaving employeeWhen a row is added to your Offboarding sheet, creates the offboarding tasks in Asana, dated from the last day, and emails the manager.Create onboarding tasks for a new hireWhen you add a new hire to a Google Sheet, creates their kickoff, IT setup and benefits tasks in Asana and tells their manager.
Tell the team who's out this weekEvery Monday morning, posts who is on leave this week from BambooHR to Slack, with their dates, holidays and work anniversaries.
Screen job applications against your requirementsScores each Fillout job application against your requirements, logs it, flags strong ones to the recruiter and politely declines weak ones.Start from a workflow that already works.
Add "Approve time off requests from a sheet" to your workspace, connect its apps, and make it yours.
Free plan, no credit card