- There is a sheet that is shared with writing permissions to users
A
andB
. - Column
X
is protected and can be edited only by userA
. - User
B
should use a script with userA
permissions to edit columnX
.
From reading the various documentation (https://developers.google.com/apps-script/guides/services/authorization), I understand that there are two ways to run a script on a google sheet as a different user.
- Using the python api (https://developers.google.com/sheets/api/quickstart/python). The disadvantages: either launches from the cmdline, or Google's App Engine which is not free.
- Using a WebApp. My problem with that solution, and perhaps this is what I am missing, is how to edit a cell with the
doGet
anddoPost
. All the examples that I saw were using the google script to edit the cells, which slammed me back to the permissions issue.