HR Leave Management with Apps Script
Leave requests, balances and a team calendar, all inside Google Workspace, with no server to run.
- Published
- Video length2 min
Watch on YouTube
Subscribe on YouTube to unlock the source code below.
Source code
Get the Source Code
Everything built in the video, ready to run. Delivered as a Google Drive folder.
What's included
- Template spreadsheet with script
- Setup guide
Setup instructions
- Make a copy of the template spreadsheet.
- Run setup() from the Apps Script editor and accept the permissions.
- Add your employees to the Staff sheet.
About this project
A leave management system for small companies, built on Google Sheets, Calendar and Apps Script. Employees request leave, managers approve it, balances update automatically and approved leave lands on a shared team calendar.
It shows how far Google Workspace can take you before you need a custom backend.
Features
- Leave request form
- Balance tracking by leave type
- Manager approval by email
- Shared team calendar sync
- Yearly reset and carry-over rules
What you will learn
- Working with the Calendar service
- Designing a sheet as a small database
- Handling time zones and public holidays
- Publishing a script as an add-on for your domain
Screenshots
About this video
- Episode
- E03
- Category
- Google Apps Script
- Published
- May 15, 2026
- Video length
- 2 min
- Access
- Subscribe on YouTube to unlock the download
- Google Apps Script
- JavaScript
Reviews & comments
Reviews & comments
Built it yourself? Tell others how it went, or ask a question.
Leave a review