The Leaves & Attendance template helps HR and operations teams automate employee attendance tracking, manage leave requests, and monitor real-time workforce data.
This workflow combines structured Google Sheets, smart forms, and a visual dashboard to ensure accurate attendance and leave management - all in one connected system.
How the Workflow is Structured
The workflow has:
Add Employee form – Register new employees with all details.
Update Employee Slot form – Assign working shifts and grace periods.
Daily Attendance form – Employees mark their check-in/check-out.
Leave Request form – Employees submit leave applications.
Leave Approval Decision form – Approvers approve or reject requests.
Leave & Attendance Sheet – Centralized master file for all data.
Dashboard – Visualizes daily presence, absence, lateness, and overtime metrics.
Step 1: Install the Template
Install the template from this link: Leaves & Attendance
Once installed, the workflow will open in your Sheetgo workspace at app.sheetgo.com.
You’ll see helpful notes in the right-side panel of your workflow.
👉 Before starting, delete the sample data in the spreadsheets (but keep the headers and formulas).
Step 2: Configure Dropdowns
The Dropdown tab in the master spreadsheet stores predefined values that populate the options in your Sheetgo forms — ensuring consistent and accurate data entry across the workflow.
This tab defines:
Attendance types – Check-in or Check-out options for the Daily Attendance form.
Leave types – Categories such as Casual, Sick, Earned, or Comp Off for the Leave Request form.
Approvers – Authorized email addresses that appear in the Approver dropdown field of the Leave Request form.
Each time a new approver is added in this tab, they will automatically appear in the Leave Approval Decision form for corresponding leave types.
Column | Description |
Attendance type | Defines whether the record is for Check-in or Check-out. |
Leave type | Specifies the type of leave employees can select when applying. |
Approvers | Lists the email addresses of approvers for each leave category. |
Step 3: Configure Holidays, Working Days & Inactive Employees
Holidays Tab: List official holidays to automatically exclude them from attendance calculations.
Working Days Tab: Customize weekly working patterns using checkboxes — ideal for alternate weekends or rotational schedules.
Inactive Employees Tab: Mark employees who have resigned or been deactivated. These employees are excluded from future attendance and leave reports.
Step 4: Share with Colleagues
To ensure smooth collaboration and secure access:
Share the Add Employee, Update Employee Slot, Daily Attendance, and Leave Request forms with your employees and team leads.
Share the Leave Approval Decision form only with approvers or HR managers.
Restrict access to the Leave & Attendance spreadsheet to HR or admin users only.
Share the Dashboard with management or department heads for visibility into attendance and leave metrics.
This ensures that all users interact only with the components relevant to their role.
Refer to the following articles to share workflows, forms, dashboard and files:
Step 5: Add Employee
Use the Add Employee form to register all employees in the system. The data automatically populates the Employees tab in the master file.
Fields include:
Full name, email, and contact details
Date of birth and emergency contact
Addresses (permanent and present)
Gender
Previous organization, job title, and leaving date
Attachment for ID proof or joining documents
Step 6: Define Employee Slots
Use the Update Employee Slot form to assign check-in/check-out times and grace periods.
Fields include:
Employee ID (dropdown from employee database)
Employee email (auto-filled)
Check-in and Check-out time
Grace periods (in minutes)
This updates the Employee Slots tab to ensure consistent tracking.
Step 7: Mark Daily Attendance
Employees record attendance using the Daily Attendance form.
Fields:
Email (auto-captured)
Type: Check-in or Check-out
Each submission logs a timestamped entry in the Attendances tab for accurate daily reporting.
Step 8: Submit Leave Requests
Employees request time off using the Leave Request form.
Fields include:
Email (auto-filled)
Start and End dates
Reason and Leave type (Casual, Sick, Earned, or Comp Off)
Approver (select from dropdown list of approvers)
All leave requests are saved in the Leave Requests tab.
Step 9: Approve or Reject Leave Requests
Approvers manage requests using the Leave Approval Decision form.
The Leave ID dropdown shows only the requests assigned to the approver’s email.
Approver selects Approved or Rejected.
The result updates the Leave Approvals tab and adjusts employee leave balances.
Step 10: Dashboard Overview
The Dashboard provides a clear view of daily and overall attendance insights.
Key Metrics:
Total employees checked in
Employees on leave today
Early check-outs and late arrivals
Attendance table with working hours, duration, and overtime
Step 11: Attendance Insights
The Attendance Insights tab gives detailed analytics for each employee and time period.
Metrics include:
Attendance percentage
Days Present vs Absent
Total working and holiday days
Leave category breakdown