Step by step
See what Google Forms scoring covers
In Google Forms you open Settings and turn on Make this a quiz, then make an answer key, assign points and add automatic feedback. Google's quiz help page describes automatic summaries of the responses, including the average, median and range of scores.
Check it fits a price or an estimate
Points per answer make a score. A quote usually adds an amount for each option and multiplies by a quantity, then shows the customer the total. Google's quiz help page describes points and scores, and does not describe showing a customer a price built from the options they chose.
Paste your spreadsheet into ChatGPT with CalcForms
Open the CalcForms app page in ChatGPT and click Install plugin. Sign in with your email when asked; we send a 6-digit code. A free ChatGPT account works. Then start a new chat, attach your .xlsx or paste the Google Sheets link, and say what it is in one line.
Say what the customer should see, then test it
Tell ChatGPT which cells are questions for the customer and which are yours: "The customer enters roof size, material and pitch. Show them the total only." Type in a quote you already know the answer to and compare, then say "publish it" and share the link.
The words to say
Copy this into ChatGPT (with CalcForms added) and fill in the brackets.
"Here is my pricing spreadsheet. Build a form from it. The customer fills in [the inputs], everything else is calculated. Show the customer only [the total]. Then publish it."
What you will see
A form with one question per input, your spreadsheet's formulas running behind it, and a results panel that shows only the numbers you chose. Every reply reaches you with the calculations done: in ChatGPT, or in the web portal on Pro.
Common mistakes
- Expecting a quiz score to read as a price. Google's quiz help describes points per answer and score summaries; a price needs an amount for each option, and often a quantity.
- Pasting a sheet with the answers typed in as numbers instead of formulas. The form needs the formulas to do the math. If your sheet is "flat", say what the rule is and ChatGPT will write it.
- Not testing with a real past quote. Always try one you know before you send the link.
Last updated 6 November 2026
Questions about the Google Forms calculator
Can Google Forms calculate a price?
How do I turn on scoring in Google Forms?
Does CalcForms work with Google Sheets?
What does CalcForms cost?
Rather do it together?
Book a free 30-minute onboarding call. We open your spreadsheet and build the form with you.
Book a free call → Or start in ChatGPT