Draft renovation proposals from field notes without inventing scope

A renovation firm's operations lead built a Make.com and Gemini scenario that turns site-visit notes into proposal drafts, and stops to ask when measurements or scope are missing.

Done withMakeinGoogle SheetsGoogle DocsGmail· Nov 13, 2026

What they did

Courtney Collins runs operations for a residential renovation business, where staff type measurements and shorthand notes into a field-estimate form after each site visit. She built one Make.com scenario on the free plan to turn those notes into proposal drafts. It watches the form's Google Sheet for new rows and sends the area, measurements and notes to Gemini, which must return JSON: scope items and materials each tied to a quote from the notes, open questions for anything marked maybe or asked about, and a list of missing required facts. A router then either fills a Google Docs template, marks the row Draft ready and emails her through Gmail, or marks it Needs info and emails what is missing. Prices, timelines and warranties are banned in the prompt. She used Claude to help write the prompt and fix formulas.

How it went

Gemini 3.8 Flash timed out at Make's five-minute limit three times, and Gemini 2.5 Flash returned a 404 for new users; Gemini 3.5 Flash Lite answered in about two seconds. On four test notes it made three drafts and one Needs info stop. A deck note with two maybes produced a one-line scope with both maybes held as questions. A kitchen note listed the laminate being removed as a material, which a reviewer would have to fix. Reruns changed wording but not content. All test data was made up; it has not yet run on real jobs.

Worth knowing

Some Make settings had been renamed since the guides she followed, there is no is-empty filter (she checked list length equals 0), and a formatted table in Sheets would not fill a formula column. Drafts are stamped as not sent and pricing stays with a person.

Try it

With Make· 4 parts to fill in

Build me an automation in [Make.com or my automation tool] that watches [my form's response sheet] for new rows. For each row, send the area, measurements and notes to [my AI model] and require JSON back with: scope items and materials each paired with the exact words from the notes they came from, open questions for anything marked maybe or asked about, and a list of missing required facts. Never add prices, timelines or work that is not in the notes. If anything is missing, mark the row Needs info and email me the list. Otherwise fill [my proposal template], stamp it as a draft and email me the link. Stop there: nothing goes to a client until I review it.

Square brackets are the parts to fill in. The prompt is ours; the story is theirs.

Where they said it

Related