Case Study
A Custom Operations Platform Built on Google Workspace
A 9-module operations platform replacing scattered spreadsheets with real-time finance, Stripe integration, and zero software cost. Built in 55 days.
The interfaces shown are faithful recreations with anonymized data. The design, functionality, and architecture remain as implemented.
The Beginning
The starting point.
The team was running the entire operation on spreadsheets - careful, thorough spreadsheets, but spreadsheets nonetheless. What was missing was infrastructure that matched the complexity of the business.
Maintenance tracking - issue logging with photos, priorities, and resolution history
Architecture
Built on Google Workspace.
Rather than introduce new infrastructure, I built on top of what was already there: Google Apps Script as the backend, Sheets as the database layer, and a custom web interface served through Apps Script. No new logins, no learning curve, no licenses, no migration.
The full platform - all modules accessible from a single sidebar
Up Close
From upload to filed.
The old workflow: a PDF arrives by email, download it, rename it, drag it to the right folder, log it in the tracker, notify the accountant. Six manual steps, fifty times a month. Now it is one upload - the system handles naming, filing, metadata, and accountant sync automatically.
