Case study
How a window-cleaning business saved 4+ hours of admin a week
The problem
Every customer’s next visit and service follow-up was tracked by hand. It took hours each week, and missed renewals meant lost income.
The solution
A system in Google Sheets and Apps Script holding customer records, with configurable service intervals, due dates calculated automatically, scheduled reminders, and weekly and on-demand PDF reports emailed to the owner.
The result
- More than 4 hours of admin saved every week
- No manual calculation errors
- Every customer followed up on time
The same system is now available to other repeat-visit trades as the Service Reminder System.