A baker in Abuja gets forty cake enquiries a week on WhatsApp. Half arrive as voice notes, a quarter forget the delivery date, and nobody states the flavour. She spends an hour each evening asking the same five questions again. A simple order form fixes most of that, and it costs nothing but a free afternoon to set up.
This guide shows how to build an order form with Google Forms, send the answers into a Google Sheet, and add a few checks so the data stays clean. It also works as a paid service you can set up for other small businesses. No coding is needed, and you can do most of it on a phone, though a laptop makes the sheet part easier.
When a form beats a WhatsApp chat (and when it doesn't)
A form works best when your orders always need the same details: name, phone number, item, quantity, delivery area, date. It forces the customer to give everything in one go, so you stop chasing.
It works less well for custom work where every order is a long conversation, such as bespoke tailoring with measurements discussed over days. In that case, use the form only for the first step: contact details, what they want, and budget. Then continue on chat.
Also consider your customers. Many will happily tap a link. Some older customers prefer a call. Keep WhatsApp open as a second route and don't force everyone through the form.
Step 1: Plan the questions on paper first
Before opening anything, write down the columns you would want in a perfect sales sheet. Every form question becomes one column, so planning here saves cleanup later.
A typical list for a food or retail seller:
- Customer name
- Phone number (the one on WhatsApp)
- Product (a dropdown, not free text)
- Quantity
- Delivery or pickup
- Delivery area or address
- Date needed
- Notes (allergies, writing on cake, colour)
Keep it short. Every extra question costs you completed orders, especially on slow mobile data. If you won't use an answer, don't ask for it.
Step 2: Build the form
- Sign in to a Google account and open Google Forms. Start a blank form.
- Give it a clear title, such as "Place your order – [Business name]". Add one line telling customers when you reply.
- Add each question from your list. Use the question types deliberately (see the table below).
- Mark the essential questions as required: name, phone, product, quantity, date.
- Preview the form on your own phone and fill it in as a customer would. If it feels tiring, cut questions.
Which question type to use
| Information | Question type | Why |
|---|---|---|
| Product | Dropdown or multiple choice | Customers can't misspell names, so your sheet stays consistent |
| Quantity | Short answer with a number rule | Blocks "a few" or "two dozen-ish" answers |
| Phone number | Short answer with a text rule or pattern | Catches missing digits |
| Date needed | Date | Avoids "next Friday" confusion |
| Delivery area | Dropdown of areas you serve | Stops orders you can't deliver to |
| Special requests | Paragraph (optional) | Captures detail without cluttering the other columns |
Look through the settings for each question for response validation. A number rule or a length rule on the phone question is a small step that prevents many bad entries. Check what your version of Forms offers, since menus change.
Step 3: Send answers into a Google Sheet
In the Responses tab of the form, there is an option to link to Sheets. Choose to create a new spreadsheet. From then on, every submitted order becomes a new row, with a timestamp in the first column.
Do not type over the raw responses tab. Treat it as an inbox. Build your working sheet in a separate tab that pulls from it, or copy new rows across. Editing the raw tab directly can cause trouble when you later change the form.
Step 4: Add columns that make it useful
To the right of the form columns, add your own. These are not filled by customers:
- Status: New, Confirmed, Paid, Delivered, Cancelled. Use a dropdown (data validation) so spelling stays the same.
- Price: either typed in or looked up from a small price list tab.
- Amount paid: so you can see balances.
- Balance: a formula, price minus amount paid.
Then add a filter and a simple conditional format: highlight rows where Status is "New" so you see what needs a reply. If you want a view of just today's deliveries, create a filter on the date column.
Worked example (hypothetical)
Say a small snack seller in Lagos sells three items: chin chin boxes at ₦3,500, peanut packs at ₦1,500, and zobo bottles at ₦1,000. On a Thursday, five orders come in through the form:
- Order 1: 2 chin chin = ₦7,000
- Order 2: 4 zobo + 1 peanut = ₦4,000 + ₦1,500 = ₦5,500
- Order 3: 1 chin chin = ₦3,500
- Order 4: 3 peanut = ₦4,500
- Order 5: 2 chin chin + 2 zobo = ₦7,000 + ₦2,000 = ₦9,000
Total: ₦29,500. Because the product column came from a dropdown, a SUMIF or a filter on "chin chin" gives total boxes to bake: 5. Without the form, the seller would be scrolling chats to count. These figures are invented to show the method, so use your own prices.
If the form allows one product per question, either allow customers to submit twice, or add a separate quantity question per product ("Chin chin boxes: 0, 1, 2..."). The second option gives one row per order, which is easier to total.
Step 5: Share the link where customers already are
- Put the link in your WhatsApp Business profile, status, and Instagram bio. Shorten it only with a link tool you trust.
- Keep one auto-reply or saved message: "Please place orders here: [link]. I confirm within X hours."
- Print a QR code on packaging or a shop counter if you have walk-in customers. Check that it scans before printing.
In the form's settings you can ask Google to send customers a copy of their answers, which works as a basic receipt. It needs their email, so only use it if your customers have emails.
Step 6: Set up alerts so you don't miss orders
A form is useless if orders sit unseen. In the Responses area, look for the option to get email notifications for new responses. On the sheet, there are notification rules for changes too. Test with a dummy order and see how long the alert takes.
Power cuts and patchy data make it worth checking the sheet at fixed times. Two scheduled checks, say 10am and 4pm, are better than "whenever I remember".
Step 7: Connect it to the rest of your records
Once orders are tidy, other tasks become easier. You can match payments against the Paid column using the method in Reconcile Mobile Money and Bank Transfers With Your Sales Sheet. If you sell physical goods, reduce stock after each confirmed order with the approach in Build a Simple Stock Tracker in Google Sheets for a Small Shop. And if some customers still send orders by chat, Turn a Messy WhatsApp Order List Into a Clean Sales Report shows how to bring them into the same sheet.
An AI chat tool can help with one part: if you paste a few anonymised example orders, it can suggest formulas or a column layout. Don't paste real customer names or phone numbers into it.
Common mistakes
- Asking too much. Ten required questions on a phone screen loses customers. Start with six.
- Free-text product names. "Chinchin", "chin-chin" and "Chin chin big" become three different products in a sheet. Use dropdowns.
- Changing the form carelessly. Renaming or deleting a question can shift or break columns in the linked sheet. Add questions at the end where possible and check the sheet after every edit.
- Collecting sensitive data you don't need. You don't need a BVN, NIN or card details for an order. Never ask for them. Take payment through a bank transfer or payment link, not a form field.
- Leaving the sheet shared with "anyone with the link". Your customers' phone numbers are in there. Share only with named people.
- Trusting a "paid" screenshot. Confirm money in your bank or wallet app before changing Status to Paid.
Turning this into paid work
Plenty of small sellers know they should organise orders but don't know how. You can offer a setup package: the form, the linked sheet, status dropdowns, and a half-hour walkthrough. Show a sample using fake data. For pricing logic, see How to Price a Spreadsheet Cleanup Job for a Small Business, and for finding the first client, the post on writing a short pitch message will help.
If you do this for a client, ask them to create the Google account and then share ownership or editing rights with you. That way they keep their data if you stop working together.
Frequently asked questions
Is Google Forms free?
It is available with a standard free Google account at the time of writing, but check Google's current terms, as plans can change.
Can customers fill it in offline?
No. They need an internet connection to submit. On slow data, a short form with few required fields loads and submits more reliably.
Can I accept payment through the form?
Treat the form as order collection only. Send a bank account or payment link after confirming the order, and verify the money yourself.
What if a customer submits the same order twice?
It happens when connections are slow. Sort by phone number and date, and delete or mark the duplicate as Cancelled. Don't delete rows without noting why.
Do I need AI for this?
No. The form and sheet do the main work. AI tools are optional helpers for formulas or wording, as long as you keep real customer data out of them.
Your next step
Write down the six questions you ask most often when a customer messages you. Build a form with only those, send it to two friends to test, and use it for your next ten orders before adding anything.
Results from any side hustle or online work vary widely, and nothing here is a promise of income. Be wary of anyone who asks you to pay upfront to start earning.