Automation & Data Engineering
HR Overtime Automation — n8n + Slack
Eliminated 2h/day of manual HR work with an AI-powered workflow bot
The Problem
HR manually processed around 300 overtime records per month, checking each one to verify if tickets had been opened and individually following up with employees and managers. This process consumed approximately 2 hours daily, limiting the team's strategic activities.
The Solution
I developed an automated workflow in n8n that runs daily, consuming the time tracking report, identifying employees with overtime, verifying the existence of corresponding tickets, and sending direct messages via Slack to employees (when ticket wasn't opened) and managers (when pending approval). The bot has its own persona named Isadora, making communication more natural.
Tech Stack
Impact Generated
- Saved ~2 hours per day (~10h/week, ~40h/month)
- Almost complete elimination of repetitive manual work
- HR freed up for more strategic activities
- Standardized process with higher reliability
- Increased response rate from involved parties
Time Saved
~2 hours/day
Weekly
~10 hours/week
Monthly
~40 hours/month
Tech Stack
Overview
Automation,
Data Engineering
Technical Stack
Technical Challenges
- Development of fallback logic for missing IDs
- Dynamic message formatting based on hours/minutes quantity
- Data normalization and treatment from time tracking reports
- Integration between multiple systems (time tracking, tickets, Slack)