Applause. Consulting

Case study

The deadline, delivered.

A regional education service center announces trainings, deadlines, and conferences to dozens of school districts — by email, mostly, and hopefully twice. We turned the spreadsheets they already keep into calendars their districts can subscribe to.

Client
A regional education service center in Texas
Scope
Calendar service: sheet sync, public site, iCal feeds
Stack
TypeScript · Hono · React · SQLite · Google Sheets API
Status
In beta with the client

The problem: everyone's calendar but yours

Every department at the service center keeps its own list of important dates — PEIMS submission windows, budget workshops, superintendent round tables. Those lists live in spreadsheets, and the dates reach school districts as email blasts. Miss the email, miss the deadline.

The fix wasn't to replace the spreadsheets. Directors like their spreadsheets, and software that asks people to change how they work has a short life expectancy. Instead, the service reads each department's Google Sheet on a schedule, merges everything into one public calendar, and serves subscribable iCal feeds — so a superintendent adds "their" feed to Outlook once, and every future deadline just appears.

The public calendar: a June month grid with training and deadline events, plus filter chips for audience, type, and department
One calendar, filterable by who you are — superintendent, CFO, PEIMS director, and five more roles.
The mobile list view showing upcoming dates with type badges and a register button
On phones the grid becomes a list, with registration one tap away.

Built to survive its own data source

Spreadsheets maintained by busy humans are a hostile data source, and the sync engine treats them that way. It finds the right tab by its headers, not its name, so directors can reorganize freely. A malformed row gets skipped with a warning, not a crash; one broken sheet never blocks the other departments. An admin dashboard shows exactly what synced, what didn't, and why.

The feeds are plain standards — RFC 5545 iCal, the format Google Calendar and Outlook have understood for decades. Each event gets a stable identity across syncs, so when a director fixes a typo, subscribers see an update instead of a duplicate. No app to install, no accounts to manage, nothing for districts to learn.

The service is in beta with the center's departments now, syncing real sheets every half hour — and the email blasts are already getting shorter.

Start your project