Interestingly, I had the need to make a spreadsheet available as an API and ended up using very simple appscript to archive this a few days ago. I shared it in my blog here, perhaps it might be useful for someone here.

http://blog.ebfe.pw/posts/sheet2api.html