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
booking flow, reading emails from the portals, writing to a spreadsheet and calendar, alerts
Tools
Google Apps Script, Gmail, Google Sheets and Calendar
Year
2026

Bookings came in from two portals and the form on the website, and had to be retyped by hand. Now and then one went missing.

Three sources, one route: every booking lands in the spreadsheet and the calendar at the same time.
Three sources, one route: every booking lands in the spreadsheet and the calendar at the same time.
The colour of an entry says which portal the booking came from. A recreated view with changed data.
The colour of an entry says which portal the booking came from. A recreated view with changed data.

How it works

Each source has its own reader. The portals send emails in different formats, and one shared reader would lose data.

Duplicates are caught by registration number and time. The same customer may book from different inboxes.

A processed email gets a label. Opening a message by hand breaks nothing.

When it does not understand something, it sends an alert. It does not guess.

Next projectVisuals for live events