flight logs into #googlesheets
I might be the only one in this community with a need for this, but I'm not too selfish to share. I had a need to get flight logs generated in Foreflight from our pilots into our system. So wrote this #appscript
to extract the data from a Foreflight generated email.
Step1: Make a copy of this spreadsheet. Open the script editor and run getFlightPlanEmails() to authorize. Then set it on a trigger for how ever often you want it check your email.
Step2: Email a flight plan from Foreflight to your gmail address except add "+flights" before the @. example "firstname.lastname@example.org"
It currently just returns some info, and then a JSON object containing each leg, but you could split() that data how ever you please in the sheet or in another script.