how to increase user cap on apps script?

52 views
Skip to first unread message

Moe

unread,
May 26, 2021, 6:24:58 PM5/26/21
to Google Apps Script Community
hi guys, 

i have some sheets setup for a video game.

i have a script that takes data that is entered on one sheet and moves it to another sheet then clears the data on the first sheet.

and up to 200 people need to be able to use it, and at the moment once it hits 100 people the script then is blocked for any new users added to the sheets and they cannot us it.

is there a workaround in order to increase the user cap of 100?

any help would be appreciated.

cbmserv...@gmail.com

unread,
May 26, 2021, 6:27:21 PM5/26/21
to google-apps-sc...@googlegroups.com

Does it have to be a spreadsheet where they enter the data? Can you use forms instead? That would bypass any cap that you are hitting.

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/392cd706-84fb-4279-813e-2ce2de941d2dn%40googlegroups.com.

Alan Wells

unread,
May 26, 2021, 8:01:36 PM5/26/21
to Google Apps Script Community
If the problems is because the code has not been verified by Google, then you need to request verification for your "app."
And in order to do that you need to create a standard GCP project and associate it with your Apps Script project.
See:
The biggest problem is if you are using restricted scopes, which requires you to pay for a security assessment.
The minimum cost is $15,000 dollars.
There are basically two restricted scopes, full access to the users Gmail, and full access to their Drive.
If you don't need either of those, then you're probably using sensitive scopes rather than restricted scopes.

Moe

unread,
May 26, 2021, 10:30:22 PM5/26/21
to google-apps-sc...@googlegroups.com
No restricted info is kept on these sheets. Only players in-game names etc. But they need to login to sheets. Thats about it.

I am testing getting my app verified on a dummy set of sheets for now. Just need to work out what i am missing. How long does verification take?

Reply all
Reply to author
Forward
0 new messages