Skip to content
NEWMarketplace and your team: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Forms & Surveys

Forms & Surveys

Automate employee leave approvals with Google Forms, Sheets, Gmail and Gemini

Triggered by leave form submissions, checks balances in Google Sheets, emails the manager for approval with Gemini support, and processes APPROVED or REJECTED replies automatically.

What it does

# HR Leave Request & Approval Automation This workflow automates the employee leave approval process using n8n, Google Sheets, Gmail. Employees submit leave requests, the workflow checks their available leave balance, sends an approval email to the manager, and processes the manager's APPROVED or REJECTED reply automatically. The workflow starts when an employee submits a leave request. Employee information and leave balances are read from Google Sheets. The requested leave days are checked against the correct balance (Casual Leave, Sick Leave, or Earned Leave). If sufficient balance is available, the manager receives an email containing the leave details and can reply with APPROVED or REJECTED. A separate Gmail-based workflow reads the manager's reply, finds the matching leave request using the Gmail Thread ID, and continues the approval process. When approved, the requested days are deducted from the correct employee leave balance, the Leave Requests sheet is updated, the employee is notified. ## Setup steps 1. Create an Employee Data Google Sheet with employee and leave balance details. 2. Create a Leave Requests Google Sheet to store all requests and their status. 3. Create the employee leave submission form. 4. Connect Gmail for manager approval emails and replies. 5. Connect Google Sheets for checking and updating leave balances. 6. Connect Google Calendar for approved leave events. 7. Set the manager's email and make sure managers reply with APPROVED or REJECTED.

The steps

  1. On form submission
  2. Edit Fields
  3. Get row(s) in sheet
  4. Code in JavaScript
  5. If
  6. Send a message
  7. Message a model
  8. Code in JavaScript1
  9. Send a message2
  10. Code in JavaScript2
  11. Append or update row in sheet
  12. Gmail Trigger
  13. Code in JavaScript3
  14. Get row(s) in sheet1

25 steps in total.

Similar automations