Can a Google Apps Script Web App be scalable?

0
votes

I'm developing a Google Apps Script Web App. This web app is the next version of FlipVideo, a script that I previously developed in a Google Sheet (see version at https://sites.google.com/view/flipvideo/)

This is a school oriented web app. A lot of students will access at the same time from around the world (thousands probably). I'm worried about scalability and quota limits.

I will publish the web app using "Execute the apps as: user accessing the web app" and "Who has access the app: anyone". Could this configuration allow thousands of concurrently executions or there is a hard quota impossible to scale?

Your support will be appreciated.

Cheers,

Dani

1
google-apps-scriptweb-applicationsconcurrency
This information is not for a web app, but I thought I'd mention it. I looked at your site, and I notice that the user can make a copy of a spreadsheet. If the code is running from a spreadsheet that they own, then any quota limit goes against their account. Also, if you published the code as a Sheets add-on, then every account that installed the add-on has it's own quota limit. And even though you are the owner of the script file, none of the quota goes against your account. You could have millions of users of your add-on, and not have any quota limit against your account. - Alan Wells

1 Answers

1
votes

Unfortunately, what you require is not currently possible. GAS Web Apps have a max of 30 concurrent users (see simultaneous executions under current limitations on the quotas page). You'll need to leverage a different solution to operate at such a large scale. If you want to stick with Google's Cloud Platform I would recommend using Cloud Functions. However, its not a free service.