I created a web app using Google Apps Script and sharing the link with editor access to other users is needed, otherwise, their input in the web app will not be recorded in the the spreadsheet connected to it.

My worry is if they manually edit the spreadsheet since they have editor access to it.

Is there a way to prevent them from editing the sheet manually?

CodePudding user response：

Deploy the web app with the Execute the app as me option to run it under your account. You do not need to share the spreadsheet or the script with anyone.

See the Web App Demo answer for more information.