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 for your vacation.

In this article, we will learn how to import Airbnb data to Google Sheets using Amigo, a Google Sheets extension. Amigo automatically updates the data at regular intervals and alerts us with the updated data via email and/or Slack.

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.

Install the Amigo extension

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

Amigo Data in 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 and install

Generate the API key

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.

Learn how to import airbnb data to google sheets using rapidAPI

Choose a subscription plan from the Pricing menu. In this tutorial, we will choose the Basic option

Click on the endpoints and scroll down a bit. You will find your API key under the Header Parameters.

Choose an endpoint

For this tutorial, we will import Airbnb data on the basis of location with the Search by location endpoint. In the required parameters section, add the location, check-in, checkout, and adults details.

Click the Test Endpoint option to run the query

The success message indicates that the API is functioning correctly.

On the right side under Code Snippets, select Shell-> cURL from the dropdown menu.

Select the cURL from Shell

Copy the URL excluding the apostrophes and also note the headers. This is the endpoint URL for the data to import to Google Sheets.

Import data to Google Sheets

Go back to Google Sheets and launch the Amigo extension.

Select Custom API from the list of sources.

Selecting the source in Amigo Data

Paste the endpoint in the API URL bar.

Pasting the endpoint

Then expand the Details tab and enter the following as headers:

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.

Flatten the data points and then click IMPORT.

A snippet of the imported data.

Snippet of imported 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 we so wish, set an alert so the data are sent to us via email and/or Slack. Click here to 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

X
Hire expert data analysts on-demand. Get 30 Days Free Trial