Zum Inhalt springen
NEUMarktplatz und dein Team: Verkaufe, was du baust, und bekomm Pläne und Änderungen, die getestet sind, bevor du sie siehst. Neuigkeiten ansehen

Bibliothek / Formulare & Umfragen

Formulare & Umfragen

Mitarbeiter-Urlaubsgenehmigungen mit Google Forms, Sheets, Gmail und Gemini automatisieren

Wird durch Urlaubsanträge über Google Forms ausgelöst, prüft Urlaubsguthaben in Google Sheets, sendet dem Vorgesetzten per E-Mail eine Genehmigungsanfrage mit Gemini-Unterstützung und verarbeitet APPROVED- oder REJECTED-Antworten automatisch.

Was sie bewirkt

# 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.

Die Schritte

  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

Insgesamt 25 Schritte.

Ähnliche Automatisierungen