Import AirDNA Data To Google Sheets

Import AirDNA data to Google Sheets
Reading Time: 5 minutes

Property owners and renters may have diametrically opposed desires and they may have disagreements on various things but at the end of the day both just want to keep their bank accounts healthy. While investors wish that they get along, a wish more often than not belied. And so keeping all these three categories of people contented simultaneously is a tough ask. Fortunately, there’s one thing that can make all three happy: AirDNA.

AirDNA tracks millions of Airbnb and Vrbo listings analysing rates, occupancy, revenue and pricing. It helps property owners, managers and investors price their short-term rentals with data-driven insights and decisions. And although not created with renters in mind, its data can be used by renters to find the best and most suitable neighbourhood.

The data from AirDNA can be retrieved and imported into Google Sheets with Amigo, a Google Sheets extension. It then automatically updates the data at regular intervals and alerts us with the updated data via email and/or Slack.

So, let’s learn how to import AirDNA data to Google Sheets step-by-step.

But before that, here’s a foretaste of what you can expect. Below is a snippet of property listings in Santa Monica.

Here are the steps to import AirDNA data to Google Sheets:

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

How to import AirDNA data to Google Sheets

Install the Amigo extension in Google Sheets

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

Click here to install.

Install the Amigo add-on to import AirDNA data 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 and install

Get the API endpoint URL

We’ll import AirDNA data to Google Sheets using a third-party AirDNA API on RapidAPI–an API marketplace. It is much easier to use and simpler while at the same time being as useful as the official AirDNA API.

Sign up or log in to RapidAPI.

Search for AirDNA API in the RapidAPI Hub and click the first result. Or click this link to go directly to the API documentation page.

API to import AirDNA data to Google Sheets

Click on the Subscribe to Test button and subscribe to a plan of your choice, after which you’ll be able to run the test and import AirDNA data to Google Sheets.

Subscribe to the API to use the AirDNA API

Click Endpoints to go back to the API Playground. On the left is the list of the type of data that can be retrieved.

Types of AirDNA data available for import
Endpoint to retrieve active AirDNA listings

In the Required Parameters we’ll specify the query parameters. We’ll retrieve the listings data in Los Angeles in 2022 from March to September.

Parameters for active listings in AirDNA

The API endpoint URL along with the headers–which will be required to import AirDNA data to Google Sheets–can be found in the Code Snippets section.

Change the language from Node.js (Axios) to Shell→cURL. Copy the URL and note also the headers.

The endpoint URL and headers of the AirDNA API

Pull the data to Google Sheets

Open Google Sheets and launch Amigo. To connect to Amigo, go to Extensions→Amigo: Data Exports and Reports→Connect.

Launch Amigo to import AirDNA data to Google Sheets

We’ll be presented with a list of sources to connect and import data. Select Custom API.

Select Custom API to connect AirDNA to Google Sheets

Paste the endpoint URL (without the apostrophes) in the API URL field.

Enter the AirDNA API URL in Amigo

Then expand the Details tab and enter the headers.

The headers can be found in the Code Snippets. The characters to the left of the colon are the header names and those to the right are the header values. Enter these as separate headers. Do not include the apostrophes.

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

Name: X-RapidAPI-Key, Value: YOUR_API_KEY

Enter the headers in Amigo
Preview of the data

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

AirDNA data imported to Google Sheets

Visit our blog for to find out about the kinds of data that you can import to Google Sheets and many other useful–and also cool–things you can do with Amigo Data.

Some recommended articles:

Import Zillow data to Google Sheets

Import Gasoline Price Data To Google Sheets

Import FlightRadar Data To Google Sheets

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