This isn’t a WooCommerce guide. It’s for a different situation — a seller who doesn’t have a website, or who has a website but takes custom orders via WhatsApp and wants a better way to capture them, or who runs a food or service business where customers order by filling out a form. The system built in this guide: a Google Form customers fill in → responses log to a Sheet → the customer gets an automatic confirmation email → you get an alert that a new order arrived.

Part 1: Build the Order Form

Go to forms.google.com → click the + (Blank form). Give it a title like “[Your Business Name] — Order Form.” Now add these fields:

Enable email collection in Settings

In your form: Settings tab → Responses → uncheck “Limit to 1 response” (unless you genuinely want that). More importantly, make sure you are not requiring customers to sign in with a Google account — most customers won’t have one. Keep “Restrict to users in [domain]” turned off.

Part 2: Connect to Google Sheets

Part 3: The Confirmation Email (Apps Script)

This is the part most guides skip or leave vague. Here is the actual script, explained line by line, so you understand what it does and can adapt it.

// Runs automatically every time someone submits the form
function onFormSubmit(e) {

  // --- EDIT these three lines ---
  var OWNER_EMAIL = "yourname@gmail.com";        // EDIT: your email
  var BUSINESS_NAME = "Abena's Kitchen";          // EDIT: your business name
  var WHATSAPP_NUMBER = "+233241234567";           // EDIT: your WhatsApp number
  // --- End of lines to edit ---

  // Pull the form response values
  var responses = e.namedValues;
  var customerName    = responses["Full Name"][0];
  var customerEmail   = responses["Email Address"][0];
  var customerPhone   = responses["Phone Number / WhatsApp"][0];
  var orderItem       = responses["What would you like to order?"][0];
  var quantity        = responses["Quantity"][0];
  var deliveryChoice  = responses["Delivery or Pickup?"][0];
  var deliveryAddress = responses["Delivery Address"] ?
                         responses["Delivery Address"][0] : "N/A (Pickup)";
  var notes           = responses["Special Instructions / Notes"] ?
                         responses["Special Instructions / Notes"][0] : "None";
  var timestamp       = new Date().toLocaleString("en-GH");

  // --- Email to the CUSTOMER ---
  var customerSubject = "Your order from " + BUSINESS_NAME + " is confirmed ✓";
  var customerBody =
    "Hi " + customerName + ",\n\n" +
    "Thank you for your order! Here's a summary:\n\n" +
    "Item:     " + orderItem + "\n" +
    "Quantity: " + quantity + "\n" +
    "Delivery: " + deliveryChoice + "\n" +
    "Address:  " + deliveryAddress + "\n\n" +
    "We'll be in touch to confirm payment and delivery details.\n" +
    "WhatsApp us anytime: " + WHATSAPP_NUMBER + "\n\n" +
    "Thank you,\n" + BUSINESS_NAME;

  MailApp.sendEmail(customerEmail, customerSubject, customerBody);

  // --- Alert email to YOU (the owner) ---
  var ownerSubject = "🛒 New Order — " + customerName + " — " + orderItem;
  var ownerBody =
    "New order received at " + timestamp + ":\n\n" +
    "Customer:  " + customerName + "\n" +
    "Email:     " + customerEmail + "\n" +
    "Phone:     " + customerPhone + "\n" +
    "Item:      " + orderItem + "\n" +
    "Quantity:  " + quantity + "\n" +
    "Delivery:  " + deliveryChoice + "\n" +
    "Address:   " + deliveryAddress + "\n" +
    "Notes:     " + notes + "\n\n" +
    "Open your order sheet to update the status.";

  MailApp.sendEmail(OWNER_EMAIL, ownerSubject, ownerBody);
}

Part 4: Add a Simple Stock Tracker

Once orders are logging to the Sheet, you can track how many of each item has been ordered with a formula — no additional setup required.

Create a second sheet tab in the same workbook (click + at the bottom left). Name it “Stock.” Set up two columns: Product and Units Ordered. List each of your products in column A. In column B, use COUNTIF to count how many times each product has been ordered from the form responses:

Sharing the Form with Customers

In Google Forms, click Send (top right) → click the link icon → copy the link. This is your order form URL. Put it everywhere:

• WhatsApp Business bio — the clickable website link in your profile
• WhatsApp Quick Reply — a shortcut that sends the form link when someone asks “how do I order?”
• Instagram bio — the single link slot, or via a link-in-bio page if you need multiple links
• WhatsApp Catalog item links — add the form URL as the “Link” field on your catalog items, so customers can go directly from a catalog product to the order form
• Your website — embed via Insert → Embed (Google Forms) → copy the iframe code → paste into your website’s HTML

Before vs After: A Full Order Scenario

What This System Can’t Do (And the Upgrade Path)

Common Mistakes to Avoid

Frequently Asked Questions

Do customers need a Google account to fill in the form?

No — and this is important to verify in your settings. Go to Google Forms Settings → Responses → make sure “Restrict to users in [your organization]” is turned off and “Require sign-in” is not enabled. With these off, anyone with the link can fill in the form without any Google account.

Can I collect payment through the form itself?

Google Forms doesn’t have a built-in payment collection step. The cleanest approach: in your form confirmation message, tell customers you’ll send a payment link shortly. Then manually send a Paystack or Flutterwave payment link to their email. The Make.com upgrade described above automates this — a new form submission triggers a Make.com scenario that generates and emails a payment link immediately, without any manual step from you.

What happens to the confirmation email if the customer’s email is wrong?

Apps Script’s MailApp will throw an error and the email won’t send, but the order still logs to the Sheet. You won’t be notified of the failed email automatically. Add response validation to the email field (as described in the mistakes section) to prevent invalid emails from being submitted in the first place — the vast majority of blank confirmation emails trace back to skipping this validation step.

Can I use this for a restaurant or food business with a daily changing menu?

Yes, with one adaptation: use the Dropdown field for menu items, and update the dropdown options each day to reflect what’s available. Google Forms lets you edit a live form without breaking the link — changes take effect immediately for anyone opening the form after you save. You can also add a “Today’s specials” description section at the top of the form that you update daily.

When should I move from this to WooCommerce or a proper e-commerce platform?

When payment collection needs to be part of the same flow (rather than a follow-up step), when you need customer accounts and order history, or when your product catalogue is large enough that a dropdown list stops being practical. The Google Form system is a genuine long-term solution for service businesses, food sellers, and custom order businesses — it’s not just a stepping stone. Migrate when a specific limitation becomes a real daily problem, not on a fixed timeline.

You Now Have a Working Order System

A Google Form that captures structured order data. A Sheet that logs every submission automatically. An Apps Script that sends a confirmation email to the customer and an alert to you the moment a form is submitted. A Stock tab with formulas that show cumulative orders per product. That’s a complete order capture system — built in under two hours, at zero cost, requiring no monthly subscription and no website.