Order Form with Google Forms: Template + Payment Options

Updated July 2026 · 8 min read

A Google Forms order form is the duct tape of small commerce — and that's a compliment. Bakers take cookie preorders with it, PTAs sell spirit wear, coffee roasters run monthly bean drops, youth teams collect uniform orders. It's free, customers don't need an account to fill it out, and every order lands in a spreadsheet the moment it's submitted. This guide gives you a complete question template, the honest truth about payments, and the Sheet formulas that turn a pile of responses into a tally you can actually pack orders from.

The order form template, question by question

Here's a structure that works for almost any small order form. Adapt the items and wording, but keep the order — item selection first, logistics second, contact last.

1. Item selection

You have two good options, and the right one depends on whether customers order one thing or several:

• Checkboxes — best when people can order multiple items. One question: "What would you like to order?" with each option listing the item and its price: "Chocolate chip cookies — $6/dozen", "Banana bread loaf — $8", "Cinnamon rolls (4-pack) — $10". Putting prices in the option text means nobody has to email you to ask.
• Dropdown — best when there's a long list and customers pick exactly one, like a t-shirt design or a meal choice. Dropdowns stay compact on phones even with 20 options.

If items have variants (sizes, flavors), give each variant its own option — "T-shirt, Medium — $15" and "T-shirt, Large — $15" — rather than adding a separate size question. It keeps each Sheet column unambiguous when you're counting what to make.

2. Quantities

Checkboxes tell you what someone wants but not how many. Add a quantity question per item:

• Use a dropdown with 0–10 as the options if you want zero typing and clean data, or
• Use a short answer question with response validation (three-dot menu on the question → Response validation → Number → Whole number) so nobody types "a couple".

Make quantity questions not required, so a customer who skips an item can skip its quantity. If your menu is long, group each item's quantity questions into a section so the form doesn't feel endless.

3. Pickup or delivery

A required multiple choice question: "How will you get your order?" with options like Pickup at the Saturday market, Pickup at the shop, or Local delivery ($5, within 5 miles). Follow it with:

• A date or multiple choice time-slot question for pickup windows, and
• A paragraph question for the delivery address — mark it optional and note "delivery orders only" in the description.

If pickup and delivery have genuinely different follow-up questions, use sections with "Go to section based on answer" so each customer only sees what applies to them.

4. Contact details

Required short answer questions for name and phone number, and turn on email collection in Settings → Responses so you always have a way to reach the buyer. A final optional paragraph question — "Anything else we should know? (allergies, gift note, etc.)" — catches everything you didn't think to ask.

The big caveat: Google Forms does not take payments

Let's be direct, because plenty of tutorials bury this: Google Forms has no payment processing. There's no checkout step, no card field, no official Google payment integration. Your form collects the order; the money moves somewhere else. Three workarounds cover nearly every real situation:

Option 1: Pay on pickup or delivery

The simplest and most common for bake sales, farm stands, and local preorders. State it clearly in the form description ("Payment due at pickup — cash, card, or Venmo accepted") so nobody is surprised. The downside is no-shows: someone who hasn't paid has less skin in the game, so for high-effort items consider requiring a confirmation reply before you start baking.

Option 2: A payment link in the confirmation message

Google Forms lets you customize what people see after they submit. Go to Settings → Presentation → Confirmation message and write something like:

"Thanks for your order! Please send your total to paypal.me/YourName or @YourName on Venmo within 24 hours, and put your name in the payment note. Orders are confirmed once payment arrives."

The confirmation message doesn't render clickable links in all contexts, so keep the address short and typeable. This approach works well for merch drops and preorders where you want money up front — just cross-check payments received against the response Sheet before the pickup date.

Option 3: Invoice later

For larger orders — catering, team uniforms, wholesale — take the order through the form, calculate the exact total in your Sheet (delivery fees, discounts, and all), then send a proper invoice from PayPal, Square, Wave, or whatever you already use. Slower, but you invoice the correct amount instead of hoping the customer did the math right.

Calculating totals in the linked Sheet

Open your form's Responses tab and tap the Sheets icon to link a spreadsheet. Every submission becomes a row, with an automatic timestamp in column A and one column per question. That structure makes totals a one-formula job.

Say column C is "Chocolate chip cookies quantity" ($6 each) and column D is "Banana bread quantity" ($8 each). In the first empty column, row 2, add:

=C2*6 + D2*8

Drag the formula down (or wrap it so it handles blanks: =N(C2)*6 + N(D2)*8, since skipped questions arrive empty, not zero). New responses append as new rows — just extend the formula as orders come in, or pre-fill it down a few hundred rows.

Two more formulas earn their keep on order day:

• How many of each item to make: =SUM(C2:C) at the top of a summary area totals every cookie ordered.
• Orders per pickup slot: =COUNTIF(F2:F, "Saturday 10–11am") tells you how busy each window will be.

Keep formulas out of the response columns themselves — put them in extra columns to the right or on a second sheet, so incoming responses never overwrite your math.

Where Google Forms order forms shine (and where they don't)

Great fits:

• Bake sales and food preorders — a weekend of orders, one pickup day, cash at the table.
• Merch and spirit-wear drops — a two-week order window, then one bulk order to the printer, sized exactly from the Sheet totals.
• CSA boxes, farm stands, holiday pies — recurring preorder cycles where you duplicate last month's form in seconds.
• Team and club orders — uniforms, banquet meals, fundraiser goods, where the organizer collects payment separately anyway.

Poor fits: anything needing live inventory (Forms won't stop taking orders when you sell out — you close the form manually), card checkout in the same flow, shipping rates, or tax calculation. If that's your business, you've graduated to Shopify, Square Online, or similar. For everything before that point, a free form and a spreadsheet are honestly hard to beat.

Running it all from your phone

Order forms are a phone-native workflow: you're at the market when someone asks "can I preorder for next week?", or you're boxing orders and need to check who chose the 10am slot. But Google never made a Forms mobile app, and the browser editor fights you on a small screen. FormMaker gives you a native touch editor that creates real Google Forms through your own Google account — build the form, share the link or a QR code, and check responses from wherever the orders find you.

FAQ

Related guides

• How to make a sign-up sheet with Google Forms
• Event registration with Google Forms
• How to view Google Forms responses on your phone