Case study · Home services (US)
A Custom Lead CRM That Replaced Spreadsheets
A US home-services business was keeping track of quote requests and customers in spreadsheets. Requests arrived by phone, email and the website, and the owner had to copy them into a sheet by hand, work out each price himself and remember who needed a call back. We built a simple custom CRM into his new website, so every request lands in one place with its price already calculated.
- 6pipeline stages per lead
- 24/7instant online quotes
- 1place for every request
The challenge
- Quote requests and customers were tracked by hand in spreadsheets
- Requests came from phone, email and the website, and were retyped
- Every price had to be worked out again, and follow-ups were easy to miss
What we did
- Built an instant online quote form priced from the owner’s own price list
- Saved every request automatically as a complete lead
- Created a private admin panel with a six-stage pipeline, filters and notes
- Protected the forms against spam bots and forged requests
The results
- One place for every request, with no retyping
- Consistent prices and customers who see an estimate 24/7
- A clear view of every lead’s status and the next follow-up
The problem with spreadsheets
A spreadsheet works while there are a few requests a week. As the business grew, details were retyped from emails and messages, prices were worked out again for every job, and it was hard to see at a glance which customers were waiting for a quote, which had booked and which had gone quiet.
The owner did not need a big, expensive sales platform. He needed his own requests, in his own system, with the price and the next step clear.
What we built
An instant quote form on the website: the customer picks a service, enters the size of the job and any extras, and sees a price range straight away. The price is always calculated on the server from the owner’s own price list, so it cannot be changed from the browser.
Every finished request is saved automatically as a lead with the name, phone or email, property address, service area, job size, extras, estimate and preferred date — plus where the lead came from.
A private admin panel where each lead moves through six stages — new, contacted, quoted, booked, won or lost — with filters, internal notes and one-click call or email.
What changed for the business
- No more copying requests into a spreadsheet: they arrive complete
- Customers get a price range 24/7, before they even call
- Estimates are consistent, because they all come from the same price list
- The owner sees every lead’s status at a glance and knows exactly who to call next
Lessons for service businesses
Most small businesses do not need a large CRM. They need every request in one place, the price worked out the same way every time, and a clear next step for each customer.
Building the CRM into the website removes the retyping completely: the form that the customer fills in is the record the owner works from.
Questions about this project
Do I need an expensive CRM subscription?
Usually not. For a service business, a simple custom CRM inside your own website — requests, prices, stages and notes — covers what you use every day, with no monthly per-user fees.
Can customers get a price online?
Yes. An instant quote form can calculate a price range from your own price list based on the service, the job size and any extras, and save the request for you automatically.
Can I import my old spreadsheet?
Yes. Existing customers and open requests can be imported so you start with your full history in one place.
Services used
Client details are anonymized to protect privacy. Figures are realistic and representative of the type of results we deliver.
Get results like these
Start with a free audit, or tell us what you need — every service from $100.
Free Website Audit Get a Quote