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.
To import Zillow data to Google Sheets, we follow the steps below:
- Log in to RapidAPI and generate the API key
- Choose the endpoint
- Install the Amigo Data Add-on
- 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.
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.
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.
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.
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.
You can either install the extension directly from the Google Workspace Marketplace or follow the steps below:
- Open a new google sheet
- Click on Extension→ Add-ons→ Get Add-on
- 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.
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.
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.
Below you will find some related articles on how to import data from a variety of sources.