Skip to content
008

Car park bookings in one calendar

An automation for an airport car park

Client
Parking Panorama, a family-run car park by Katowice Airport
Scope
mapping the booking flow, parsers, writing to a spreadsheet and calendar, alerts
Tools
Google Apps Script, Gmail, Google Sheets, Google Calendar, a webhook from the site
Year
2026
Bookings came in from three sources: two portals and the form on the website. The problem was not that retyping takes time — it was that now and then something got lost.
Bookings came in from three sources: two portals and the form on the website. The problem was not that retyping takes time — it was that now and then something got lost.
Everything lands in the spreadsheet and the calendar at the same time. The colour of the entry tells you which portal the booking came from.
Everything lands in the spreadsheet and the calendar at the same time. The colour of the entry tells you which portal the booking came from.

The four decisions it rests on

A separate parser for each source. You cannot write one that understands every format — and trying ends in data quietly going missing.

Duplicates recognised by registration number and time, not by email address. The same person books from different inboxes.

A label instead of the “read” status. Processed messages get their own label, so opening an email by hand breaks nothing.

An alert instead of a silent failure. When the system does not understand something, it sends a notification — instead of guessing.

Next projectVisuals for live events