Zoho Sheet has this “Link External Data” functionality, which can be used to mashup with data on the web. It can sync your Zoho spreadsheet with data in public CSV files, HTML tables and RSS feeds. Zoho Sheet will basically fetch data periodically from the configured URL and update the spreadsheet automatically. You can then analyze on the external data by applying formulas or drawing charts. You can also publish / embed the resultant chart or a specific range or the whole spreadsheet. It gives you ample possibilities to mashup data from the web. A word of caution: While fetching data periodically from external websites, especially HTML pages, make sure you agree to the terms and conditions of the website.
Here is a short presentation which walks you through the various steps involved in configuring External Data in Zoho Sheet. It takes an example of automatic import of data from a public Zoho Creator view. The same can be done on a private Zoho Creator view by enabling private permalinks in Zoho Creator.
(view the presentation in full screen for better clarity)
Are you using this feature already? If so, let us know how you are using it.