Sheety
p/sheety
Turn your Google Sheet into an API instantly, for free
Phillip Caudell
Sheety 2.0 — Turn your Google Sheet into a fully RESTful API
Featured
42
Turn your Google Sheet into a fully RESTful API. Power websites, apps, or whatever you like, all from a spreadsheet.
Replies
Manuel Frigerio
800K users!? That's insane man! Happy user here 👋 Looking forward to using Sheety for my next project.
Steve Schofield
I love it when a simple interface can unlock exponentially greater possibilities / that’s what Sheety does. Google Sheets with Sheety, do I need Airtable any more?
Steve Schofield
Any thoughts about adding events notifications/channels/subscriptions?
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! 😀
Joe Ward
Congrats on a cool idea that's taking off!
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.
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
Steren Giannini
I haven't use Sheety, but I have built so many apps pulling data directly from Sheet. It would be great if Sheety provided caching and fallback in case Sheet is down or rate limited (not sure if it does this today)
James Flores
Great product for quickly spinning up an API. Do you have more examples on filtering? I can't seem to get it to work.
Adeniji Ayo Charles
what a name
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!
Mirko Friedrich
Used v1 in production for some time. (Mad! But it worked well). Switching to subscription. Nice service. Works as advertised and saves a lot of time on prototypes and simple content management!
Jon Lehman
⭐️⭐️⭐️⭐️⭐️ 5/5 As a designer who sometimes pretends to know how to code, Sheety v1 has been a game changer. Before Sheety, I was reluctant to pursue any project/product idea that involved needing a database of any kind. But then I discovered Sheety, it was way more approachable compared to many other solutions and I was able to turn out an MVP quickly and easily. Since then I've dug into other more permanent solutions but it's thanks to Sheety for helping me ease into understanding databases. But I will probably start with Sheety again once it's time to turn out a new MVP. The above probably sounds like a fake testimony, but it is in fact a real one! Pinky promise. Also, particularly with Sheety V1's website I really appreciated the off-hand sense of humor! Love it @phillipcaudell, keep up the awesome work!
Phillip Caudell
@jon_lehman thanks Jon – so happy to hear!
Connor Brereton
This is such a good idea!
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".
Mario Scheliga
cool :) - just awesome
Aemal Sayer
I can't do a POST request, here is a screenshot of my postman: https://ibb.co/4PR1wQq
Phillip Caudell
@aemal_sayer hey Aemal, make sure you've enabled POST permissions in the endpoint settings (403 means it's disabled)
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.
Anna Costalonga
Great product I love it!
Rick M
Love the concept, but it being entirely dependant on a 3rd party not shutting down / having downtime would make it next to useless for many (myself included). Have you considered an on-premises version? And as an extension to that. What contingency have you put in place to ensure anyone wont be cut off from the api should you go out of business?
Phillip Caudell
@rick_m1 thanks Rick! A lot of my own projects (both personal and at work) are dependent on Sheety, so it's not going anywhere anytime soon!