Import Zillow data to Google Sheets

Reading Time: 4 minutes

This article will teach you how to import Zillow data to Google Sheets. 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.

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 learn how to import Zillow data to Google Sheets.

Step 1: Get the API key

Login to RapidAPI here. If you don’t have an account created, you will need to click the Sign-up option and create one.

Search for Zillow API and select it once you have found it.

Click on Subscribe to Test and subscribe to the basic plan of Zillow API which is free of cost.

Upon subscribing to the API, your API key will be generated and visible under the API Documentation section. Keep your API key confidential lest hackers get an opportunity to breach your privacy and steal your data or worse.

Step 2: Choose the 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 we wish to import to your sheets. For our tutorial, we will be using the endpoint titled, Searching for properties.

By the list of endpoints, you will find the section wherein you can add queries to filter the Zillow Data which is to be imported into your Google Sheets. While some parameters are required and automatically entered, you may enter optional parameters according to your preferences.

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

Click on Code snippets→ change the programming language from (Node.js) Axios to Shell→cURL.

Copy the endpoint URL and take note of the headers. You will need to input these in the Amigo Data Add-on 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:

  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

Select Custom API from the list of sources

List of sources to connect

Paste the API endpoint URL copied earlier under the API URL section. Select the Details tab and add the headers along with their value noted earlier and click Preview.

Header: X-RapidAPI-Host Value: zillow56.p.rapidapi.comHeader: X-RapidAPI-Key Value: Your_key

Flatten the data to separate it into columns. Finally, click Import to import Zillow Data to Google Sheets

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

Amigo Data Add-on 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 by clicking here.

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