Google Sheets acting as a Cloud Data Host ?

[AmberEP]

With this test function on Apps Script :

I can write/read data on a spreedsheet. It acts as a cloud variable host. (here i only updated cell a5 value to test)

Using Turbowarp Http extension on the game :

Apart from google sheets limitations (1milion or 10milion cells i dont remmeber), i didn't face any limitation for now. and the time of a small request like this is 1-3s by average.
The only problem i met was when sending too many requests to a single cell, the value isn't updated correctly because some are late when writing etc... But this should happen in real situations, i sent a lot of requests just to test the limits.
I read somewhere that you couln't exceed 20000 requests if i'm right, but, within i made like 60000+ writing requests in 1 day without getting a limitation error message, so i wonder if there's a limit.

It is also possible to send mails (test it to generate verification codes to confirm players identities) using an apps script function

[SharkPool-SP]

Yes. Which is why I made

#1241

[AmberEP]

Thanks for that !
I saw your extension just after, when you said you had extensions on you gallery. I did see that a lot of them, are very useful ! I wonder if it's right to do that? just got to credit you right? I don't know, they're not in the public library so maybe it's for a reason, idk how extensions works.
I kept my function because i wasn't sure it was right

Regarding google sheets, my only wonder is : is it unlimited? Is there infinite available calls?

Also its quite off topic bit i would like the functions to be impossible to be called outside of turbowarp, and also to ensure no parameter can be modified when inside.
Because i'm gonna use it to store user data, i don't want them to run scripts to change the data etc.

It would be possible if i could hide some code in turbowarp but i don't know if it's ok with the spirit of turbowarp. I just want some code to be hidden not everything.

[SharkPool-SP]

It's not infinite, there's like a max of a million I think. The other questions I can't answer cuz of lack of knowledge of Google spreadsheets