Skip to content
FlowHubFluxonLab
Google Sheets
HR & Recruitingfree

Employee Monthly Attendance Analytics

by Mohamed AbubakkarUpdated Aug 2026
RequiresGoogle SheetsGoogle SheetsOpenAIEmail (SMTP)Email (SMTP)
Share Post Share
ScSchedule TriggerCoCalculate hours per dayCalculate hours…CoCalculate Salary DeductionCalculate Salar…Employees Attendant SheetEmployees Atten…Employees Salary SheetEmployees Salar…MeMerge with SalaryMerge with Sala…OpenAI Chat ModelOpenAI Chat Mod…Adding the report to new sheetAdding the repo…CoConvert the result to JSON formatConvert the res…Save Email Log to SheetSave Email Log …AgGenerate AI Summary ReportGenerate AI Sum…ESSend Salary Deduction Report EmailSend Salary Ded…123456789101112
1/5
STEPS · 12
Runs on a schedule

On a schedule, reads attendance from Google Sheets, generates a monthly analysis with OpenAI, and emails the report via SMTP.

Tags

croncomplexGoogle SheetsOpenAIHRAI Summarization
Connects
sheetsGoogle SheetsOpenAIemailsmtpEmail (SMTP)
CategoryHR & Recruiting
Triggercron
Complexitycomplex
Nodes12
AddedJun 14, 2026