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.
Steps to import Skyscanner 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.
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.
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.
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.
We can search for prices by inputting certain query parameters. In the Required Parameters fields are number of adult passengers, origin and destination airports, and departure date.
Let us suppose that a family of four–the parents and two children–are planning a trip from New York to London. The parameters will be as shown below.
We’ll also need to fill in some optional parameters since the family has children and also need to book two-way tickets.
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.
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.
You’ll be presented with a list of sources to connect to. Choose Custom API.
Paste the Skyscanner API endpoint URL in the API URL field. Do not include the apostrophes.
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
Click the PREVIEW button. Flatten and expand the nested datasets and delete the columns that are not required. Then click IMPORT to import data from Skyscanner to Google Sheets.
The data will be imported into Google Sheets in a moment. Below is a 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–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