Guides

How to Use Google Forms for Orders, and Where It Stops Working

How to use Google Forms for orders: the questions to ask, the right question types, a confirmation message, a linked sheet, and the limits to plan for.

Ashish Vijay

9 min read

A freelancer sorting printed photo proofs on a studio table

Short answer: to use Google Forms for orders, build a short form that asks for the customer’s contact details and the item. Also ask for the options, the quantity and the date they need it. Link the form to a Google Sheet and turn on email alerts for new responses. Treat every response as a request, then confirm the price, the deposit and the date with the customer yourself. Google Forms cannot take payments, add up a total or track stock, so plan for those parts outside the form.

Google Forms is free, most people already know it, and it takes ten minutes to set up. That is why so many small sellers use it for order requests, pre-orders and holiday drops. A baker sends a link for Thanksgiving pies. A tailor puts a form in their Instagram bio for alterations. A candle maker collects pre-orders for a winter scent.

Most guides show you how to build the form and then stop. Many of them are written by companies that sell a paid form builder, so they rush to the limits. This guide does both parts honestly. It covers the questions to ask and the question types to use. It also covers the message customers see after they send it, and how to run the sheet. It also covers the point where a form stops being enough.

1. Decide what the form must collect

Start with a list, not with the form. Write down every question you ask a customer before you can say yes to an order. For most custom or made-to-order work, the list looks like this:

  • Name and a way to reach them. A phone number, an email address, or both.
  • What they want. The item, plus the options: size, color, flavor, wording or style.
  • How many. A quantity for each item.
  • When they need it. The date of the event, or the date they want to collect it.
  • Pickup or delivery. And the address, but only if they choose delivery.
  • Anything else. A notes box for allergies, names to write on the item or special requests.

Then cut every question you do not need. A short form gets finished, and a long one gets abandoned. Short forms are also safer. The FTC’s guide for businesses tells you to keep only the personal information you need. If you do not need a birthday or a home address, do not ask for it.

2. Build it with the right question types

Go to forms.google.com and start a blank form. Give it a clear title, such as “Holiday pie order request”. Then add your questions using the type that fits each one. The right type keeps answers clean, so you are not decoding messy text later.

Google's question types and rules, as listed in Google Docs Editors Help (checked October 2026).
What you askQuestion typeTip
NameShort answerMake it required
Phone or emailShort answerAdd a Text rule so an email answer must be in email format
Item and optionsMultiple choice, dropdown or checkboxesPut the price in each option, like "Apple pie, $28"
QuantityShort answerAdd a Number rule, such as between 1 and 6
Date neededDateSay your lead time in the question, like "at least 7 days from today"
Pickup or deliveryMultiple choiceSend delivery answers to an address section
NotesParagraphAsk about allergies or wording here

Three settings do most of the work.

Rules for answers. Google calls this response validation. A Number rule stops a customer from typing “a few” in the quantity box. A checkbox rule can limit how many options someone picks, which helps when a box of cookies holds three flavors.

Sections for pickup and delivery. Put the address questions in their own section. Then use “Go to section based on answer” on the pickup or delivery question. Customers who choose pickup skip the address page entirely. Google says this works only on multiple choice and dropdown questions.

Required questions. Mark the questions you cannot work without as required. Leave the notes box optional.

Be careful with file uploads. You may want customers to send a reference photo. But Google says responders must sign in to a Google Account to answer a file upload question. Many customers will give up at that step. Ask for photos in a message after they send the form instead.

When the form is ready, publish it and copy the responder link. Check the box for “Shorten URL” to get a short link. It fits in an Instagram bio or a WhatsApp message. You can also embed the form on your website.

3. Say what happens after they send it

Google Forms shows a short default message after a customer submits. Change it in Settings, under Presentation, next to “Confirmation message”. This message is your chance to say clearly that the order is not confirmed yet.

Confirmation message (illustrative)

Thank you. We have your order request.

This is not a confirmed order yet. We will message you within one day with the price, the deposit and the pickup date. Your order is confirmed when you pay the deposit.

If you have a reference photo, please send it to us on WhatsApp or by email.

That one message prevents the most common problem with form orders. A customer fills in the form, hears nothing and assumes the cake is booked. Then you have no space that week, and they find out on the day.

Google can also email the customer a copy of their answers. Turn on email collection first, then set “Send responders a copy of their response”. Google warns that these copies can be caught by spam filters. So do not rely on them as the customer’s only record.

4. Send every response to a sheet

Open the Responses tab and link the form to a Google Sheet. From then on, each response becomes one row. Next, open the More menu on the Responses tab and turn on email notifications for new responses. You will know when a request arrives without checking the form.

The form only fills in the customer’s answers. You need a few columns of your own to the right of them. Add these:

  • Status. For example: new, confirmed, in progress, ready, collected.
  • Price. The final price you agreed.
  • Paid. What the customer has paid so far, and when.
  • Balance. What they still owe.
  • Due date. The date you agreed, which may differ from the date they asked for.

Sort the sheet by due date every morning. That one habit catches most missed deadlines. Our free order tracker template has these columns ready if you would rather not build them.

Orders stay open for a while, so the sheet matters. In WISMO’s order data, the median order had 7 days between the day it was created and its due date.

7 days

median time from order creation to due date731 orders from 155 sellers, March–October 2026

That is a week in which you need to know what was promised, what was paid and what is still owed.

5. Limit orders and close the form on time

Pre-orders and holiday orders need a cut-off. Since January 2026, Google Forms can close itself at a date and time you choose. It can also close after a set number of responses. The setting is off by default, so you turn it on after you publish the form.

Use a response limit when you can only make a fixed number. But read Google’s warning first. If several people send the form at the same moment, the form accepts them all, even past the limit. So set the limit a little below your real capacity. Leave a few spare places for a late friend or a mistake.

A response limit counts forms, not items. If one customer orders six pies, it still counts as one response. If your limit is in items, check the quantity column in your sheet each day. Close the form by hand when the total gets close. Our guide to holiday order cut-off dates helps you choose the closing date.

6. Take payment outside the form

Google’s list of question types has no payment question. A plain Google Form cannot charge a card or collect a deposit. It also has no way to add up a total, so the customer never sees one.

Most sellers handle this in two steps:

  1. Confirm first. Read the request, check your calendar and reply with the exact total, the deposit and the date.
  2. Then ask for the deposit. Send it by the payment method you already use. The order is booked when the deposit arrives.

This order of steps is a good thing for custom work. You never take money for an order you cannot make. Not sure how much to ask for? Our guide to deposits for custom orders shows how to work it out. Send your terms for custom orders with the confirmation, too.

Some third-party add-ons claim to add payments or totals to Google Forms. They may work for you. But each one adds a fee, an account and another company with your customers’ data. Read the add-on’s reviews and pricing before you connect it. If you need payments or totals in the form itself, compare free order form tools that include them.

Where Google Forms stops working

Google Forms is very good at one job: collecting the same answers from every customer in a tidy list. It is not built for what happens after the order. These signs mean you have outgrown it:

  • You keep orders in two places. The form has the request. The price, the changes and the payments live in your messages.
  • You copy rows into another list. You move confirmed orders to a notebook or a second sheet. The response sheet is full of requests you said no to.
  • Customers keep asking “is it ready yet?” The form gives them no way to check on their order. So every update is a message from you.
  • You lose track of what is owed. The sheet shows who asked for an order. It does not easily show who paid the deposit and who still owes money.
  • Orders also come in by message. Regular customers skip the form, so half your orders never reach the sheet.

None of this means the form was a mistake. It means the order list needs to live somewhere built for orders. You can keep the form as the front door and move confirmed orders into that list.

How WISMO does this

WISMO is an order tracker for your phone. It can replace the form, or it can sit behind it.

A free store page instead of a form. WISMO’s store page is free on every plan. Your page lives at an address like yourshop.wismo.live. Customers see your items with photos and prices, choose what they want and send you a request. WISMO calls it an enquiry. Like a good form, nothing is booked yet. You accept or decline, and you set the due date yourself.

One list for every order. When you accept an enquiry, it becomes an order. You can add any order by hand. So orders from WhatsApp, Instagram, calls or a Google Form share one list. Each order has its due date, its status and a record of every payment. You see the balance at a glance. You get a reminder the morning before an order is due.

A tracking link for the customer. Every order gets a link. The customer opens it on any phone, with no app and no sign-up. They see the status and what they have paid, so they do not need to message you to ask. In WISMO’s data, customers who opened their link opened it a median of 5 times before the order finished.

Median 5 opens

tracking link opens per order, among orders whose link was opened262 orders from 96 sellers, March–October 2026

WISMO does not take payments and has no checkout. You still collect money the way you do now and record it on the order. Your first 30 orders are free, and an accepted enquiry counts as an order. Pro costs $9.99 a month or $99.99 a year, and the yearly plan saves over 15%. Pro gives you unlimited orders and removes the “Powered by WISMO” line. You can try Pro free for 7 days.

If a Google Form and one sheet keep you on top of every order, keep using them. They are free and they work. Our comparison of spreadsheets and order apps can help you decide when to switch.

The short version

Keep the form short. Use the right question types, and put prices in the options. Tell customers clearly that a request is not a confirmed order. Link the form to a sheet, add your own status and payment columns, and sort by due date every day. Set a closing date for pre-orders, and keep the response limit a little below your capacity. Take payment outside the form, after you confirm.

Do orders live in two places, or do customers keep asking for updates? Then move your confirmed orders into one list built for orders. Do you take orders in chat as well? Read how to take orders on Instagram and how to take orders on WhatsApp.

Common questions

Can you use Google Forms to take orders?

Yes. Google Forms works well as a free order request form. Customers answer your questions, and every answer can go into a linked Google Sheet. Treat each response as a request, not a confirmed order. You still confirm the price, the date and the deposit with the customer yourself.

Can Google Forms take payments?

No. Google's list of question types has no payment or price question, so a plain Google Form cannot charge a card. Most sellers confirm the order first and then send a payment request the way they already take money. Some third-party add-ons offer payments, but check their fees and reviews before you rely on one.

Can Google Forms calculate an order total?

Not on its own. Google Forms has no question type that adds up prices, so the customer never sees a total. Put prices next to each option so the customer has an idea of the cost. Then send the exact total yourself when you confirm the order.

How do I stop a Google Form from taking too many orders?

Google Forms can now close itself at a date and time, or after a set number of responses. The setting is off by default, so you turn it on after you publish the form. Google also says that responses sent at exactly the same moment can go over the limit. So set the limit slightly below what you can make.

Where do Google Form orders go?

Every response appears in the form's Responses tab. You can also link the form to a Google Sheet, where each order becomes one row. Turn on email notifications for new responses so you know when a request arrives. Add your own columns to the sheet for the status, the price and what the customer has paid.

Should customers upload photos in a Google Form?

Only if your customers all have Google accounts. Google says responders must sign in to a Google Account to answer a file upload question, and many customers will stop there. It is often easier to ask for reference photos in a message after the customer sends the form.

Sources

  1. Google Docs Editors Help: Choose a type of question for your form (checked October 2026)
  2. Google Docs Editors Help: Show questions based on answers (checked October 2026)
  3. Google Docs Editors Help: Set rules for your form (checked October 2026)
  4. Google Docs Editors Help: Choose where to save form responses (checked October 2026)
  5. Google Docs Editors Help: Publish and share your form with responders (checked October 2026)
  6. Google Docs Editors Help: Edit and format a form or quiz, settings for responses (checked October 2026)
  7. Google Workspace Updates: Automatically stop collecting responses in Google Forms (January 2026)
  8. FTC: Protecting Personal Information, A Guide for Business (checked October 2026)
  9. WISMO order data: 731 orders from 155 sellers, March–October 2026

About the author

Ashish Vijay is the founder of WISMO, an order management app for small sellers and independent makers. He builds the product, talks to the sellers who use it, and writes these guides from what that work turns up.