Import Zillow data to Google Sheets

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.

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.

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.

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.

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.

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.

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.

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

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

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.

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

Select Custom API from the list of sources.

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

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

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

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