Sheety

Turn your Google Sheet into an API instantly, for free

#2 Product of the MonthFebruary 2019
+2

Turn any Google sheet into an API instantly, for free.

Power websites, apps, or whatever you like, all from a spreadsheet. Changes to your spreadsheet update your API in realtime.

Discussion
Would you recommend this product?
20 Reviews5.0/5

I'm afraid to become too dependent on it. How about an very friendly freemium model?

Pros:

Awesome! Saves a lot of time

Cons:

How can this be free? Insane

Maker
Judging by the warm reception here I'll most likely be adding a freemium model (probably pay to name your URLs rather than the randomly generated UUID's). I'll also be adding POST abilities too to send data back to the sheet. So hopefully that should give some reassurance!
Maker
Do you like cutting corners and questionable backends? Then oh have I got a product for you. I made Sheety so I could whip together prototypes and other experiences without the need to setup fiddly backends. Checkout an example API here: https://api.sheety.co/uk-theme-p... There's other Google Sheet to API services out there, but they were relatively pricey for what they did, and seemed a bit overkill for the types of prototyping I was doing.
@phillipcaudell yes yes yes thank you
@phillipcaudell this is awesome! Like the site design too - I have some similar 3D blocks ha. Will definitely do tutorials with this!
lol... perhaps the worst name for an app. Just ask any non native english speaker the name of your app.
@tostartafire likely on purpose :P
Maker
@tostartafire Sheety – Helping you make sheety APIs®
@tostartafire @phillipcaudell I think I laughed a little too hard on this one.

I think this is a good starting point of making a great app.

Pros:

Very easy to use and insanely fast

Cons:

There is no way to get my old api links if i close the tab

Maker
Thanks for the feedback Andrei! I'll look into adding history.
Holy sheet! ;) 2 years ago I made a dashboard using GoogleSheets as a backend with this simple construction (for example): var url = "https://spreadsheets.google.com/..." + docID + "/od6/public/values?alt=json"; $.getJSON(url, function(data) { var entry = data.feed.entry; entry.forEach(function(item, index){ .... You can get DocID while publishing your Goolge Sheet to web
Maker
@evilksandr That sounds pretty neat, though I'm unable to get it to work. What might I be missing do you think? (I've made the spreadsheet public, tried the ID as well as the published ID which is slightly different) https://spreadsheets.google.com/...
@phillipcaudell The right full url is https://spreadsheets.google.com/... For the reference: My dashboard (made in two evenings) with GSheet as a backend - http://scoreboard.mbastrategy.co... JS-code http://scoreboard.mbastrategy.co... There is a function loadScoreBoard (docID, container) where you'll find an example of using this method