Google Workspace automation

Cake Order Management

A working cake-order workflow that keeps order details, due dates, pickup or delivery, and status in Google Sheets and syncs confirmed times to Calendar.

Google SheetsApps ScriptGoogle CalendarWorkflow automation

The build

A clear system behind the interface.

I built a practical order-management prototype for a cake business using Google Sheets, Apps Script, and Google Calendar. The tracker keeps cake details, due dates, payment balances, order status, and pickup or delivery times together. Confirmed orders create or update one linked calendar event, saved event IDs prevent duplicates, and a sync log records every result. This is a self-initiated working prototype with fictional sample data.

Evidence

Duplicate-safe calendar sync

Payment and status tracking

Editable working prototype

Publication status: Working prototype

Visual walkthrough

Decisions made visible.

Cake order tracker in Google Sheets — One tracker keeps cake details, due dates, delivery type, balances, and order status together.

Cake order management dashboard — Sample order data becomes a simple weekly view for production planning and payment follow-up.

Cake order Google Calendar automation — Confirmed orders create or update one linked Calendar event with the right schedule and details.

Cake order automation workflow — Apps Script validates required fields, syncs events, and records clear results for the team.