I recently created a project on Google Apps Script through which employees of a company can know their salaries, and more than 50,000 thousand people will use it. The first question is: If the number of users of the project that I created increases, will it lead to the project being disrupted or causing any confusion in it? Secondly, I fear that Apps script will be stopped in the future and my project will collapse.
Though I'm not a Google employee, I'm fairly certain that Apps Script isn't going away.
You might bump into usage limits if 50K runs of your script are expected to happen. There are likely better implementation schemes that would scale to that level of use.
Do you have information about the number of users allowed to log in at once for the project that I designed on Apps Script? For example, if 1000 users or employees log in at once, will it cause a problem or disrupt the project
It would appear that 1000 simultaneous executions of an Apps Script are allowed.
ref: Workspace: Apps Script / Reference / Quotas for Google Services
Regarding the first question:
If your Google Apps Script application is designed with scalability in mind (e.g., optimizing requests, using caching, or asynchronous triggers), it can handle high user loads effectively. However, you must account for platform limitations, such as quotas on function call frequency and script execution time. To minimize risks, consider splitting the logic into multiple scripts or offloading heavy tasks to external cloud services (e.g., Cloud Run).
Regarding the second question:
Google Apps Script has been actively maintained for over 15 years and is deeply integrated into Google Workspace, making its sudden discontinuation highly unlikely. That said, for mission-critical projects, it’s wise to plan a backup strategy -- for example, gradually migrating functionality to more flexible cloud platforms (Cloud Functions, Firebase, etc.). This ensures long-term flexibility and control over your project.
Cheers!
@Haider1 you will most likely run into the limit of 30 scripts running at the same time on your account if you have that many users (unless the users are running the script using their own accounts). We have ran into this limit previously with some of our scripts, with less users.
Apps Script is not designed for that many users accessing one script ran by one account. You'd be much better looking at App Sheet potentially instead as there's no limit on concurrency and you just need to ensure you partition the data via security filters (and not reply on Apps Script). Without knowing how and where you're storing your data it's difficult to answer the question.