A spreadsheet that will utilize an api to look up zestimates based on the data in the spreadhseet -- 2

I have a spreadsheet that has addresses in columns a,b,c,d, (address, city, state, zipcode). I want to have a button that runs a script/macro that looks up the zestimate, and returns the zestimate in column e. I know that there is other data that can also be pulled, like number of bedrooms, and bathrooms, and last sale date. It would be good to also have that information in the spreadsheet as well, but the primary data is the zestimate (from zillow.com). There is an api interface that will provide that info, and I have been able to get one address at a time in an xml file, I don't know how to get that back into the spreadsheet in a row