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
- On form submission
- Edit Fields
- Get row(s) in sheet
- Code in JavaScript
- If
- Send a message
- Message a model
- Code in JavaScript1
- Send a message2
- Code in JavaScript2
- Append or update row in sheet
- Gmail Trigger
- Code in JavaScript3
- Get row(s) in sheet1
Insgesamt 25 Schritte.
Ähnliche Automatisierungen
Formulare & UmfragenYouTube-Videos mit Gemini in Google-Forms-Quizze umwandeln15 SchritteFormulare & UmfragenClassify procurement spend in Google Sheets with Gemini and Gmail31 SchritteFormulare & UmfragenPlan niche content ideas from Google Trends with Gemini and Apify39 SchritteFormulare & UmfragenLebenslauf-Bewerbungen mit Gemini und Google Sheets vorab prüfen7 Schritte