3 ms·

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

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 :)

hankjacobs 2y ago
I get an error on Chrome as well. From what I see, the Common Name for the cert at https://zerosheets.com 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.
btown 2y ago
Have you thought about auto-installing https://developers.google.com/apps-script/guides/triggers https://developers.google.com/apps-script/guides/triggers into the connected sheet, and maintaining a cache of the data that you invalidate onEdit? Would likely improve read latency dramatically, though it would make reads eventually-consistent. To others seeing this - has anyone else ever tried this approach? Are there players out there who do this and have SOC II etc. data security measures?
- jpgvm 2y ago
  Disclaimer: I work at Glide but not on Google Sheets integration. Triggers/AppScript - not that I am aware of right now... Everyone I know doing stuff with GSheets (including Glide) is using a full-sync approach with an optimistic write layer of some sort. GSheets API frequently reports being unable to do things, sometimes because it's calculating (common for huge sheets), sometimes just because it's down, other-times because rate limits My impression is it's not a great API to build on directly. A trigger based system that captured writes and wrote them to an outbox sheet could drastically speed up the sync process however. The reason why we don't use that approach is there isn't APIs sufficient to setup this sort of thing automatically (last time I checked at least) and it makes changes to the users sheets which isn't impossible to live with but is distasteful.
davidraedev 2y ago
Same issue here. At least on firefox initially the bare domain shows the error, but if you visit www and then try to load the bare domain it will then redirect to www on subsequent loads. I was able to replicate in a private window.
buzer 2y ago
curl is good for isolating issues. Here's requests to https://zerosheets.com https://zerosheets.com & https://www.zerosheets.com https://www.zerosheets.com: https://gist.github.com/Buzer/67adedefe59f9efdf3b16b0b8def117a https://gist.github.com/Buzer/67adedefe59f9efdf3b16b0b8def11...

hankjacobs 2y ago

I get an error on Chrome as well. From what I see, the Common Name for the cert at https://zerosheets.com 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.

btown 2y ago

Have you thought about auto-installing https://developers.google.com/apps-script/guides/triggers https://developers.google.com/apps-script/guides/triggers into the connected sheet, and maintaining a cache of the data that you invalidate onEdit? Would likely improve read latency dramatically, though it would make reads eventually-consistent. To others seeing this - has anyone else ever tried this approach? Are there players out there who do this and have SOC II etc. data security measures?

jpgvm 2y ago
Disclaimer: I work at Glide but not on Google Sheets integration. Triggers/AppScript - not that I am aware of right now... Everyone I know doing stuff with GSheets (including Glide) is using a full-sync approach with an optimistic write layer of some sort. GSheets API frequently reports being unable to do things, sometimes because it's calculating (common for huge sheets), sometimes just because it's down, other-times because rate limits My impression is it's not a great API to build on directly. A trigger based system that captured writes and wrote them to an outbox sheet could drastically speed up the sync process however. The reason why we don't use that approach is there isn't APIs sufficient to setup this sort of thing automatically (last time I checked at least) and it makes changes to the users sheets which isn't impossible to live with but is distasteful.

davidraedev 2y ago

Same issue here. At least on firefox initially the bare domain shows the error, but if you visit www and then try to load the bare domain it will then redirect to www on subsequent loads. I was able to replicate in a private window.

buzer 2y ago

curl is good for isolating issues. Here's requests to https://zerosheets.com https://zerosheets.com & https://www.zerosheets.com https://www.zerosheets.com: https://gist.github.com/Buzer/67adedefe59f9efdf3b16b0b8def117a https://gist.github.com/Buzer/67adedefe59f9efdf3b16b0b8def11...