Automate Flight Data Imports To Google Sheets

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

Click here to install.

Alternatively, you can get it from Google Sheets.

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

Sign up for  RapidAPI

Once you’re logged in, go to the Flight Data API documentation in RapidAPI

Scroll down a bit and you will find your API key

In order to use this API, we need something called “Access Token” from Travelpayouts.

Sign up to Travelpayouts to generate your access token. Travelpayouts has several programs that we can use to retrieve different kinds of flight data. We’ll use the Aviasales API. Follow this link and click on Join Aviasales.

Create a project and connect the project to Aviasales to generate an access token. The access token will be found in the “API” section under “Your API token”

We can now begin to import flight data to Google Sheets and automate the data imports.

For this tutorial, we will import the non-stop flight tickets data. It provides us with non-stop flight ticket data for a destination of our choice. So, select the Cheapest tickets option from the list of API endpoints on the left panel.

The header parameter consists of the API key and API host. In the required parameters section we have to input the IATA code for the origin city and currency code. You can access all the IATA codes using this link. In the optional parameter, you can add the departure and return time (YYYY-MM).

In this tutorial, we will import the cheapest flights data from New York to London for January 2023. The parameters that we will enter are as follows:

Required parameters:

Origin: LGA (New York IATA code)

Currency: USD 

Optional Parameters:

Depart date: 2023-01 (YYYY-MM)

Return date: 2023-01 (YYYY-MM)

Destination: LHR (IATA code for Heathrow Airport)

After filling in the parameters, click the Test Endpoint button to run the query

The success message indicates that the endpoints are functioning correctly. 

On the right side under code snippets, change the language from (Node.js) Axios to (Shell)cURL from the dropdown menu

Copy the URL excluding the apostrophes and also note down the headers. This is the endpoint URL for the data to import to Google Sheets.

Go back to Google Sheets and launch the Amigo Data extension.

Select Custom API from the list of sources

Paste the endpoint in the API URI bar

Then expand the Details tab and enter the following as headers:

Name: X-Access-Token, Value: YOUR_ACCESS_TOKEN (this is the Aviasales API token; you can also find this in the code snippet)

Name: X-RapidAPI-Host, Value: travelpayouts-travelpayouts-flight-data-v1.p.rapidapi.com

Name: X-RapidAPI-Key, Value: your_key

Replace your_key with your RapidAPI key.

Then click the PREVIEW button to retrieve the flight data and see the preview.

Flatten the data points and then click IMPORT.

A snippet of the imported data.

You can likewise import other types of data from the Flight Data API. Following are some other examples.

Popular airline routes

You can import data about the routes for which the airline operates. In the required parameter section, you need to enter the IATA code of airline. You can access the list of IATA codes for airlines using this link.

Popular directions from a city

You can import the data about the most popular destinations from a city. In the required parameters section, you can enter IATA city code and currency type.