Import Zillow data to Google Sheets

Reading Time: 5 minutes

This article is about how to import Zillow data to Google Sheets using Zillow API. Zillow is the leading real estate and rental marketplace that bridges the gap between tenant/potential home buyers and their dream homes. It uses its live database of more than 110 million U.S. homes and connects its users with the best professionals who can help.

In the following image, we can see the results of Zillow data imported into Google Sheets.

Zillow data imported into Google Sheets with Zillow API

To import Zillow data to Google Sheets, we follow the steps below:

  1. Log in to RapidAPI and generate the API key
  2. Choose the endpoint
  3. Install the Amigo Data Add-on
  4. Import the data

How to import Zillow data to Google Sheets

Follow the steps given below to import Zillow data to Google Sheets.

Step 1: Get the API key

We’ll use a third-party Zillow API on RapidAPI to retrieve data from Zillow and import them to Google Sheets.

Login to RapidAPI. If you don’t have an account, create one using the Sign Up option.

Search for Zillow API and select it once you have found it. Or go directly to the Zillow API documentation.

The Zillow API

Click on Subscribe to Test and subscribe to the basic plan of Zillow API which is free of cost. You can always upgrade later should you need.

Subscribe to the Zillow API

After subscribing to a plan, we’ll be able to use the Zillow API and extract data from Zillow to Google Sheets.

Upon subscribing to the API, your API key will be generated and visible under the API Documentation section. Keep your API key confidential.

Zillow API key

Step 2: Choose an API endpoint 

Under the API documentation on the left side, you will find the different endpoints that you can use to import Zillow data to Google Sheets.

List of available data endpoints in Zillow API

Click on the endpoint which provides the data that you wish to import to Google Sheets. For our tutorial, we will be using the endpoint titled, Search for properties to search for property listings in a specific region.

In the Required Parameters, enter the location for which you want to search for properties. We’ll use Miami, Florida as an example.

Zillow API parameter

Then in the Optional Parameters (which are optional, of course), specify the details such as price, bed number, garage, square feet, and so on to filter the results.

The optional parameters

Once you have inputted the parameters, click on Test Endpoint to verify if the parameters are valid. On the right side, you will notice a successful response to the data that you requested. 

The Zillow API endpoint URL as well as the headers can be found under Code Snippets.

Change the programming language from (Node.js) Axios to Shell→cURL using the dropdown menu.

Change the language to cURL

Copy the endpoint URL and take note of the headers. You will need to input these to import Zillow Data to Google Sheets.

Zillow API endpoint URL and headers

Step 3: Get Amigo Data Google Sheets extension

The Amigo Data Add-on is an extension in Google Sheets that allows you to import data from various sources without coding. 

Install Amigo to import Zillow data to Google Sheets

You can either install the extension directly from the Google Workspace Marketplace or follow the steps below:

  1. Open a new google sheet
  2. Click on Extension→ Add-ons→ Get Add-on
  3. Search for “Amigo Data” and install it.

Step 4: Import the data to Google Sheets

Go to the Google Sheet in which you want the data to be pasted. Click on Extensions→Amigo Data→Connect.

Launch Amigo to import Zillow data to Google Sheets

Select Custom API from the list of sources.

List of sources to connect

Paste the Zillow API endpoint URL copied earlier under the API URL section.

Zillow API endpoint URL

Expand the Details tab and add the headers along with their value noted earlier. Then click the preview button.

Header: X-RapidAPI-Host Value: zillow56.p.rapidapi.com
Header: X-RapidAPI-Key Value: Your_API_key

Zillow API headers

Flatten and expand the nested datasets to separate them into columns. Finally, click IMPORT to import Zillow Data to Google Sheets.

Preview of the data

In a few seconds, you will notice the data from Zillow has been successfully imported into your Google Sheets as shown below.

Snippet of the data imported from Zillow to Google Sheets

Amigo Data makes it effortlessly simple to import data from various sources to your Google Sheets. It also allows users to set a refresh schedule that automatically updates the imported data ensuring that the user is provided with the latest data always. Learn how to automatically refresh the imported data and receive emails for the same on your Slack or email.

In this article, we have successfully learned how to import Zillow Data to Google Sheets using the Amigo Data Add-on. To expand the sources from which you can import data and perform several operations on them, check out our blog.

See Also

Below you will find some related articles on how to import data from a variety of sources.

Import Etherscan data to Google Sheets

How to import CoinGecko data to Google Sheets

Import Coinbase data to Google Sheets

Leave a Reply