Import Skyscanner Data To Google Sheets

Import Skyscanner data to Google Sheets
Reading Time: 4 minutes

Import Skyscanner data to Google Sheets and find the best flight deals from any location to any destination; search hotel room availability, compare their prices, check-in and check-out dates; and find car rentals.

All this and more can be done with a few clicks of a button using a Google Sheets extension called Amigo Data.

In this article, we’ll learn how to import Skyscanner data to Google Sheets step by step, and also learn how to automatically pull the data to Google Sheets.

Shown below is a snippet of the best flight deals from New York to London for a family of four imported into Google Sheets from Skyscanner. This, and other things, is what we’ll learn in this article.

Snippet of the imported data

Steps to import Skyscanner data to Google Sheets:

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

How to import Skyscanner data to Google Sheets

Install the Amigo Data extension in Google Sheets

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

Click here to install.

Install the Amigo addon to import flight data from Skyscanner to Google Sheets

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

Get the endpoint URL

Sign up or log in to RapidAPI.

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

Skyscanner API in RapidAPI

Click on the Subscribe to Test button and choose a plan to use the Skyscanner API. Once that’s done, you’ll be able to test and import Skyscanner data to Google Sheets.

Subscribe to the Skyscanner API

Click Endpoints to go back to the Skyscanner API Playground. On the left of the page are the available endpoints. Select the one for which you want to retrieve the data–say, Search best flights.

Endpoints list
Required parameters for Skyscanner API

We’ll also need to fill in some optional parameters since the family has children and also need to book two-way tickets.

The optional parameters

After filling in the parameters, click the Test Endpoint to verify that the parameter values are valid. The expected data will be shown in the Results section on the right.

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

Change the language to Shell and then select cURL. The query parameters are appended in the endpoint URL so that we do not have to enter the parameters manually. Copy the URL and also note the headers. These will be used in the next step.

The endpoint URL and headers for the query

Import the Skyscanner data to Google Sheets

Open Google Sheets and launch Amigo Data from the sheet into which you want to fill the data. To connect to Amigo Data, click Extensions→Amigo Data→Connect.

Launch Amigo to import Skyscanner data to 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 Skyscanner API endpoint URL in the API URL field. Do not include the apostrophes.

Enter the endpoint

Then expand the Details tab and enter the header. (Exclude the inverted commas.) For the endpoint we’ve selected, the headers are:

Name: X-RapidAPI-Key, Value: YOUR_API_KEY

Name: X-RapidAPI-Host, Value: skyscanner44.p.rapidapi.com

Skyscanner API header values

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

Snippet of the Skyscanner data imported into Google Sheets

Once the data have been imported into Google Sheets, they can be updated automatically at regular intervals–hourly, daily, weekly or on custom days–should you so wish, and get these data sent to your inbox. Click here to learn how set a refresh schedule and set up alerts in Amigo Data.

Check out the Skyscanner API documentation to learn more about the types of data that you can retrieve and import to Google Sheets.

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 Yelp Reviews To Google Sheets

Import Eventbrite Data to Google Sheets

Leave a Reply