Manage employee leave requests with Google Forms, Sheets, Gmail and Gemini
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 25 nodes and runs when someone submits an n8n form (“Employee Leave request Form”) (plus 1 other trigger). Along the way it connects Google Sheets, Gmail and Google Gemini.
How it runs
Trigger: When someone submits an n8n form (“Employee Leave request Form”) (plus 1 other trigger).
- Edit Fields (Edit Fields (Set)): sets 12 fields: Employee Name, Employee Email, Employee ID…
- Code: runs custom JavaScript code
- Code: runs custom JavaScript code
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- Code: runs custom JavaScript code
- Code: runs custom JavaScript code
- If: checks a condition and branches into true / false
- If: checks a condition and branches into true / false
- Code: runs custom JavaScript code
…plus 13 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (9)
- n8n Form Trigger
n8n-nodes-base.formTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail - Google Gemini
@n8n/n8n-nodes-langchain.googleGemini - Gmail Trigger
n8n-nodes-base.gmailTrigger - Switch
n8n-nodes-base.switch
From the author
Quick overview This workflow collects employee leave requests via an n8n Form, checks leave balances stored in Google Sheets, emails managers for approval through Gmail (with a Google Gemini-generated message), and updates request status and balances in…