Kütüphane / Formlar ve Anketler
Formlar ve Anketler
Google Forms, Sheets, Gmail ve Gemini ile çalışan izin onaylarını otomatikleştir
Çalışan izin formu gönderimiyle tetiklenir, Google Sheets'te bakiyeleri kontrol eder, Gemini desteğiyle yöneticiye onay e-postası gönderir ve APPROVED veya REJECTED yanıtlarını otomatik olarak işler.
Ne yapar
# 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.
Adımlar
- 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
Toplam 25 adım.
Benzer otomasyonlar
Formlar ve AnketlerGemini ile YouTube Videolarını Google Forms Testlerine Dönüştür15 adımFormlar ve AnketlerClassify procurement spend in Google Sheets with Gemini and Gmail31 adımFormlar ve AnketlerPlan niche content ideas from Google Trends with Gemini and Apify39 adımFormlar ve AnketlerGemini ve Google Sheets ile Özgeçmiş Başvurularını Eleme7 adım