Build a leave request approval workflow in n8n with Google Sheets and Gmail

说明与用途

在 n8n 中使用 Google Sheets、Gmail 和免费公共假期 API 自动化请假审批流程，消除手工错误并准确跟踪休假余额。

问题

Small companies manually process leave requests via email and spreadsheets, leading to errors and unclear balances.

结果

Automated leave approval reduces manual errors, ensures accurate leave balances, and provides clear audit trails.

工作流

• Employee submits form with email, leave type, dates, half day, notes
• n8n counts real working days excluding weekends and public holidays, supports half days
• n8n checks remaining annual leave in Google Sheets and rejects impossible requests
• Manager receives email with Approve/Decline buttons; workflow waits up to three days
• If approved: balance updated, request logged, employee notified; if declined: logged and employee notified; if no reply: HR notified

证据

Most small companies handle holiday requests the same way: someone emails their manager, the manager replies "fine", and somebody is supposed to update a spreadsheet.

来源

This post shows how to build a proper leave approval workflow in n8n with nothing more than an n8n Form, Google Sheets, Gmail and a free public holidays API.

来源

The workflow counts real working days: weekends and your country's public holidays removed, half days supported.

来源

The manager gets an email with Approve and Decline buttons, and the workflow waits (up to three days).

来源