Zillow Advice: Other Pros - Is it possible to use ImportXML in google docs to keep my market prices current? If so, example? http://www.zillow.com/advice-thread/Is-it-possible-to-use-ImportXML-in-google-docs-to-keep-my-market-prices-current-If-so-example/470464/ Zillow Advice | Zillow Real Estate There appears to be a bug ... http://www.zillow.com/advice-thread/Is-it-possible-to-use-ImportXML-in-google-docs-to-keep-my-market-prices-current-If-so-example/470464/ There appears to be a bug in the Google Docs ImportXML() function itself, not in your code. Although it should be double quotes instead of single.<br/><br/>The following *should* work: <br/>=ImportXML("http://www.zillow.com/webservice/GetZestimate.htm?zws-id=&lt;my private ZWSID&gt;&amp;zpid=48749425","/zestimate/amount")<br/><br/>The bug is now somewhere in the backlog of fixes... who knows when it will work.<br/>https://productforums.google.com/forum/#!topicsearchin/docs/importxml|sort:relevance/docs/JlqjIzioL7M Tue, 29 Jul 2014 20:00:00 GMT http://www.zillow.com/advice-thread/Is-it-possible-to-use-ImportXML-in-google-docs-to-keep-my-market-prices-current-If-so-example/470464/ 2014-07-29T20:00:00Z The way I read paragraph ... http://www.zillow.com/advice-thread/Is-it-possible-to-use-ImportXML-in-google-docs-to-keep-my-market-prices-current-If-so-example/470464/ The way I read paragraph 2.b of Zillow's <a href="http://www.zillow.com/corp/Terms.htm">Terms of Use</a>:<br/><br/><em><strong>"Automated Queries.</strong> Automated queries (including screen and database scraping, spiders, robots, crawlers and any other automated activity with the purpose of obtaining information from the Services) are strictly prohibited on the Services, unless you have received express written permission from Zillow. As a limited exception, publicly available search engines and similar Internet navigation tools ("Search Engines") may query the Services and provide an index with links to the Services' Web pages, only to the extent such unlicensed "fair use" is allowed by applicable copyright law. Search Engines are not permitted to query or search information protected by a security verification system ("captcha") which limits access to human users.</em>"<br/><br/>&nbsp;such programming methods of obtaining updated Zestimates is not allowed unless one received written permission.<br/><br/>Besides, that doesn't get the Zestimate range, nor the rent-zestimates which is also important estimating data.<br/><br/>For spreadsheets, I find a better method is to have links to the properties of interest (or "favorites...), and to open the page, highlight the data, and copy it to the clipboard with "ctrl-C", then open notepad, and paste in the contents (ctrl-V), then highlight all (ctrl-A), copy to clipboard (ctrl-C), then in the Excel spread-sheet, paste (ctrl-V).&nbsp; The extra step to use note-pad is to preserve the tab characters that separate the data columns that would be lost otherwise.<br/><br/>Since this method is not automated, and since the spreadsheet and data lookup is for personal use only, it appears that it doesn't violate the terms of use with this method.<br/> Mon, 02 Dec 2013 04:38:00 GMT http://www.zillow.com/advice-thread/Is-it-possible-to-use-ImportXML-in-google-docs-to-keep-my-market-prices-current-If-so-example/470464/ 2013-12-02T04:38:00Z here's a poor mans way of ... http://www.zillow.com/advice-thread/Is-it-possible-to-use-ImportXML-in-google-docs-to-keep-my-market-prices-current-If-so-example/470464/ here's a poor mans way of getting zestimates in google spreadsheet:&nbsp; <p class="p2">=dollar(right(left(concatenate(ImportData("&lt;Enter Zillow URL here&gt;")), find("data['zestimate'] =",concatenate(ImportData("&lt;Enter Zillow URL here&gt;")), 2)+27), 7),-2)<br/><br/>PS: hardcoded for 7 figure properties. This part of the code ...&nbsp;+27), 7 ... needs to be tweaked manually or one could use another layer of right-left-find to get rid of the single quotes<br/><br/>hope you find it useful</p> Mon, 02 Dec 2013 04:14:00 GMT http://www.zillow.com/advice-thread/Is-it-possible-to-use-ImportXML-in-google-docs-to-keep-my-market-prices-current-If-so-example/470464/ 2013-12-02T04:14:00Z Been frustrated trying to ... http://www.zillow.com/advice-thread/Is-it-possible-to-use-ImportXML-in-google-docs-to-keep-my-market-prices-current-If-so-example/470464/ Been frustrated trying to grab Zestimates directly into a Google Spreadsheet via the importXML() function inside of the spreadsheet.<br/><br/>I have a "Zillow Web Services Identification (ZWSID)" that I got here:&nbsp;<a href="http://www.zillow.com/howto/api/APIOverview.htm">http://www.zillow.com/howto/api/APIOverview.htm</a>.<br/><br/>A sample zestimate api call can be seen here:&nbsp;<a href="http://www.zillow.com/howto/api/GetZestimate.htm">http://www.zillow.com/howto/api/GetZestimate.htm</a><br/><br/>Google Spreadsheets has a function called "importXML()". It uses xpath to parse the xml and pull values. As Tim above noted this is a good explanation:&nbsp;http://www.distilled.net/blog/distilled/guide-to-google-docs-importxml/<br/><br/>I&nbsp;believe&nbsp;my problem is the "xpath" part of the function. Here's what I tried in Google Spreadsheets:<br/>=ImportXML('http://www.zillow.com/webservice/GetZestimate.htm?zws-id=&lt;my private ZWSID&gt;&amp;zpid=48749425','/zestimate/amount') <br/>Google Spreadsheet returns "error: Parse error". So I think the Spreadsheet is finding the Zillow page but having trouble parsing it.<br/><br/>Any one having luck grabbing this data into Google Spreadsheets?<br/><br/> Tue, 26 Nov 2013 04:27:00 GMT http://www.zillow.com/advice-thread/Is-it-possible-to-use-ImportXML-in-google-docs-to-keep-my-market-prices-current-If-so-example/470464/ 2013-11-26T04:27:00Z Actually, since Google's ... http://www.zillow.com/advice-thread/Is-it-possible-to-use-ImportXML-in-google-docs-to-keep-my-market-prices-current-If-so-example/470464/ Actually, since Google's XML parser is very forgiving, you can use ImportXML to read in almost any HTML page, and use the XPath syntax to lookup values. &nbsp;Here's a tutorial:&nbsp;http://www.distilled.net/blog/distilled/guide-to-google-docs-importxml/ Fri, 05 Apr 2013 18:06:00 GMT http://www.zillow.com/advice-thread/Is-it-possible-to-use-ImportXML-in-google-docs-to-keep-my-market-prices-current-If-so-example/470464/ 2013-04-05T18:06:00Z Thanks for the prompt reply. ... http://www.zillow.com/advice-thread/Is-it-possible-to-use-ImportXML-in-google-docs-to-keep-my-market-prices-current-If-so-example/470464/ Thanks for the prompt reply. &nbsp;Sorry, I thought you were an API pro! &nbsp;Not sure how I found your name now. &nbsp;I've just spent a frustrating hour poking around the API site looking for a contact, but no luck!<br/><br/>Perhaps someone will come to my rescue. &nbsp;I'm sure I'm not the first to ask this question! Wed, 05 Dec 2012 19:46:00 GMT http://www.zillow.com/advice-thread/Is-it-possible-to-use-ImportXML-in-google-docs-to-keep-my-market-prices-current-If-so-example/470464/ 2012-12-05T19:46:00Z It does make sense John!&nbsp;I ... http://www.zillow.com/advice-thread/Is-it-possible-to-use-ImportXML-in-google-docs-to-keep-my-market-prices-current-If-so-example/470464/ It does make sense John!&nbsp;<br/><br/>I *think* that you'd need to use the Zillow API for this, not the XML data. Unfortunately, the API is way outside my area of expertise. Perhaps someone more&nbsp;knowledgeable about the API (and/or Google docs) will stop by.<br/><br/>More info on the API is here: http://www.zillow.com/howto/api/APIOverview.htm&nbsp; Wed, 05 Dec 2012 19:31:00 GMT http://www.zillow.com/advice-thread/Is-it-possible-to-use-ImportXML-in-google-docs-to-keep-my-market-prices-current-If-so-example/470464/ 2012-12-05T19:31:00Z Let me clarify what I I'm ... http://www.zillow.com/advice-thread/Is-it-possible-to-use-ImportXML-in-google-docs-to-keep-my-market-prices-current-If-so-example/470464/ Let me clarify what I I'm trying to do. &nbsp;I have calculation in a google spreadsheet that uses the Zillow market estimate of a home. &nbsp;Currently, I&nbsp;manually&nbsp;go grab that number from Zillow and enter it in to the cell. &nbsp;I'd like to automate that process. &nbsp;Google spreadsheets has a function called importXML(URL, xPath) which will&nbsp;retrieve&nbsp;1 or more values from an XLM file.<br/><br/>So bottom line, all I want is a URL that will&nbsp;retrieve&nbsp;the homes value.<br/><br/>Make sense? Wed, 05 Dec 2012 18:45:00 GMT http://www.zillow.com/advice-thread/Is-it-possible-to-use-ImportXML-in-google-docs-to-keep-my-market-prices-current-If-so-example/470464/ 2012-12-05T18:45:00Z First, you'd need the data ... http://www.zillow.com/advice-thread/Is-it-possible-to-use-ImportXML-in-google-docs-to-keep-my-market-prices-current-If-so-example/470464/ First, you'd need the data in XML format (which seems like an odd format for something like market prices. Are you pulling this from existing web pages? Be careful, that may very well violate some copyright or data usage agreement)). But if you have this data in XML, then it would probably work. XML import isn't the easiest thing to accomplish. This may help in that effort: http://www.distilled.net/blog/distilled/guide-to-google-docs-importxml/<br/><br/>I don't fully understand your question. What exactly is it you're hoping to accomplish? How many properties do you need to update?<br/><br/>&nbsp; Wed, 05 Dec 2012 18:28:00 GMT http://www.zillow.com/advice-thread/Is-it-possible-to-use-ImportXML-in-google-docs-to-keep-my-market-prices-current-If-so-example/470464/ 2012-12-05T18:28:00Z