Airbnb is a vacation rental company that operates an online marketplace focused on short-term rentals and homestays. Fun fact, Airbnb stands for “Air bed and breakfast” – something you need to make a great start to your vacation.
In this article, we will learn how to import Airbnb data to Google Sheets using Airbnb API. We’ll use the Amigo extension to get Airbnb data in Google Sheets. Amigo automatically updates the data at regular intervals and alerts us with the updated data via email and/or Slack.
In the snippet below, we have a list of rentals imported into Google Sheets from Airbnb using Airbnb API.
By the end of this article, you will be able to import various kinds of data from Airbnb like availability of rooms, prices, ratings, etc for any location.
To import Airbnb data to Google Sheets, we will follow the steps below:
Airbnb Data imports to Google Sheets
Here’s the step-by-step guide to import Airbnb data to Google Sheets with Airbnb API.
Install the Amigo extension
Install the Amigo Google Sheets add-on from the Google Workspace Marketplace to import Airbnb data to Google Sheets.
Alternatively, you can get it from Google Sheets.
- Open Google Sheets
- Go to Extensions→Add-ons→Get add-ons
- Search for Amigo and install it.
Generate the API key
We’ll use an Airbnb API on RapidAPI, an API marketplace to scrape data from Airbnb.
Sign up or log in to RapidAPI.
Once you’re logged in, go to the Airbnb API documentation in RapidAPI.
Choose a subscription plan from the Pricing option to use the Airbnb API. You can go for the Basic plan–and upgrade it later should you need to.
Click Endpoints to to back to the Airbnb API documentation. You will find your API key under the Header Parameters.
Choose an Airbnb API endpoint
On the left of the Airbnb API documentation, you’ll find a list of endpoints that we can use to retrieve Airbnb data.
For this tutorial, we will import Airbnb data for a specific location with the Search by location endpoint. In the required parameters section, add the location, check-in, check-out details, and number of adults.
Click the Test Endpoint option to run the query.
The success message indicates that the API is functioning correctly.
The Airbnb API endpoint URL as well the API headers can can be found under Code Snippets. Change the language from (Node.js) Axios to Shell-cURL.
Copy the URL excluding the apostrophes and also note the headers. These will be used to scrape Airbnb data and import the data to Google Sheets.
Import the data to Google Sheets
Go back to Google Sheets and launch the Amigo extension to import the Airbnb data to Google Sheets.
Select Custom API from the list of sources.
Enter the Airbnb API endpoint URL in the API URL field.
Then expand the Details tab and enter the headers mentioned in the Code Snippets.
Name: X-RapidAPI-Host, Value: airbnb13.p.rapidapi.com
Name: X-RapidAPI-Key, Value: your_key
Replace your_key with your RapidAPI key.
Then click the PREVIEW button to retrieve and preview the Airbnb data to import to Google Sheets.
Flatten the nested datasets and then click IMPORT.
The data from Airbnb data will be imported into Google Sheets in a short while. A snippet of the imported data is shown below.
Automatically update the data
We have learned how to import Airbnb data to Google Sheets. After the data have been imported, we can set a refresh schedule and the data will be updated automatically at regular intervals–weekly, daily, hourly or on specific days. And, if you so wish, set an alert so the data are sent to you via email and/or Slack. Learn how to set a refresh schedule.
Amigo extension can connect Google Sheets to multiple sources and allows you to import data automatically. It’s a convenient and versatile tool to import and export data to Google Sheets. It can save you a lot of time and effort. To learn more about other various kinds of data that can be imported to Google Sheets, visit our blog.
Some related articles you may be interested in: