Prevent Users from Manually Editing the Spreadsheet

Question

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?

doubleunary · Accepted Answer · 2022-11-30 14:18:50Z

1

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.

answered Nov 30, 2022 at 14:18

doubleunary

21.9k13 gold badges38 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Emily George Over a year ago

cool it's working! thanks however the Session.getActiveUser().getEmail(); is no longer working. :(

doubleunary Over a year ago

Please ask only one question per post.

Emily George Over a year ago

hi i tested with our email address with same domain. it is working fine. thanks a lot!

Wicket Over a year ago

@doubleunary This isn't the first OP's question. They already have 7 questions (not counting deleted questions)

Collectives™ on Stack Overflow

Prevent Users from Manually Editing the Spreadsheet

1 Answer 1

4 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Related