How to Create an Order Form in Google Forms (With Totals and Payment)

To create an order form in Google Forms, start a blank form at forms.google.com, add questions for the customer’s name and contact details, add a question for each product with a quantity, and finish with delivery details. Then link the form to a Google Sheet so every order lands in a spreadsheet where you can calculate totals. Google Forms can’t take payments or add up prices on its own, so you’ll handle those with a payment link and a sheet formula.

Here’s how to build the form, set it up to collect orders cleanly, and handle totals, payment and notifications.

Plan your order form

Before you build it, list what you need from each customer:

• Contact details: name, email address and phone number
• Products: item names, prices, sizes or colors, and quantities
• Delivery: pickup or shipping, address, and preferred date
• Payment: how they’ll pay, if you offer more than one option
• Notes: special requests or gift messages

Step 1: Create the form

1. Go to forms.google.com and sign in with your Google account.
2. Click Blank form, or open the Template gallery and look for an order request template to start from.
3. Click Untitled form and type a name, such as “Bakery Order Form.”
4. Add a description with your prices, ordering deadline, and pickup or shipping terms.

Step 2: Add customer information questions

1. Click the first question and change it to Short answer. Name it Full name and turn on Required.
2. Click the + (Add question) button to add Phone number as another Short answer question.
3. To collect email addresses automatically, open the Settings tab, expand Responses, and set Collect email addresses to Responder input (or Verified if your customers have Google accounts).

Step 3: Add your products

There are two good ways to list products, depending on how many you sell.

For a few products, add a question for each one with a quantity:

1. Add a question and name it after the product and price, such as “Chocolate chip cookies, $2 each.”
2. Set the type to Dropdown and add options 0, 1, 2, 3 and so on. Or use Short answer, click the three dots, choose Response validation, and set it to Number > Whole number.
3. Click the image icon next to the question to add a product photo.

For many products, use a Multiple choice grid. Put product names in the Rows and quantities (0, 1, 2, 3) in the Columns. Customers pick one quantity per product in a compact table.

For options such as size or color, add a Multiple choice question for single choices or Checkboxes for add-ons.

Step 4: Add delivery details with sections

1. Add a Multiple choice question called Pickup or delivery? with the options Pickup and Delivery.
2. Click the Add section icon to create a section for the shipping address, and add Short answer or Paragraph questions for the address.
3. Go back to the Pickup or delivery question, click the three dots, and choose Go to section based on answer. Send Delivery to the address section and Pickup to the next section or to Submit form.
4. Add a Date question for the requested pickup or delivery date, and a Paragraph question for notes.

Step 5: Set up confirmation, receipts and notifications

1. In Settings > Responses, turn on Send responders a copy of their response so customers get a copy of their order.
2. In Settings > Presentation, edit the Confirmation message. Thank the customer and include payment instructions or a payment link.
3. In the Responses tab, click the three dots and choose Get email notifications for new responses so you know when an order arrives.

Step 6: Send orders to Google Sheets and calculate totals

1. In the Responses tab, click Link to Sheets and create a new spreadsheet.
2. In the sheet, add a column to the right of the form responses called Total.
3. Enter a formula that multiplies each quantity column by its price, such as =C2*2+D2*3.5, and fill it down the column.

New orders are added to the sheet automatically. Keep your formula in its own column, because the form adds new responses as rows below the existing ones.

Step 7: Share the form

1. Click Send at the top right.
2. Click the link icon, check Shorten URL, and click Copy.
3. Share the link on your website, social media or by email. You can also turn it into a QR code for flyers.

When you want to stop taking orders, open the Responses tab and turn off Accepting responses.

Question types to use for an order form

Information	Question type
Name, phone	Short answer
Email	Collect email addresses setting
Quantity of one product	Dropdown or Short answer with number validation
Quantities of many products	Multiple choice grid
Size or color	Multiple choice
Add-ons	Checkboxes
Delivery date	Date
Address or notes	Paragraph

Related: get notified when a Google Form is submitted.

Related: make a QR code for a Google Form.

Frequently asked questions

Can Google Forms calculate an order total?

Not inside the form. Link the form to Google Sheets and use a formula to calculate totals, or use a Google Forms add-on that adds calculations.

Can customers pay through Google Forms?

No. Google Forms doesn’t process payments. Put a payment link, such as a PayPal, Square or Stripe payment page, in the confirmation message or description.

Can I limit how many of a product people can order?

You can limit each person’s quantity with dropdown options or number validation. Google Forms can’t track inventory across all orders on its own, so watch your sheet and remove an option when it sells out.

Can customers edit their order after submitting?

Yes, if you turn on Allow response editing in Settings > Responses. Customers get a link to edit their response after they submit.