Employee with Leave Management System using Google sheet

Welcome to our fully functional Employee Management System with integrated Leave Management, built entirely using Google Apps Script and Google Sheets. This system is completely free to use and ideal for small organizations, schools, offices, or coaching centers looking for a lightweight HR solution.

🎥 Watch the Demo Video

🆕 About the System (Version 1)

This is Version 1 of the Employee Management System. It already includes many essential features, and more exciting updates are coming soon.

✨ Key Features

• Secure Login: Users must log in using their email and password.
• Password Reset: If forgotten, users can request a reset link via email.
• Dashboard Overview: View total employees, pending leaves, team stats, and leave history.
• Role-Based Reporting: Employees are assigned to specific reporting officers by department.
• Department & Role Structure: Roles like HR, Finance, IT, etc., and departments like Admin, Finance, etc.
• Leave Management: Employees can apply for leave, and their reporting officer can approve or reject it.
• Permission System: Super Admin can define page access and edit rights per role.

🔧 How It Works

🔐 Login Page

Employees log in using their email ID and password. Forgot password feature sends an email with a reset link.

👤 User Management

Admins can add employees with complete details like name, email, phone, joining date, department, and role. Password setup link is automatically emailed.

🎯 Role-Based Permissions

Super Admin defines what each role can view, add, edit, or delete. Roles can only see the pages relevant to them (e.g., IT, Finance, HR).

📝 Leave Requests

Employees apply for leave by selecting type, dates, and reason. Requests are sent to reporting officers for approval with comments.

✅ Approval Workflow

Reporting officers can review leave requests and either approve or reject them. Status is updated in real-time on the dashboard.

📁 Google Sheets Integration

• Users Sheet: Stores employee data
• Departments Sheet: List of departments
• Roles Sheet: Role definitions
• Permissions Sheet: Role access levels
• Menu Sheet: Navigation page control
• Leave Request Sheet: All applied leaves

📄 Adding New Pages

To add a new page:

1. Add the page name to the menu sheet.
2. Edit the main.html file and add a new case in the switch block.
3. Create a function to show the desired content for that page.

If you found this system helpful, please consider subscribing to my YouTube channel for more free tutorials and tools like this.

📢 Stay Updated & Subscribe!

Subscribe to my YouTube channel for more tutorials on Google Sheets, Google Apps Script, and automation projects! 🚀

---

Enter Code to Copy the Sheet

Submit