Automate Flight Data Imports To Google Sheets

Reading Time: 6 minutes

Air travel takes up a significant share of travel expenses. Being aware of the price trends can produce useful insights which can help one make travel convenient and budget-friendly.

That’s why it’s important to automate flight data imports to be well aware of the airfare and availability. That’s where Amigo Data, a Google Sheets extension, comes in handy. With Amigo Data, you can import data to Google Sheets and get it updated automatically. Just set it up once and let Amigo Data update it for you regularly.

In this tutorial, we will learn how to automate flight data imports to Google Sheets. Below are the following steps to import flight data to Google Sheets:

To give an idea of what to expect, here’s a snippet of the flight data I’ve imported into Google Sheets.

Snippet of the flight data imported to Google Sheets

The above data are for the cheapest flights for each day of the month from New York to London.

How to automate flight data imports to Google Sheets

Here’s the step-by-step guide to import flight data to Google Sheets and automatically update the data.

Install the Amigo Data add-on

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

Install Amigo to automate flight data imports to Google Sheets

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

Generate the API key and access token

Sign up for  RapidAPI

RapidAPI page to sign up

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

Learn how to automate flight data imports to Google Sheets

Scroll down a bit and you will find your API key

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.

Click to 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”

Flight data API token

Choose an endpoint

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.

Click the endpoint

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)

Enter the parameters of the flight data to fetch

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

Click to test the endpoints

The success message indicates that the endpoints are functioning correctly. 

The endpoint is functional

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

Select the cURL from Shell

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.

Copy the endpoint URL and note down the header key and value

Import data to Google Sheets

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

Launching Amigo Data to import flight data to Google Sheets

Select Custom API from the list of sources

Selecting the source in Amigo Data

Paste the endpoint in the API URI bar

Pasting the endpoint URL of the flight data to import to Google Sheets

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.

Paste the headers and their respective values

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

Flatten the data points and then click IMPORT.

Preview, flatten and import data

A snippet of the imported data.

Snippet of the flight data imported into Google Sheets

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.

Endpoint to get popular airline routes

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.

Endpoint to get popular directions from a city

Similarly, you can also explore other endpoints. Flight Data API has so much to offer. To explore more endpoints go through the documentation of Flight Data API. 

After importing the data, you can also set a refresh schedule so that the data are updated automatically at regular intervals. By this, you can automate importing financial market data to Google Sheets. To learn how to set a refresh schedule, follow this link.

There are several other types of data that you can import into Google Sheets using Amigo Data such as Marketstack data,  Coinmarketcap data, Nasdaq data, and many more. 

FAQs

You can easily get a life feed of flight prices data in Google Sheets with Amigo. Pull the flight data from from any of the data providers such as Travelpayouts and Skyscanner. Then set a refresh schedule to automatically update the data so that Amigo will pull the live flight prices into Google Sheets every minute or hours or any frequency of your choice.

Yes, you can. But you first need to import the flight prices data to Google Sheets–which you can do with tools like Amigo Data. Then you can track and compare the fluctuation in prices over time. You can also import the cheapest flight prices information for a specific period for different routes.

Some related articles you may be interested in:

Import FlightRadar Data To Google Sheets

Import CoinMarketCap Data To Google Sheets

Import Data From Nasdaq To Google Sheets

One response to “Automate Flight Data Imports To Google Sheets”

Leave a Reply