Case Study 07 · Catalog site · structured order backend

Order Management System — Google Sheets & Apps Script Backend

GitHub Pages · Google Apps Script · Google Sheets

The Problem

A retail franchise needed a way for store managers to browse and request branded apparel without emailing someone a list or calling a regional contact. Orders had no paper trail, no status tracking, and no approval workflow — requests disappeared into inboxes.

The Build

We built a password-gated catalog site on GitHub Pages with 24 products, variant selection, quantity inputs, and a signature pad on submission. Orders POST to a Google Apps Script backend that writes every submission to a structured Google Sheet — raw JSON for downstream processing alongside a human-readable summary. Each row includes a Status column and Approved By fields for leadership to fill in without touching the frontend.

The Outcomes

— 24 products catalogued with variant and size selection

— Every order creates a permanent structured record in Sheets — nothing in inboxes

— Signature capture on every submission for accountability

— Approval workflow built into the sheet without additional tooling

— Zero hosting costs — runs on GitHub Pages and Apps Script

The Stack

HTML/CSS/JS Google Apps Script Google Sheets GitHub Pages Signature pad (JS)

Have a similar problem?

We start every engagement by understanding what's actually broken before we touch a tool.

Tell us about it →