CRM for Home Services — Free, Built from Google Sheets

A home services business runs on a rhythm the software industry keeps missing. The quote happens in a driveway, on a phone, between two other jobs. The customer says yes, the work gets done, and then the real asset gets created: a household that will need you again — the lawn in spring, the furnace in fall, the gutters twice a year. Whether they call you again is the whole business.

Most owners track this in a Google Sheet, because the sheet is honest and free. But a sheet can't tap you on the shoulder in September and say "the Delgados' furnace check is due," and it can't show tomorrow's jobs to the crew without someone texting a screenshot. So the repeat work — the profitable, no-marketing-cost work — leaks out through pure forgetting.

The field-service platforms that fix this run $100–300 a month and want you to reinvent your whole operation inside them. The alternative: leave the sheet alone and have AI build the reminder system and crew views on top of it.

Step 1: Start With Your Customer Sheet

One row per customer is all it takes. A landscaping or HVAC sheet usually carries columns like these:

If you run a cleaning company the Service column says "biweekly deep clean"; if you paint, "exterior, south side." The columns don't need renaming — the AI reads them as they are.

Step 2: Create a Free Account

Head to lovespreadsheets.com and sign up. Building and running the app costs nothing; the paid tier adds things like a login for each crew lead on your own web address, which you can bolt on later if the season goes well.

Step 3: Describe How a Job Flows

Select the CRM template and lay out your process the way you'd train a new office helper:

• "A call or a form fill comes in as an Inquiry. We quote it within a day, usually from the truck."
• "Status runs Inquiry → Quoted → Scheduled → Done → Repeat — and Repeat is where the money is."
• "When a job wraps, we set the next-due date: a year out for cleanups, six months for HVAC maintenance."

Three requests that pay for themselves:

• Due-for-service reminders — a standing list of every customer whose next-due date is inside 30 days, which is your recurring-revenue engine written down
• Neighborhood filters — pull up everyone in Maple Hill before you're in Maple Hill, and turn one booked job into three
• Crew-day views — each crew opens their phone and sees only their route for the day, addresses and job notes included

Hit AI Optimize if your write-up feels rough, answer whatever the AI asks back, upload the sheet, and run. About 15–20 minutes later you have the app.

Step 4: The Office and the Truck See the Same Thing

You get a link. On the office laptop it's the full pipeline — inquiries to chase, quotes waiting, this week's schedule. On a phone in the truck it's today's stops. Mark a job Done from the customer's curb and the sheet updates before you've pulled away; when the office reschedules a rained-out cleanup in the sheet, the crew's view changes on its own.

Keep it private to your team, and the whole operation runs off one live list instead of texts, screenshots, and memory.

Why Home Services Businesses Keep the Sheet

The callback list writes itself. Every completed job with a next-due date automatically becomes future work. No more discovering in October that you never called your spring-cleanup list.

New hires learn the territory from day one. Routes, regulars, gate codes, "dog in the backyard" notes — it's all on the customer record, not in the owner's head.

Your phone stops being the database. Quotes, addresses, and history live somewhere the whole crew can reach, so a dropped phone is an errand, not a catastrophe.

Common Questions from Home Services Businesses

One customer, several services — does that work? Yes. Give each service its own row, or its own columns, and say which in your description; the AI structures the app around your choice.

Can reminders match the seasons? Yes — reminders key off whatever date is in the next-due column, so a 12-month lawn cycle and a 6-month HVAC cycle coexist in the same sheet.

Can the office keep working in the plain sheet? Absolutely. Sync is two-way and live, so a scheduler who loves spreadsheets and a crew that loves phones are always looking at the same data.

Build Yours

Take the customer sheet as it sits, go to lovespreadsheets.com, and describe the trip from first call to "see you next year." By the time the next quote request comes in, you'll have a system that remembers every customer who's due — so the repeat business stops depending on anyone's memory.