This article will teach you how to import Realtor data to Google Sheets with Realtor API using the Amigo Data Add-on, a data integration and automation tool.
In the snippet below, we have a list of properties for sale in Southlake imported into Google Sheets with Realtor API.
Are you looking for a property to buy/rent? Or are you looking for a lucrative investment? Use the Realtor API to access real-time data of US real estate and agents. Filter the data to compile a list of desired real estate properties for you to choose from and fulfil your dream of being a homeowner.
To import Realtor data to Google Sheets using realtor API, we will follow the steps mentioned below:
- Sign up to RapidAPI and generate the API key
- Choose the Realtor API endpoint
- Install the Amigo Data Add-on
- Import the data to Google Sheets
How to import Realtor data to Google Sheets
Follow the steps given below to learn how to import Realtor data to Google Sheets.
Step 1: Get the API key
We’ll use a Realtor API on RapidAPI that will allow us to retrieve real estate and property data into Google Sheets.
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 Realtor API and click on the result according to the snippet below. Or just click this link to go directly to the Realtor API documentation in RapidAPI.
Click on the Subscribe to Test option and choose the plan you wish to subscribe to. The paid plans will allow you to make significantly more requests than the free plan, i.e., Basic Plan.
After subscribing to a plan, we’ll be able to pull real estate and property data into Google Sheets using the Realtor API.
Upon subscribing your API key will be generated and automatically added as one of the required parameters in the API documentation segment.
Step 2: Choose the API endpoint
In the leftmost section of the API documentation, you will find the list of endpoints available with which you can import Realtor data to Google Sheets.
For the purpose of the tutorial, we will import property data from Realtor for a specific region in the US.
Select the Search properties for sale endpoint under Properties.
In the centre section of the API documentation, you will find a list of query name and their parameters. While the required parameters will be automatically filled with default values, we can modify the optional query parameters to filter the property data to suit our preferences.
For instance, to find the list of properties available for sale in Chicago we change the location query‘s parameter from Santa Monica to Chicago.
Once you have inputted the optional parameters click on Test Endpoint. If you have entered proper query values, you will find a success message in the rightmost section of the Realtor API documentation.
Click on Code snippets→ change the programming language from (Node.js) Axios→ Shell→cURL.
Copy the API endpoint URL and take note of the headers and their values. The same will be used to import real estate data to Google Sheets from Realtor.
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 by following the link given below.
You can also follow the steps below and get the addon from Google Sheets.
- Open Google Sheets
- Click on Extension→ Add-ons→ Get Add-on
- Search for “Amigo Data” and install it.
Step 4: Import the data from Realtor to Google Sheets
Go to the Google Sheet in which you want the data to be imported and launch Amigo Data to import real estate and property data with Realtor API. Click on Extensions→Amigo Data→Connect.
Select Custom API from the list of sources.
Paste the Realtor API endpoint URL copied earlier under the API URL section. Click the Details tab and add the following headers along with their values noted earlier and click Preview.
Click on Flatten to present the data in separate columns. Once the data are separated into columns, click on Import.
Amigo Data will shortly import Realtor data to Google Sheets and the list of properties available for sale in Chicago will be displayed on your screen as shown below.
Auto-update the imported data
Amigo Data allows users to set a refresh schedule that automatically updates the data imported to ensure that the user is provided with the latest data without any manual input. To learn how to automatically update your data at regular intervals and receive alerts for the same on your email or Slack, click here.
You will then be able to track real estate and house prices from Google Sheets.
In this article, we learned to import Realtor data to Google Sheets. To learn how to import data from other sources, check out our blog.
Here are a few other articles that you might find useful.