Skip to the work

VAST: requests to priced proposals

Every cleaning request becomes a priced proposal, approved twice before it goes out.

vastcleaningsolutions.comVAST Cleaning Solutions, opens in a new tab

Every cleaning request meant retyping the same details into a price sheet, a proposal, QuickBooks and Pipedrive. I connected them so one form fills them all. The team approves each quote by changing one cell in a Google Sheet. The pricing calculator, the AI step and the automations run behind it.

Tools. ZenMaid, Gemini, Google Sheets, Apps Script, Google Docs, Zapier.

Watch a request come in, then approve it at each human checkpoint.Sample

  1. The customer fills in the formZenMaid
  2. AI reads the notesGemini
  3. The sheet prices the visitGoogle Sheets
  4. You set Status to Approved in the Google Sheet
  5. The proposal is written automatically, with the customer’s notesGoogle Docs
  6. You set Invoice Trigger to Approved in the Google Sheet
  7. Invoice, deal and email are draftedQuickBooks, Pipedrive, Outlook
VAST Cleaning SolutionsProposal

New request, ZenMaid form

Sample customer

Home
3 bed, 2 bath, 1,800 sq ft
Service
Recurring clean, every two weeks
Pets
Yes

Notes“We have two big dogs, and the kitchen needs extra love.”

  • 2 large dogs: pet adjustment
  • Kitchen: extra attention
  • A personal note for the proposal

Price calculator, Google Sheets

Base price
3 bed, 2 bath
$150
Pet adjustment
2 large dogs
$20
Kitchen detail
Add-on
$15

$185, rounded to end in 9

Per visit$189

About 3 hours, 2 cleaners

Prepared for sample customer

Recurring clean, every two weeks

Per visit$189

“We’ll give your kitchen extra attention like you asked, and we always use pet-friendly products.”

A sample customer has filled in VAST’s request form. Run it to start.

How it was built

What VAST got

  • One form fills everything. The customer’s form becomes the price, the proposal, a draft invoice and a deal.
  • Two checkpoints. The team approves the price, then the proposal, before anything reaches QuickBooks or Pipedrive.
  • About 5 minutes per inquiry, down from about 45 minutes of manual calculation across five apps and websites, by the team’s own account.

How I built it

  1. Map the existing work

    I started from the customer form and the team’s pricing rules, and kept the apps they already used.

  2. Give AI one job

    Gemini reads the customer’s notes for things that change the price, like pets or a heavy clean, and writes a personal note. If it fails, the quote goes ahead on standard prices.

  3. Put the checkpoints in the sheet

    Formulas price each request. Staff set one cell to Approved to write the proposal, then a second cell to create the draft invoice and deal. Nothing sends itself.

  4. Test and hand over

    On a call with the team, we connected their sheet, ran a full test from form to invoice, and I delivered training and written guides.