I have Google spreadsheets of home addresses.
I need the spreadsheet to access Zillow's Property Details API to receive the bedrooms, bathrooms, square footage, year built, lot size and have the information auto-fill the spreadsheet. Additionally we need to access Zillow's Zestimate API to receive all the Zillow Zestimates, we would also like this function to automatically auto-fill the low, average and high Zestimate for each property address in our Google spreadsheet. We have the ZSID for this.
The spreadsheet should only fetch the fields once (not re-fetch the same field since Zillow only allows 1,000 requests each day)