Blog·October 22, 2026·10 min read
Google Form Order Form for Facebook and WhatsApp Sellers
By Meer Estiyak, founder of Kommercly
Short answer: yes, a Google Form works as a free order form. Ask for the name, an 11-digit phone number, the delivery area, the full address, the product, the size and the quantity, and link the form to a Google Sheet so each order becomes one row. The form cannot show photos in a dropdown, work out a total or check stock, so it suits a small range and a few orders a day.
This guide builds the form for cash on delivery sellers, with the exact fields, a phone number check and a sheet formula for the total. Then it covers the WhatsApp version, and the signs that you have outgrown both. We checked every Google Forms and WhatsApp step on their own help pages on 2 October 2026. If a button has moved, look for the nearest match.
Can you take orders with a Google Form?
Yes, and it solves a real problem. Without a form, one order often takes ten Messenger messages: the name, then the phone number, then the address, then "which size?". A form asks all of it once, in the same order every time, and saves the answers in a sheet you can sort.
A form is a good fit when:
- You sell a small range, say up to 15 or 20 products, that customers can pick from a list.
- Your posts already show the photo and price, so the form only collects details.
- You take a handful of orders a day and confirm each one by phone or WhatsApp.
- You take bookings or pre-orders, such as cake orders or tailoring slots.
How do you make a Google Form order form, step by step?
- Create the form. Go to forms.google.com while signed in to the Google account for your shop, and start a blank form. Name it after your shop, for example "Nodi Fashion order form".
- Write a short description. Two lines: what happens after the customer sends the form, and your delivery charges. For example: "We will call or WhatsApp you to confirm before we send the parcel. Delivery: Inside Dhaka ৳70, Outside Dhaka ৳130." Use your own charges.
- Add the questions from the table in the next section, in the same order. Turn on Required for every question that the courier needs.
- Add the checks. On a question, open the More menu (three dots), choose Response validation, then pick a rule. Google's help page lists four kinds for short answers: Number, Text, Length and Regular expression. Each rule can show your own error text.
- Link a sheet. Open the Responses tab, click More (three dots), then Select destination for responses, and create a new spreadsheet. Every order now lands as a new row.
- Turn on email alerts. On the Responses tab, click More, then Get email notifications for new responses. Your phone's Gmail app will then tell you when an order comes in.
- Test it. Fill in the form from another phone, with a wrong phone number first, to see the error message work. Then delete the test row.
- Publish and share the link. Google's help page says an unpublished form cannot be opened by customers, even with the link. Click Publish at the top right. Click Manage first if you want to check who can respond. Once it is published, click Published, then Copy responder link. Put the link in your Facebook page button, your post captions, your Instagram bio and your WhatsApp quick replies.
When you run out of stock, or close for Eid, you can stop the form. Google's help page says to click Published, then turn off Accepting responses, and you can write the message customers see instead.
Which fields does a cash on delivery order form need?
These are the fields a Bangladeshi courier booking needs, plus two that cut down fake orders. Keep it to this. Every extra question loses some customers.
| Question | Type | Required | Check or options |
|---|---|---|---|
| Your name | Short answer | Yes | Length: at least 3 characters |
| Mobile number | Short answer | Yes | Regular expression, Matches: ^01[3-9][0-9]{8}$. Error text: "Write your 11-digit number in English digits, like 01712345678" |
| WhatsApp number, if different | Short answer | No | Same check as above |
| Delivery area | Multiple choice | Yes | "Inside Dhaka (৳70)", "Outside Dhaka (৳130)", with your own charges in the text |
| Full address | Paragraph | Yes | Length: at least 15 characters. Description: "House, road, area, thana, district" |
| Product | Dropdown | Yes | One option per product, with its price: "Cotton kurti, green, ৳1,250" |
| Size | Multiple choice | Yes, for clothes | S, M, L, XL. Link your size chart in the question description |
| Quantity | Short answer | Yes | Number, between 1 and 10 |
| How will you pay? | Multiple choice | Yes | "Cash on delivery", "Delivery charge first by bKash or Nagad, rest on delivery" |
| Note for us | Paragraph | No | Gift wrap, a time to call, a landmark |
| Confirm | Checkboxes | Yes | "I will receive the parcel and pay on delivery. The shop will call me first." |
The phone pattern accepts 11 digits that start with 013 to 019, which covers Bangladeshi mobile numbers. It stops typing mistakes, such as a missing digit. It also rejects a number typed with +880 in front, or typed in Bangla digits (০১৭...), so say "in English digits" in the error text if your customers use a Bangla keyboard. It cannot tell you whether the person is serious, so still confirm every order before you book the courier. Our guide to COD, bKash advance and fake orders covers when to ask for the delivery charge first.
Do not ask for an NID number, a bKash PIN or card details. A courier booking does not need them.
How do you add quantity and price to a Google Form?
Quantity is easy: a Short answer question with a Number rule between 1 and 10, as in the table. A Dropdown with 1 to 5 also works and is faster to tap.
Price is harder. Google Forms has no price field and no total. The usual way is to write the price inside the option text, as in "Cotton kurti, green, ৳1,250", and the delivery charge inside the area option. The customer sees the prices, but adds them up in their head.
You can work out the total for yourself in the linked sheet:
- In the response spreadsheet, add a tab called Prices. In column A, paste each product option exactly as it is written in the form. In column B, write its price as a plain number, such as 1250.
- Add a tab called Delivery. In column A, paste each delivery area option exactly as in the form. In column B, write the charge, such as 70.
- On the responses tab, find the first empty column. With the questions in the order of the table above, the timestamp is in A, the delivery area in E, the product in G and the quantity in I, so the first empty column is M. Change the letters to match your own sheet. Paste this in cell M1:
={"Total"; ARRAYFORMULA(IF(A2:A="", "", IFERROR(VLOOKUP(G2:G, Prices!A:B, 2, FALSE), 0) * I2:I + IFERROR(VLOOKUP(E2:E, Delivery!A:B, 2, FALSE), 0)))}
Because the formula sits in the header row, it fills in the total for every new order. If a total shows only the delivery charge, the product text in Prices does not match the form option exactly.
For more than one product per order, you can split the form into sections and send the customer to the next section based on an answer, such as "Add another product?". It works, but the form gets long.
Where does a Google Form order form fall short?
Be clear about these before you build your shop around a form:
- No total before sending. The customer never sees "৳1,250 + ৳70 = ৳1,320" on the form. Some will be surprised when you call to confirm.
- Photos only in short lists. Google's help page says you can add an image to each answer in a Multiple choice or Checkboxes question, but not in a Dropdown. With more than a few products, a list of photos gets long on a phone, and customers go back to your page to check which green kurti is which.
- No stock. The form keeps taking orders for an item you sold out of yesterday, until you edit the options by hand.
- One price per option. If XL costs more than M, you need a separate option for each, and the list grows fast.
- No order status. The sheet is a list of rows. You add your own column for Confirmed, Shipped and Delivered, and keep it updated.
- No chat thread. After sending the form, there is no chat with the customer until you start one.
To keep a stock count next to the form, our guide to inventory management in Google Sheets shows a sheet with formulas that lower the count for each order you write in.
What is a WhatsApp order form, and how is it different?
A WhatsApp order form is usually just a link that opens a chat with your number, with the order questions already typed. WhatsApp calls this click to chat. Its help page says to use https://wa.me/<number> with the full number in international format, without zeros, brackets or dashes, and to add ?text= with the message, URL-encoded.
For a Bangladeshi number, a ready-to-use link looks like this, with your own number in place of the Xs:
https://wa.me/8801XXXXXXXXX?text=Order%0AName%3A%20%0APhone%3A%20%0AFull%20address%3A%20%0AProduct%20and%20size%3A%20%0AQuantity%3A%20
In that link, %0A is a new line, %3A is a colon and %20 is a space. When the customer taps it, the chat opens with this text, ready to fill in:
Order
Name:
Phone:
Full address:
Product and size:
Quantity:
| Google Form | WhatsApp order link | |
|---|---|---|
| Cost | Free | Free |
| Checks the phone number | Yes, with validation | No |
| Saves orders in a sheet | Yes, by itself | No, you copy them by hand |
| Starts a chat with the customer | No | Yes |
| Shows the total | No | No |
You can use both: the WhatsApp link for regular customers who like to chat, and the form for new customers coming from a boosted post. Our guide to selling on WhatsApp in Bangladesh covers the full order conversation after the first message.
For what to send once the order arrives, copy from our order confirmation message templates.
When should you switch from a form to a store link?
Keep the form if you take a few orders a week, or you sell a service or bookings. Look for something else when:
- Customers keep asking for the total before they fill in the form.
- You spend time each day fixing orders for sold-out items.
- Your product list no longer fits in one dropdown that people can read on a phone.
- You sell sizes or weights at different prices.
A store link solves those four, because the customer picks from photos and sees the total with delivery before ordering. Kommercly, which we make, is one such store. As of October 2026, you add products from your phone, with sizes that each have their own price, and set your delivery areas and charges. The customer sees the total with delivery, and the order then opens in WhatsApp written out with the items, the area, the address and the total. Every order is also saved on an Orders page, where you mark it Confirmed, Shipped or Delivered.
It is not the right tool for everyone. It does not hold your money. You take cash on delivery or a bKash or Nagad advance (Premium), and you check the TrxID yourself. It does not book couriers. The free plan takes 0% commission and holds up to 20 products. If you take bookings or a few custom orders, the form above is simpler and costs nothing. The store setup guide shows the phone and sheet setup, and our post on creating a free WhatsApp store compares it with other options.
Quick answers
Can I take orders with a Google Form for free?
Yes. Google Forms is free with a Google account. You add questions for the name, phone number, address, product, size and quantity, then share the form link on your Facebook page or in WhatsApp. Each order arrives as a new row in a linked Google Sheet, and Google can email you when a new response comes in.
How do I add quantity to a Google Form order form?
Add a Short answer question called Quantity. Open its More menu, turn on Response validation, choose Number and set it between 1 and a sensible maximum, such as 10. Then a customer cannot type a word or a zero. If you only sell small amounts, a Dropdown with 1 to 5 is even quicker for the customer to fill in.
Can a Google Form calculate the total price?
Not on the form. Google Forms has no price or total field, so the customer does not see a total before sending the order. You can work out the total in the linked Google Sheet with a formula that looks up the product price and the delivery charge. Then send the total to the customer when you confirm the order.
How do I check that a customer typed a real phone number?
Use Response validation with a regular expression. For Bangladeshi mobile numbers, the pattern ^01[3-9][0-9]{8}$ accepts only 11 digits that start with 013 to 019. It rejects +880 in front and Bangla digits, so add custom error text such as "Write your 11-digit number in English digits, like 01712345678". This stops typing mistakes, but it cannot tell you if the number is fake. Call or message to confirm.
What is a WhatsApp order form?
Usually it is a click-to-chat link with a pre-filled message, such as wa.me/8801XXXXXXXXX followed by ?text= and the order questions. When the customer taps it, WhatsApp opens a chat with you and the questions already typed. The customer fills in the blanks and taps Send. It is free, but nothing checks the answers.
Sources, checked 2 October 2026: Google Docs Editors Help pages "Create a form" question types, "Set rules for your form" (response validation), "Choose where to save form responses", "View & manage form responses", "Publish & share your form with responders" and the page on adding images to a form (support.google.com/docs); WhatsApp Help Center, "How to use click to chat" (faq.whatsapp.com). Delivery charges in the examples are examples only. See our courier charges comparison for real rates.
Make your store from your phone. Orders come to your WhatsApp.
Free plan, no card, no code. Add your first product with a photo from your phone.
Create Free StoreSee live stores made with Kommercly:Dobby (opens in a new tab)Stellify (opens in a new tab)
