Phillip Caudell

Sheety 2.0 - Turn your Google Sheet into a fully RESTful API

byโ€ข
Turn your Google Sheet into a fully RESTful API. Power websites, apps, or whatever you like, all from a spreadsheet.

Add a comment

Replies

Best
Phillip Caudell
Hello Product Hunt! Earlier this year I launched Sheety V1 which let you do basic reads from your Google Sheet via a JSON API. Since then over 800,000 people have used Sheety, and we serve nearly 80GB of sheets per month โ€“ you guys love spreadsheets! Today I'm launching Sheety V2 which now lets you write to your sheet. You can use standard RESTful interactions: GET, POST, PUT and DELETE. It's also blazing fast: updates happen in realtime. Getting up and running is as simple as connecting your Google account to Sheety, then pasting the spreadsheet URL: schemas and endpoints are generated automatically. I built Sheety V2 as I spend a lot of my timing prototyping new ideas, and wanted a quicker way of putting together realistic experiences that can be used in the wild! I can't wait to see what you do with Sheety and would love your feedback :-) Cheers
Lasse R
Scary to have a dependency with another direct dependency which could turn off access anytime. However definitively cool and interesting. For prototyping and more Iโ€™d definitively say itโ€™s worth a shot
Ruben Martinez Jr.
@lasserafn Caveat, I don't use Sheety, but I implemented something similar to it, and I felt pretty okay about it knowing I could very easily upload a CSV somewhere else on the cloud to fallback to "just in case".
Alex Conway
This looks super awesome and useful! Super clean and well explained landing page... Well done Phillip! :)
Toby Schneider
I really like the idea, but i don't like the pricing model. You should really concider expanding the free plan 500 requests per month is nothing.
Phillip Caudell
@tsndr thanks for the feedback! Hopefully 500 requests is enough to see if Sheety is a fit for your project, after which it's only $0.0001 per request!
Steve Schofield
Sheety v1 was super useful, so Sheety V2 sounds like a great upgrade. This is how Google Sheets public API should be. Great job @phillipcaudell
Phillip Caudell
@r3trosteve thanks Steve! ๐Ÿ˜€
Atishay Baid
looks super cool, however was just curios does google drive exposes api for reading and specially writing purposes.
Phillip Caudell
@atishaybaid Google Sheets has an API (which is what Sheety uses) however it's not plug-and-play for most use cases โ€“ย enter Sheety!
David Sancho
As a developer, I would love to have the capacity to consume the api as grapqhl. It would be really helpful to have typed queries, known which fields are being consumed (Benefits that with RESTful actually you can't). Good luck!
Garet McKinley
@david_sancho might not be exactly what you had in mind, but gatsby has a data source plugin for google docs. Which means that you can source data from a spreadsheet and query it using graphql, since that's the data layer that gatsby uses.
Manuel Frigerio
800K users!? That's insane man! Happy user here ๐Ÿ‘‹ Looking forward to using Sheety for my next project.
Joe Ward
Once you expose your endpoint in client-side JS, anyone could come along and wipe out your data by iterating through record/row IDs? Or write anything they want in there. So this is merely intended for prototyping, or there's another way to protect the data?
Joe Ward
Could there be a read-only Project Base URL (up-front, client, exposed), and one for full CRUD functions (out-back, server/password, guarded)?
Phillip Caudell
@joewardpr this is right Joe! You can create one project for read only (the client) and you can create another project with write access for your admin panel (or whatever), which can be protected with Bearer token or Basic Auth.
Joe Ward
@phillipcaudell Excellent. Thank you, Phillip!
Randal Walker
Incredible. I have followed this project for a long time. Amazed to see how much more work you have done on it. This is like the airtable of apis. Love it.
123
Next
Last