Author Topic: how to get zillow values and put them in a spreadsheet  (Read 1175 times)

solon

  • Handlebar Stache
  • *****
  • Posts: 2359
  • Age: 1823
  • Location: OH
how to get zillow values and put them in a spreadsheet
« on: April 04, 2023, 08:51:17 PM »
I'm trying to figure out how to get the zillow value of my house and drop it in a Google spreadsheet, once a day, automatically.

Has anyone ever done something like this?

Fru-Gal

  • Handlebar Stache
  • *****
  • Posts: 1203
Re: how to get zillow values and put them in a spreadsheet
« Reply #1 on: April 04, 2023, 11:56:32 PM »
Zillow has an API for that but you’d have to request access. https://www.zillowgroup.com/developers/api/zestimate/zestimates-api/

I wonder if you could use Personal Capital (now the app is called Empower) as the middle man for it? But not sure the process to download and then add to your own spreadsheet. Also, why every day? I wonder how often Zillow updates their estimate, for one thing.

Dicey

  • Senior Mustachian
  • ********
  • Posts: 22322
  • Age: 66
  • Location: NorCal
Re: how to get zillow values and put them in a spreadsheet
« Reply #2 on: April 05, 2023, 12:51:09 AM »
I'm with Fru-Gal, wondering why you need it every day? Blah, blah, your house is not an investment...you gotta live somewhere..blah x 3.

solon

  • Handlebar Stache
  • *****
  • Posts: 2359
  • Age: 1823
  • Location: OH
Re: how to get zillow values and put them in a spreadsheet
« Reply #3 on: April 05, 2023, 06:03:03 AM »
Ok, change it to monthly, annually, whatever. I was just wondering if anyone has figured out how to do it?

ATtiny85

  • Pencil Stache
  • ****
  • Posts: 947
  • Location: Midwest
Re: how to get zillow values and put them in a spreadsheet
« Reply #4 on: April 05, 2023, 06:08:49 AM »
I'd probably run a web scraping Python script on a schedule and then use IFTTT to push it to Google Sheets. I am sure there are plenty of ways to directly send it to Sheets, but I have existing snippets.

Of course, this depends on how Zillow does their thing. I took a 10 second scan of the page for our house, and I suspect it would be fairly straightforward.


lhamo

  • Magnum Stache
  • ******
  • Posts: 3094
  • Location: Seattle
Re: how to get zillow values and put them in a spreadsheet
« Reply #5 on: April 05, 2023, 09:53:16 AM »
Mint pulls RE valuations from Zillow -- which I guess means there is probably an API for it somewhere?  It looks like Tiller had a script for awhile but support was discontinued in 2020.

I know nothing about software/scripts, but try this:

https://www.zillowgroup.com/developers/api/zestimate/zestimates-api/
« Last Edit: April 05, 2023, 09:55:58 AM by lhamo »

RWD

  • Walrus Stache
  • *******
  • Posts: 6530
  • Location: Arizona
Re: how to get zillow values and put them in a spreadsheet
« Reply #6 on: April 05, 2023, 10:05:35 AM »
If you don't want to sign up for the API just to grab one number for your own house you should be able to scrape the page.
https://zapier.com/blog/google-sheets-importxml-guide/
https://oxylabs.io/blog/web-scraping-sheets

There's also an extension to allow saving a listing to Google Sheets. Maybe not exactly what you want but the resulting sheet might have some stuff you could use.
https://www.bardeen.ai/playbooks/zillow-property-to-google-sheets

Michael in ABQ

  • Magnum Stache
  • ******
  • Posts: 2626
Re: how to get zillow values and put them in a spreadsheet
« Reply #7 on: April 05, 2023, 10:53:39 AM »
I'll just start out by saying Zillow values are garbage.

However, if you wanted to do it manually you can just move your mouse along the home value history graph and get monthly numbers for the last 10 years. That will literally take 5 minutes and is probably faster/easier than trying to automate it in some way.

GilesMM

  • Handlebar Stache
  • *****
  • Posts: 1494
  • Location: PNW
Re: how to get zillow values and put them in a spreadsheet
« Reply #8 on: April 05, 2023, 11:21:08 AM »
I'll just start out by saying Zillow values are garbage.

However, if you wanted to do it manually you can just move your mouse along the home value history graph and get monthly numbers for the last 10 years. That will literally take 5 minutes and is probably faster/easier than trying to automate it in some way.


Zillow values can be excellent or terrible, depending on how the quality of the data used and its applicability to your home. If you live in a condo complex of 1000 identical units with several public sales per month, Zillow can be great. If you are in a custom home on an odd-size lot in a fringe enclave with zero public sales data, then Zillow (and you) are SOL.

 

Wow, a phone plan for fifteen bucks!