Washing cars in people's driveways is a real business. Low startup cost, repeat customers, and the whole thing fits in the trunk of a hatchback. The part that falls apart is the back office. Who's booked for Tuesday? Did the guy on Elm Street pay? How many washes did we do last month?
The idea here is to build a Google Sheet that takes in orders, schedules them, and tracks the money, and then sell that sheet to everyone else who wants to start a mobile car washing side hustle.
It's number 42 on my list of 100 business ideas in Google Sheets, and it's a good example of building the tool once and selling it many times instead of doing the labor yourself.
The idea
Instead of just washing cars, employ a team and build the sheet that runs the operation. Then sell that sheet to others who want a side hustle in the car washing industry. It could just as easily be detailing, or any specific service you can do in someone's driveway. Headlight restoration, interior shampooing, ceramic coating. Same tracker, different service menu.
This is a great fit for experienced cleaners or automotive enthusiasts. You already know what a job takes and how long it runs. As long as you can take in orders and schedule those orders, you can build a killer mobile car washing service tracker.
The reason a sheet beats a notebook is the dashboard. SUM, SUMIF, and COUNT formulas give you revenue this week, jobs completed, average ticket, and outstanding balances without any manual math. Conditional formatting shows off today's schedule so a washer can glance at the sheet on their phone and know where to be next.
And rather than keeping everything on one page, use FILTER to make a whole tab for today's services. A daily view is a better tracker than scrolling past last month's jobs to find this afternoon's.
Once you're comfortable, learn Apps Script to automate the split. Past services, future services, and today's services can each land on their own tab automatically. The person using the sheet never moves a row. They just open it and the right jobs are in the right place.
How to build it in Google Sheets
Everything flows from one Jobs tab. Every other tab is a view of it.
- Jobs tab. Columns: Job ID, Customer, Phone, Address, Service, Vehicle, Scheduled Date, Scheduled Time, Assigned Washer, Price, Paid (checkbox), Completed (checkbox), Notes.
- Customers tab. Name, Phone, Address, Vehicles, First Job Date, Total Jobs, Total Spent. The last three are formulas off the Jobs tab.
- Services tab. Service name, base price, estimated minutes. The Jobs tab looks up price and duration from here.
- Today tab. A FILTER of Jobs where Scheduled Date equals today, sorted by time. This is the tab a washer keeps open.
- Upcoming and Past tabs. Same idea, filtered forward and backward from today.
- Dashboard tab. Revenue this week, this month, jobs done, unpaid balance, top customers.
- Booking form. A Google Form that writes new jobs into the Jobs tab so customers, or you on the phone, can book without opening the sheet.
Features that do the work:
-
FILTER for the Today tab.
=FILTER(Jobs!A2:M, Jobs!G2:G=TODAY())is the entire tab. - Data validation dropdowns for Service and Assigned Washer, pulled from the Services tab and a short washer list, so the SUMIF formulas on the dashboard always match.
-
Checkboxes for Paid and Completed. Two clicks close out a job, and the dashboard's unpaid balance is
=SUMIF(Jobs!K2:K, FALSE, Jobs!J2:J). - Conditional formatting to turn today's rows green, overdue unpaid rows red, and completed rows grey.
- XLOOKUP on the Jobs tab to pull the price from the Services tab when a service is picked.
- Time-driven Apps Script trigger that runs every morning and moves yesterday's completed jobs into an archive tab, so the Jobs tab stays short and fast on a phone.
- MailApp to send each washer their day's route at 6am. It's a short script and it makes the sheet feel like real software.
Build the FILTER version first. The Apps Script version is the upgrade, and it's also the thing that justifies a higher price.
Who pays for it, and how to sell it
The buyer is someone starting or running a mobile wash or detailing operation, usually solo or with one or two helpers. They are not going to pay for scheduling software with a per-seat fee. They will pay once for a sheet that already works, and they'll pay a bit more for one that emails them their schedule.
What they're really buying is the setup time. They could build this. They won't. Every hour they spend on formulas is an hour not washing cars.
Pricing: sell the tracker as a one-time template on Gumroad. Offer two tiers, the plain FILTER version and the Apps Script version with the automatic tab splitting and morning emails. If you want recurring revenue, sell access through OnlySheets, which shares the Google Sheet automatically with each buyer and lets you push updated versions to everyone who's paid. A service tier on top, where you set the sheet up with their services and pricing on a short call, is an easy add-on.
Getting the first 10 customers: go where the washers already are. Facebook groups for mobile detailing are full of people asking how others track jobs. Post a short screen recording of the Today tab updating as you check boxes. Offer the sheet to the first ten people who comment, in exchange for feedback and a screenshot of it in use. Those screenshots become your Gumroad page.
Related ideas from the list
- Handyman Call Tracker, which is the same jobs-and-schedule mechanic for a different trade.
- Power Washing Business Calendar, a nearly identical buyer with a slightly different service menu.
- Pet Grooming Scheduler, another mobile service where the driving between jobs is part of the schedule.
Want the other 99? This is one idea from my list of 100 business ideas you can build in Google Sheets. Get all 100 business ideas as a free Google Sheet.
And if you want to learn how to package and sell spreadsheets, my course Selling Spreadsheets walks through exactly that.