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.

Reviews
  • Pros: 

    Awesome! Saves a lot of time

    Cons: 

    How can this be free? Insane

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

    Antônio Guilherme Ferreira Viggiano has never used this product.
  • Stephen Parker
    Stephen ParkerVirtual Assistant, Zirtual
    Pros: 

    Excellent Idea Great execution Amusing FAQ

    Cons: 

    None that I've seen yet!

    This is brilliant! Great work!

    Stephen Parker has used this product for one day.
Discussion
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.
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
It'd be great to be able to authenticate with Google to access private sheets.
What is the advantage of this over the Google Sheets REST API, which will presumably be much better maintained and documented? https://developers.google.com/sh...
Maker
@ernopp Speed to get something up and running. Their Quickstart isn't very quick (authorisation, API keys, etc – yuck!) https://developers.google.com/sh...
@ernopp @phillipcaudell There is a little bit easier way, see example in my comment below