Google Forms is free, everyone already has an account, and it will collect orders this afternoon. This guide walks through building one properly, including two recent changes most tutorials have not caught up with. It is also a survey tool rather than an ordering tool, and the second half is an honest account of where that difference starts costing money.
What you end up with: your products as quantity questions, the details you need to fulfil the order, a pickup slot, and a close date — with responses landing in a Google Sheet where you add prices and totals. Twenty minutes for the first one, five for every one after.
The build, step by step
- 1
Start a blank form
Go to forms.new, or open forms.google.com and click Blank form. There is a Template gallery at the top of that page, but for an order form you will replace almost everything in a template anyway. Name it where it says "Untitled form" — customers see this, so use the name they recognise: "Rosa's Bakery — weekend pre-order".
- 2
Put the rules in the form description
The description box under the title is the only place Forms gives you to state the terms of an order. Use all of it: what is available, the ordering deadline, the pickup date and address, and how payment works. Three short lines beat one paragraph.
- 3
Add the customer detail questions first
Click the + in the floating toolbar on the right to add a question. You want a Short answer for the full name and another for the phone number, both switched on with the Required toggle at the bottom-right of the card. Do not split first and last name — one field is faster on a phone.
- 4
Add one question per product
The part most people get wrong. Do not build a Checkboxes question listing your products — you will learn who wants what and never how many. Add one Short answer question per product instead, titled with the product and its price: "Sourdough loaf — $8". That title is the only place a price appears on the form. Hover the question and use the Add image icon to attach a photo.
- 5
Force the quantity to be a sane number
On the product question, open the three-dot More menu and choose Response validation. Set the first dropdown to Number, choose Whole number, and write something human in the Custom error text box. Now duplicate the question for each remaining product — the copy icon at the bottom of the card carries the validation across, so you configure it once.
- 6
Add a per-order maximum
To stop one person taking the entire bake, use a validation rule of Number > Less than or equal to with an error message that explains it: "Maximum 6 per order — message us for larger orders." Note what this does: it caps one order, not the total across all orders. That distinction is the most important limitation on this page.
- 7
Add the pickup slot and the notes field
A Dropdown question listing your collection windows — "Saturday 9–11", "Saturday 11–1" — set to Required. Then a Paragraph question for allergies or notes, required if you sell food, labelled so "none" is clearly an acceptable answer.
- 8
Set up confirmations in Settings
Open the Settings tab. Under Responses, set Collect email addresses to Responder input, then Send responders a copy of their response to Always — that email is their receipt. Under Presentation, click Edit beside Confirmation message and replace "Your response has been recorded" with the pickup date, address, and what happens next.
- 9
Link a Sheet and switch on notifications
On the Responses tab, click Link to Sheets > Create a new spreadsheet. Then open the three-dot menu on that tab and turn on Get email notifications for new responses, so an order cannot sit unseen for a day.
- 10
Publish it and copy the link
Click Publish at the top right, use Manage to set General access so anyone with the link can respond, then Done. Click Share and Copy responder link, ticking Shorten URL first — this is going into an Instagram bio.
- 11
Set the close date
Once the form is live the top-right button reads Published. Click it, find Accepting responses, and choose Set close date or response limit. Set a date and time for your deadline, or a response count to cap orders — one or the other, not both, and the date is usually the useful one. Customise the message latecomers see while you are there.
Google Forms still has no QR code of its own. For a counter or market stall, open the published link in Chrome and use the browser's create-QR-code option. Print it at least an inch and a half across, and test it on two phones before printing fifty.
Getting a total out of it
Forms cannot multiply. To turn responses into money, you work in the linked Sheet.
- 1
Add a Prices tab to the linked spreadsheet
Two columns: product name exactly as it appears in the form question, and unit price. Keep the rows in the same order as the questions.
- 2
Add a total column after the last question
If your quantity answers sit in columns D to H and your five prices are in Prices!B2:B6, the formula is =SUMPRODUCT(D2:H2, Prices!$B$2:$B$6). Fill it down past your current rows.
- 3
Re-drag it after each batch of orders
The part nobody mentions. Form submissions insert new rows, and Sheets does not extend your formula into them. Every time you open the sheet, you drag the total column down again.
For product totals — how many sourdough loaves across every order — put a =SUM() under each quantity column. That number is your bake list, and it is the most useful thing the spreadsheet gives you.
Where a Google Forms order form breaks
None of these are complaints about Google. Forms is an excellent survey tool, free, and it works everywhere. They are the points where a survey tool and an order form stop being the same thing.
It has no idea what a price is
No price field, no running total on the page. The customer never sees what their order costs until you tell them. Three things follow: people order without qualifying themselves, you get the "I thought it was cheaper" conversation at pickup, and you lose the upsell that happens when someone can see a second loaf is only $8.
It cannot cap an item across orders
This is the expensive one. Response validation caps a single order; the 2026 response limit closes the whole form after a set number of submissions. Neither knows how many croissants have been claimed in total. If you can make forty and the form is open, forty-one people can order them, and you find out on the morning.
The usual answer is an add-on that removes choices once a quota is hit. It roughly works — but you are now maintaining a third-party script on a free tool to get the behaviour an order form most needs.
There are no order numbers
A response has a timestamp and a row position. That is all. When a customer says "I definitely ordered two", you search a spreadsheet by name and hope there is only one Sarah. A sheet formula can generate a reference, and it still will not appear on the confirmation they already received.
It does not feel like ordering
Soft, and it matters. Your customer scrolls through eight text boxes typing numbers into them. No cart, no total, no sold-out state, no receipt with line items. It reads as a form you have been asked to fill in, because that is what it is, and some proportion of people close the tab. You never find out how many.
There is no payment step
Google Forms has never had native payments — no field, no gateway. If you need money at order time you send a payment link with your confirmation and reconcile by hand, or add a paid third-party integration. For a business collecting at pickup this is a non-issue; for one shipping goods it is a hard stop.
When to graduate, and to what
Four honest signals. Any one means the free tool now costs more than it saves:
- You have re-dragged the total formula more than twice.
- You have oversold something, or closed the form early out of nerves.
- A customer has asked what their order comes to and you had to work it out.
- You are spending Friday evening building a bake list out of a spreadsheet instead of prepping.
If only the totals bother you, keep Forms and get better at the spreadsheet — the Excel order form guide covers the formulas. If your customers live on Microsoft accounts, Microsoft Forms is the same shape of tool with different gaps. If you are ready for paid options, the Jotform alternatives roundup is an honest list rather than a sales page.
What to shop for is not more features. It is the four items above: a price beside every product, a cap that counts across all orders, an order number on every confirmation, and a page that reads like a shop rather than a questionnaire. That is the whole difference between a form and an order form.
