CODEWITHSUNDEEP
google-apps-scriptgoogle-sheetsweb-applications
Emily George
Emily George

Reputation: 29

Prevent Users from Manually Editing the Spreadsheet

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?

Upvotes: 0

Views: 185

Answers (1)

doubleunary
doubleunary

Reputation: 19239

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.

Upvotes: 1

Related Questions