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.