About the Project
An automated payroll workflow built with n8n to streamline repetitive data processing and payslip distribution. Triggered seamlessly via Google Apps Script webhooks, the system handles dynamic folder management in Google Drive, batch-processes employee data to generate PDF payslips, and distributes them directly via WhatsApp. It also features automated payroll logging, real-time PIC alerts for delivery status, and post-process data cleanup to reset spreadsheets.
Tech Stack
The Challenge
Manual payroll processing is time-consuming and prone to errors, especially when dealing with large teams. Distributing payslips individually can lead to delays and inconsistencies, impacting employee satisfaction and administrative efficiency.
The Solution
The Payroll Automation System automates the entire payroll process, from data processing to payslip distribution. By leveraging n8n and Google Apps Script, the system ensures accurate calculations, timely delivery of payslips via WhatsApp, and efficient management of payroll records. This automation reduces administrative workload, minimizes errors, and enhances overall efficiency in payroll management.
Contributions
- Developed an automated payroll workflow using n8n to streamline repetitive data processing and payslip distribution.
- Integrated Google Apps Script webhooks to trigger the payroll process seamlessly.
- Built batch-processing logic to handle employee data and generate PDF payslips efficiently.
- Implemented dynamic folder management in Google Drive to organize employee data and generated payslips.
- Integrated WhatsApp API to distribute payslips directly to employees and provide real-time delivery status updates.
- Implemented real-time alerts for the PIC to monitor the payroll process and address any issues promptly.
- Implemented automated payroll logging and post-process data cleanup to reset spreadsheets for the next payroll cycle.