In trying to figure out how to avoid updating this manually, I figured out how to populate it via the importxml() function.
The formula is:
=split(IMPORTXML("URL OF YOUR HOME ON ZILLOW","//div[contains(@class, 'zestimate primary-quote')]"),":")
The split() function gives you the "Zestimate" text in one cell, and the actual dollar value in the adjacent cell.
Guarantee there's a way to just get the dollar value isolated if you care enough to do more with the xpath or monkey with some regex or other functions. This is the best way I could figure out with 5 minutes of patience.
Submitted March 01, 2019 at 02:13AM by haltingpoint https://ift.tt/2IJ4V8c
