Sheety

Turn your Google Sheet into an API instantly, for free

get it
#2 Product of the WeekFebruary 04, 2019
+1

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.
  • Andrei Panturu
    Andrei PanturuFounder at Scriptgun
    Pros: 

    Very easy to use and insanely fast

    Cons: 

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

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

    Andrei Panturu has used this product for one day.

Discussion

Hunter
Makers
You need to become a Contributor to join the discussion.
PC
PCMaker@phillipcaudell · Dangerously under qualified®
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.
Annie Don
Annie Don@annie_don1
@phillipcaudell yes yes yes thank you
Ben Tossell
Ben Tossell@bentossell · Makerpad.co
@phillipcaudell this is awesome! Like the site design too - I have some similar 3D blocks ha. Will definitely do tutorials with this!
Dan Dan
Dan Dan@tostartafire · Web Dev.
lol... perhaps the worst name for an app. Just ask any non native english speaker the name of your app.
Annie Don
Annie Don@annie_don1
@tostartafire likely on purpose :P
PC
PCMaker@phillipcaudell · Dangerously under qualified®
@tostartafire Sheety – Helping you make sheety APIs®
Quinston Pimenta
Quinston Pimenta@quinston · Solving problems and being aesthetic
@tostartafire @phillipcaudell I think I laughed a little too hard on this one.
Ernest Oppetit
Ernest Oppetit@ernopp · PM @ Improbable
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...
PC
PCMaker@phillipcaudell · Dangerously under qualified®
@ernopp Speed to get something up and running. Their Quickstart isn't very quick (authorisation, API keys, etc – yuck!) https://developers.google.com/sh...
Oleksandr Torlo
Oleksandr Torlo@evilksandr · R&D of my own projects
@ernopp @phillipcaudell There is a little bit easier way, see example in my comment below
Oleksandr Torlo
Oleksandr Torlo@evilksandr · R&D of my own projects
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
PC
PCMaker@phillipcaudell · Dangerously under qualified®
@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/...
Oleksandr Torlo
Oleksandr Torlo@evilksandr · R&D of my own projects
@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
Jitesh Dugar
Jitesh Dugar@jitesh_dugar · Indie Hacker
This looks awesome and very useful for makers. Do you plan to add a pricing beyond a certain number of API requests/hour?
PC
PCMaker@phillipcaudell · Dangerously under qualified®
@jitesh_dugar Free forever as it's so simple to run! I'll probably add the ability to buy nicer URLs / rename your endpoints.
Tim Walling
Tim Walling@twalling · Full-stack maker
@phillipcaudell consider a donation model... you may at least get enough from people to cover what little costs you have
PC
PCMaker@phillipcaudell · Dangerously under qualified®
@twalling I've got a donation link at the bottom of the page, but perhaps I need to make it a little more prominent 😜
Garet McKinley
Garet McKinley@garetmckinley · Frontend Engineer Available for Hire
@twalling @phillipcaudell It also might be worth thinking about open sourcing it and running an open collective. That way there would be zero risk for adoption, as other people could spin up their own servers if yours goes down or they need it for a serious project.