Automated employee attendance & salary deduction with Google Sheets and GPT-4

Overview

This workflow is designed for HR teams and payroll department to automate the monthly process of calculating employee attendance, salary deductionsm and personalized email notification. It seamlessly integrates Google Sheets, internal attendance data and GPT-4 (via AI Agent) to generate complete monthly payroll reports with professional summaries for each employees.

Prerequisites

Before using this workflow, ensure you have:

- A Google Sheet with the monthly attendance logs - A secong Google Sheet containing salary, employee names and email addresses. - Gmail or SMTP credentials for sending email - OpenAI API key (for summarization) - Crendentials for Google Sheet and Gmail Integration

Google Sheet Structure

1. Attendance Sheet (Daily Log)

EmpId Name Date InTime OutTime HoursWorked Status