sheets · apps script
BLU Cleaning
Payroll that used to be a Sunday-night spreadsheet ritual — now it runs itself.
The problem
BLU Cleaning calculated payroll by hand in a spreadsheet every cycle — hours in, rates applied, deductions, totals — slow and error-prone, exactly the kind of repetitive math that quietly costs hours and breeds mistakes.
What I built
- Mapped the existing payroll logic exactly as the owner ran it, so nothing about the numbers changed — only who does the work.
- Built a Google Apps Script routine that reads logged hours, applies rates and deductions, and writes a clean pay run on demand.
- Added validation so bad inputs get flagged before they reach a payslip, not after.