How-To: Use custom RapidAPI API to get data from Zillow to your Sheet (2024)
I hope this “how-to” will help someone.
Update (10.04). Now you can use address to get property details.
Update (10.04). Now you can use formula (GETPROPERTYPRICE, GETPROPERTYZESTIMATE, GETPROPERTYDAYSONZILLOW, GETPROPERTYBEDROOMS, GETPROPERTYBATHROOMS, GETPROPERTYYEARBUILT, GETPROPERTYHOMETYPE, GETPROPERTYRENTZESTIMATE, GETPROPERTYLIVINGAREA, GETPROPERTYURL)
Update. From now you can use property URL instead of zpid.
Here you can post your ideas https://apimaker.sleekplan.app/
Let’s go :)
Added Loom of use here
Here is Google Spreadsheet https://docs.google.com/spreadsheets/d/14esd4FMU15ciJ9cF1t9kQGNjC41-dw_ZxjuWqEL2MYk/edit?usp=sharing open it and make a copy!
In the “Settings” tab, you will need to enter your key, which you will receive from RapidAPI after subscribing to this API. https://rapidapi.com/apimaker/api/zillow-com1
Back to the tab “main”. As you can see in column A starting from row 4 (A4), there are ids of Zillow listed properties.
Paste the IDs into the sheet and select them. Open ‘Zillow API’ and click ‘Get property price…’ to get property price.
You will need authorisation to run the script for the first time.
Once approved, you will see the requested data.
The same things are for property status.
To get more data you can use formula:
=getPropertyValueByKey(A4,”address.zipcode”)
Key “address.zipcode” and many others you can see at this endpoint click.
=getPropertyValueByKey(A4,”bathrooms”) for bathrooms :)
Update price by trigger
Create new Trigger.
Every 1 am at the last free column you will receive a new price for all zpids from cell A4 and bellow.
That’s about it!
It would be great to get some feedback from you.
Update. Added an interface that may help you to collect data by search url you can get from address bar on Zillow site.