Here is an explanation of how we extract flight latitude and longitude coordinates from received Flightradar24 email alerts using parsing rules for Export Emails to Google Sheets.
Flightradar24 is a Swedish service that shows real-time aircraft flight tracking information on a map. The data is gathered from several thousand ground stations around the world that track aircraft via ADS-B.

Here is an example of the alert:

Longitude and latitude are parts of the URL that is similar to:

“https://www.flightradar24.com/flights/get-alert-map?flightId=2c3de611&latLng=49.0877,18.1323&width=600&logo=false“

Our task is to find the URL query string that contains values for longitude and latitude:

“latLng=49.0877,18.1323”

Firstly, we need to add custom alerts to receive email notifications when the flight we’re interested in following departs or passes through a specified area.

Create a Gmail filter “from:(no_reply@fr24.com)” that automatically labels emails from Flightradar24 to a label named “flightradar24”. Alternativelly we can use the Chrome Extension Gmail Auto Label automatically filters and labels emails so that we can always stay organized in our inbox.

When all emails are properly labeled, we need to use Export Emails to Google Sheets to extract content from email messages, find flight numbers, aircraft types, flight latitudes, and flight longitudes from email messages, links, and attachments. The flight longitude and latitude are contained only in the URL link of the alert message we received by email. Therefore, we must use advanced parsing rules to parse light latitudes and flight longitudes.

We need to go to the cloudHQ dashboard
and click “Save Email Messages”. This wizard will help you set up a continuous backup of all your emails in a Gmail label and save them in Google Sheets in the Google Drive account.

Select the FlightRadar24 label in the wizard to back up or save all emails in a Gmail label, as shown on the screenshot:

In the wizard, select the option “Extract columns using parsing rules”:

In the example, we parse the following: flight number, aircraft reg., aircraft type, latitude, and longitude.

To find coordinates, we need to configure advanced rules that parse the URL (Uniform Resource Locator) query string. The query string is created of a parameter and a value joined by the equals “=” sign. If we have multiple parameters, query strings are merged using the ampersand “&” sign.
The source URL from which we are parsing coordinates looks like this:

• URL: “https://www.flightradar24.com/flights/get-alert-map?flightId=2c3de611&latLng=49.0877,18.1323&width=600&logo=false”
• A query string is a part of a uniform resource locator (URL) that assigns values to specified parameters: “&latLng=49.0877,18.1323”
  The query parameter “latLng” contains the value “49.0877,18.1323”, longitude and latitude respectively.

Firstly, we need to create a latitude rule to find values between two query string parameters “&latLng=” and “&width=“, and a text between the equal sign “=” and the comma delimitter sign “,“.
Secondly, we need to create a longitude rule to find values between two query string parameters “&latLng=” and “&width=“, and a value between the comma sign “,” and the ampersand sign “&“.

When the job is configured, it will be accessible in the dashboard:

The Google Sheet is saved in your Google Drive:

If you enable the option to enable continuous saving of email messages, the export process will continuously update spreadsheets. The spreadsheet will be updated automatically.