How is this any different than just getting the json feed for the sheet? I find it much more flexible.
You can POST your data. PUT and DELETE soon.
Show HN: Turn a Google Spreadsheet into an API
41–50 of 103 posts
Re: Show HN: Turn a Google Spreadsheet into an API
#421. How to get columns? 2. Your docs say: http://sheetsu.com/apis/12345/column/:column_name Is ':' a documentation convention somewhere that I've not come across? I tried: http://sheetsu.com/apis/12345/column/:Email http://sheetsu.com/apis/12345/column/:email until I realised it was just: http://sheetsu.com/apis/12345/column/Email
Yes, it's just /column/Email.
[deleted]
Re: Show HN: Turn a Google Spreadsheet into an API
#431. How to get columns? 2. Your docs say: http://sheetsu.com/apis/12345/column/:column_name Is ':' a documentation convention somewhere that I've not come across? I tried: http://sheetsu.com/apis/12345/column/:Email http://sheetsu.com/apis/12345/column/:email until I realised it was just: http://sheetsu.com/apis/12345/column/Email
the colon is meant to show/explain the following is a variable
Re: Show HN: Turn a Google Spreadsheet into an API
#44I've used Google Spreadsheet as an "API" before (manually, not using this wrapper), and it is definitely not made to be used as such. Under heavy load, it slows down or times out, and even under the best circumstances it's not exactly fast.
It's great in a pinch. My use-case was a spreadsheet that others in my organization wanted to edit, then we'd pull the data onto a web page and display nicely. It worked, but eventually we had to set up a secondary server to cache the spreadsheet result because pulling directly from Google in realtime was too unreliable.
Re: Show HN: Turn a Google Spreadsheet into an API
#45Sort of related (but the other way around): https://www.blockspring.com/
Re: Show HN: Turn a Google Spreadsheet into an API
#46I've used Google Spreadsheet as an "API" before (manually, not using this wrapper), and it is definitely not made to be used as such. Under heavy load, it slows down or times out, and even under the best circumstances it's not exactly fast. It's great in a pinch. My use-case was a spreadsheet that others in my organization wanted to edit, then we'd pull the data onto a web page and display nicely. It worked, but even…
Thanks for sharing. It's clear this approach works for small datasets and if you want something more reliable under heavy load just go for a proper database. Might work well with prototypes though.
Re: Show HN: Turn a Google Spreadsheet into an API
#47Every year, twice a year someone posts this solution. We get it. You hack.
Re: Show HN: Turn a Google Spreadsheet into an API
#48This is great! I want to build an app that can insert transactions on the go into my existing budgeting spreadsheet, and this really takes away a lot of the dirty work.
Re: Show HN: Turn a Google Spreadsheet into an API
#49Every year, twice a year someone posts this solution. We get it. You hack.
So? Out of the thousands of people that frequent this site, a tiny percentage of them make this, and it's cool for people that have never seen it.
Also, relevant xkcd. https://xkcd.com/1053/
Re: Show HN: Turn a Google Spreadsheet into an API
#50Nice way to bypass zapier.com for some simple stuff because they can get expensive quickly. I just started using it to store a log of supersaas.com appointments in a Google spreadsheet, works great.