Protect Google Sheet

[Phil_Waite]

Hi,

If I set some sheets in googlesheet to be protected do I have to give every user on my app permision in the sheet to edit or can they use they use the app and change the sheet through that without it.

The reason is that I would like someone to work on google scripts etc (and fix some things) but without the ability to edit/delete etc the actual data in the sheets. I can protect the sheets but do I need to add every app user (9 of them) as able to edit.

Many thanks

Phil

[Steve]

It depends on the Access mode setting for the table:

If set to as app creator (the default, and most common), the owner of the app must have full access to the spreadsheet. If set to as app user, each app user must have sufficient access to make the changes the app will make to the spreadsheet.