Building a flight-plan creator with Google Cloud Functions and Sheets

The “business” problem

Screenshot from MSFS of me in a Lockheed Electra flying towards central Auckland, New Zealand
Screenshot from FlightRadar24 showing a live flight track

File formats

FlightRadar24 CSV export showing Air New Zealand 1005 on the ground in LAX
Extract from PLN file for the KLAX to NZAA flight
Creating the root element in xmlbuilder2 for the PLN file

Google Cloud Functions

Minimal Google Cloud Function

Airport data in a Google Sheet

Fetching data from a Google Sheet with auto-authentication

The front end

My standard scaffolding for the front end
track2plan.apps.cronin.nz

Tidying up

Deployment

Github Actions workflow for Google Cloud Functions
Github Actions workflow for web app on S3 and Cloudfront

Summary and next steps

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store