Import Flightradar Data To Google Sheets

Import FlightRadar data to Google Sheets
Reading Time: 4 minutes

Import FlightRadar data to Google Sheets and track flights with live data, get flight information, get a list of all flights of an airline, get all available aircrafts, and many more. These can be done with ease and without expending much time using a Google Sheets extension called Amigo that lets us quickly and effortlessly retrieve flight data using Flightadar API. No coding is involved.

Below is a snippet of the imported data of the list of most tracked flights in Flighradar.

Most tracked flights in Flightradar

Let’s learn how to import Flightradar data to Google Sheets using Amigo. We’ll go through step by step.

Steps to import Flightradar data to Google Sheets:

  1. Install the Amigo extension
  2. Get the API endpoint URL
  3. Import the data to Google Sheets

How to import Flightradar data to Google Sheets

Install the Amigo Data extension in Google Sheets

Install the Amigo Google Sheets add-on from the Google Workspace Marketplace.

Click here to install.

Install Amigo to import flight data to Google Sheets using Flightradar API

Alternatively, you can get it from Google Sheets.

  • Open a new sheet
  • Go to Extensions→Add-ons→Get add-ons
  • Search for Amigo and install

Get the API endpoint URL

We’ll use a third-party flight tracking API called “Flight Radar” on RapidAPI, an online API marketplace.

Sign up or log in to RapidAPI.

Search for Flightradar and click the most relevant one from the results. Or click this link to go directly to the Flightradar API documentation page.

FlightRadar API to be used to import flight data

Click on the Subscribe to Test button and subscribe to a plan of your choice, post which you’ll be able to test and import flight data from Flightradar to Google Sheets.

Subscribe to the API to import flight data to Google Sheets

Click Endpoints to go back to the API Playground. On the left of the page are the available endpoints.

List of available flight endpoints

Flights and airlines information can be found within the flights category. Expand that and select any one of the endpoints–example, flights/search to retrieve information about a specific flight such as schedule, route, registration details and so on.

Endpoints in flights category

In the Required Parameters field, enter the flight code of the flight you want to fetch information–eg, BA11; and set the optional parameter limit.

The query parameters

After filling in the parameters, click the Test Endpoint to verify if the code and the other parameters are valid. The expected data will be shown in the Results section on the right.

In the Code Snippets section, we’ll find the URL along with the parameters and the headers.

Change the language to Shell→cURL. The query parameters are appended in the URL so that we do not have to enter the parameter manually to import the flight data to Google Sheets. Copy the URL and also note the headers. These will be used in the next step, ie to import flight data from Flightradar to Google Sheets.

The API endpoint URL the the headers

Import the data from Flightradar to Google Sheets

Open Google Sheets and launch the Amigo add-on from the sheet into which you want to fill the data.

To connect to Amigo, click Extensions→Amigo: Data Imports and Exports→Connect.

Connecting to Amigo in Google Sheets

You’ll be presented with a list of sources to connect to. Choose Custom API.

Select Custom API as the source to connect

Paste the endpoint URL in the API URL field. Do not include the apostrophes.

Enter the flight data endpoint URL

Then expand the Details tab and enter the header from the Code Snippets (remember to omit the inverted commas). For the endpoint we’ve selected, the headers are:

Key: X-RapidAPI-Host, Value: flight-radar1.p.rapidapi.com

Key: X-RapidAPI-Key, Value: YOUR_API_KEY

Flightradar API headers
Preview of the Fligtradar data to import to Google Sheets

The flight data will be imported into Google Sheets in a moment. Below is a snippet of the data imported into Google Sheets from Flightradar.

Snippet of the imported data

Once the data have been imported into Google Sheets, they can be updated automatically at regular intervals–hourly, daily, weekly or on custom days. You will then be able to track flights live from Google Sheets.

You can track multiple flights by just importing the data once and setting an automatic refresh schedule. And what’s more, you can get these data directly sent to your inbox these data sent to your inbox. Click here to learn how to set a refresh schedule and set up alerts in Amigo Data.

Visit our blog to find out about the kinds of data that you can import to Google and the many other things you can do with Amigo Data–and for tips and tutorials on Google Sheets.

Some recommended articles:

Import Zillow Data to Google Sheets

Import eBay Data To Google Sheets And Find The Best Deals

Import Eventbrite Data to Google Sheets

X
Hire expert data analysts on-demand. Get 30 Days Free Trial