https://github.com/benborgers/opensheet#readme Is the best and simplest tool for turning Google Sheets accessible quickly.
not if you need authentication...
Readit Newsjoaovcoliveira commented on Show HN: Using Google Sheets as the back end/APIs of your app zerosheets.com/... · Posted by u/joaovcoliveira
joaovcoliveira commented on Show HN: Using Google Sheets as the back end/APIs of your app zerosheets.com/... · Posted by u/joaovcoliveira
Funny story. Before pivoting my startup to Loom, we were a user testing company named Opentest. Instead of spinning up a DB and creating a dashboard for my co-founders to look at who requested certain user tests, I just dumped everything into a Google Sheet. It was so good. No downtime. Open access. Only 3 people looking/editing, so no conflict. Didn't have to deal with database upgrades or maintenance. I often think about this decision and feel like I've learned a bunch of "good engineering practices" that pale in comparison to how being truly scrappy can be a genius unlock at any level.
its a honor to hear from a loom founder, Ive been using your product for a long time and I love it! 100% onboard on what you said.
joaovcoliveira commented on Show HN: Using Google Sheets as the back end/APIs of your app zerosheets.com/... · Posted by u/joaovcoliveira
Is the Google Sheets API rate limit open enough for actual production use?
I thought it was pretty restrictive, no more than 60 writes per minute, but I'm not sure about the reads restrictions.
For now I`m setting no restrictions. Since it is an MVP, I`m trying to understand what a basic and a hard user would be. After a while, Ill figure out how to charge for it and what limitations should a free and a paid user have.
My Google API rate limit is way bigger then 60/minute.
joaovcoliveira commented on Show HN: Using Google Sheets as the back end/APIs of your app zerosheets.com/... · Posted by u/joaovcoliveira
I'd like to plug PocketBase [0] for a similar use case.
Last week I was looking for a place to store random data with API access, and was looking at making a Google Sheets backend, but PocketBase was easy and didn't have a 60 rpm quota [1].
Deploying to a cheap VPS was very easy with CapRover.
I loved your product!!
My infrastructure is 100% focused in scale so I think we can work together, we just need to share the costs.
Please send me a message here https://www.zerosheets.com/contact so I can get your contact.
joaovcoliveira commented on Show HN: Using Google Sheets as the back end/APIs of your app zerosheets.com/... · Posted by u/joaovcoliveira
There's a help page that gives you all the code you need to do this. https://developers.google.com/sheets/api/quickstart/js
Yep, if you want to implement it from scratch, thats an option (way more painfull then using zerosheets) :)
joaovcoliveira commented on Show HN: Using Google Sheets as the back end/APIs of your app zerosheets.com/... · Posted by u/joaovcoliveira
Do you have any bad data entry prevention?
Yes
joaovcoliveira commented on Show HN: Using Google Sheets as the back end/APIs of your app zerosheets.com/... · Posted by u/joaovcoliveira
Great concept. Congrats on launching.
Do you have a sense for how much usage Google will allow on a given sheet or user? I.e. will Google shut down the API after a certain usage level?
(Side-note, your SSL cert seems to be having trouble, i.e. www.zerosheets.com is correctly encrypted, zerosheets.com is not.)
Hello!!
Google limits for me are:
300 Read requests per minute 300 Write request per minute
Since Ive just launched it, that number is far far away from being reach. (If it happens, the number can be increased).
Regarding the SSL cert, some other users pointed the problem but I can`t replicated. Tried with many different browsers. Im not sure about whats happening, it`s always working for me but I will keep digging.
Thank you for your comment bro :)
Deleted Comment