Import Airbnb Data To Google Sheets

Reading Time: 4 minutes

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.

Data imported from Airbnb into Google Sheets

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.

Install Amigo Data 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.

RapidAPI page to sign up

Once you’re logged in, go to the Airbnb API documentation in RapidAPI.

Airbnb API documentation

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.

Subscribe to the Airbnb API

Click Endpoints to to back to the Airbnb API documentation. You will find your API key under the Header Parameters.

RapidAPI key

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.

Airbnb API parameters

Click the Test Endpoint option to run the query.

Testing the Airbnb API

The success message indicates that the API is functioning correctly.

The Airbnb API is working fine

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.

Select the cURL from Shell

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.

Airbnb API endpoint URL and headers

Import the data to Google Sheets

Go back to Google Sheets and launch the Amigo extension to import the Airbnb data to Google Sheets.

Launch Amigo to import Airbnb data to Google Sheets

Select Custom API from the list of sources.

Selecting the source in Amigo Data

Enter the Airbnb API endpoint URL in the API URL field.

Pasting the endpoint

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.

Airbnb API headers

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.

Preview of the Airbnb data to import to Google Sheets

The data from Airbnb data will be imported into Google Sheets in a short while. A snippet of the imported data is shown below.

Snippet of Airbnb data in Google Sheets

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:

Import AirDNA Data To Google Sheets

Import Realtor Data To Google Sheets

Import Zillow data to Google Sheets

Leave a Reply