Ed Southwood · South West

Case study · Spreadsheet → calendar

A shared rota that just appears in everyone's calendar

Two households share a rota for the children in a Google Sheet. The only information in it is the colour of each cell. Nobody wanted to change that — it works. What they wanted was for it to show up in their phone calendars, automatically.

Built in about a day Size 299 lines of Python Running cost £0 AI at runtime none — AI was used to build it

The problem

The rota lives in a shared spreadsheet: one row per date, and the cell is coloured pink or blue depending on who has the kids. It's quick to fill in and everyone understands it. But a spreadsheet doesn't buzz your phone the night before, doesn't show up next to your work meetings, and is fiddly to read on a screen the size of a hand.

The usual answer would be "move everyone to a proper calendar app". That means retraining people, migrating history, and the sheet slowly falling out of date. The habit was the valuable bit; the format was the problem.

What I built

A small program that reads the sheet exactly as it is — colours and all — and writes two calendar files, one per person. Each calendar can be subscribed to from Google Calendar, Apple Calendar or Outlook, so it appears alongside everything else. Consecutive days are merged into a single multi-day event, and any notes typed in a spare column become the event description.

It runs automatically every night at 11pm. Change the sheet on Tuesday; it's in everyone's calendar by Wednesday morning. Nobody has to remember to do anything.

Pink cells  → parent A has the kids
Blue cells  → parent B has the kids
Column D    → notes (school trip, swimming kit…)
Nightly     → regenerate, publish, calendars refresh themselves

What changed

  • The sheet is still the single source of truth. Zero new habits.
  • Everyone gets reminders and sees the rota next to work commitments.
  • It has run unattended every night since April 2026 — over 140 automatic updates so far.

Time and cost

About a day to write and set up, including the Google permissions. It runs on a tiny server that costs a few pounds a month and already does other jobs, so the marginal cost is nil. There is no subscription and no company that can switch it off.

What this could mean for your business

Almost every small business has a spreadsheet like this — the staff rota, the delivery round, the holiday-let changeovers, the machine maintenance schedule. The same pattern turns it into:

  • a calendar on every staff member's phone, updated when the rota changes;
  • a text message the evening before someone's shift;
  • a simple web page a customer can check ("is the workshop open Saturday?");
  • an alert when a date is double-booked or a stock number drops below a threshold.

Five years ago this was a "nice to have" that would have cost too much to commission. Now it is a day's work.

Got something similar? Book a free 30-minute chat and describe it. If it's a one- or two-day build, I'll quote a fixed price on the spot.

← All case studies