11–20 of 171 posts
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.
Couldn't you cache the reads? Not many usages really require real-time from their data store.
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.)
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 :)
Do you have any bad data entry prevention?
There's a help page that gives you all the code you need to do this. https://developers.google.com/sheets/api/quickstart/js
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. [0] https://pocketbase.io/ [1] https://developers.google.com/sheets/api/limits
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.
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.
My Google API rate limit is way bigger then 60/minute.
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.…
From what I see, the Common Name for the cert at https://zerosheets.com is `*.ip-66-228-52-143.cloudezapp.io` rather than zerorsheets.com. It's issued by Let's Encrypt. www.zerosheets.com is issued by Amazon. Hope that helps.
The solution? Export them all to a Google Sheet with one tag per column. Edit and apply-on-save. Filter, sort, summarize, pivot all the much you want. It's incredible.