Home Value Ideas

Hi Team,

With the the Zillow API no longer active, anyone find another way to pull in home values?

Thank you,

Brandon

My process is 100% manual but not terribly painful. I have a short list of things to do on the first day of the month: grease the treadmill, add enzymes to the drains, check my FICO score and update my Zillow price in Tiller.

I manually created an account or my condo and then grabbed the price from Zillow.

Now, on the 1st of every month:

I grab the new price
I copy the transaction line from the first of last month
Change the date, update with the Zillow price

And I’m good for a month.

4 Likes

Similar here, without the treadmill and the enzymes. I do a manual account update with the latest Zillow value once a week or two. Seems like it would be possible to do a web scrape from Zillow, Redfin, Trulia or Realtor, (Ideally I’d love to scrape them all and then do an average) but Googling around I didn’t see anyone with pre-made scripts to do that, so I’m guessing it isn’t as easy as it sounds.

That would be very cool!

Great workflow @susandennis!

I’m curious, do you feel that the manual update in the Balance History sheet by copying / pasting the row from last month is easier/better than using the Tiller Money Feeds add-on to update the balance manually? Just an interesting user experience choice :slight_smile:

Actually it’s pretty much 6 of 1/half dozen of the other. But probably slicker to do it your way I just need to remember next month. :slight_smile:

I use the manual account update for my Zillow and KBB accounts. It’s painless enough. :slight_smile:

Here’s a script you can add to your sheet to update based on Zestimate. This script will not add it to your “Balance History Sheet”, but instead adds it to a sheet called “Zillow”. (You’ll need to create that sheet if you haven’t already). Use this if you’re just looking to track separately and don’t have a manual account to track the property, or you just want to write your own formulas to have fun with the data.

Google Sheets Zillow Import Script (github.com)

Follow the instructions in the first comment if you just have one, I added a comment below to handle multiple zillow properties.

Here is a script that will handle adding it to your Balance History sheet, but you need to be sure to replace everything that has percent signs in the scripts with your actual info. It assumes you already have a manual account set up that you want to update. I haven’t decided on a way to make this work for multiple properties yet, so this works with just one for now.

Zillow Tiller Sheets Importer with balance history (github.com)

Of course, the magic is in adding the script to the script triggers to make it run weekly/monthly/on open/whatever. Anyways, let me know if you have any issues. I hope this helps or gets you pointed in the right direction.

2 Likes

Now that’s an interesting idea, grabbing from multiple sites and grabbing the average price. I’ll see what I can do…

4 Likes

I also update it manually. One of my accounts requires two factor authentication to update so I do both mid-month and at the end of the month.