CODEWITHSUNDEEP
google-apps-scriptpermissions
user1938223
user1938223

Reputation: 11

Google scripts in google sheets, is permission for all users?

I've written a tiny script/ macro in google sheets when an image is clicked, some boxes in cells get unticked, when I first used clicked it myself, I had to give permission for myself.

My question is, the other user that I share these sheets with, will they now have permission automatic permission?

I ask because they are not computer literate and won't be able to grant themselves permission.

Upvotes: 1

Views: 1689

Answers (1)

Iamblichus
Iamblichus

Reputation: 19309

Apps Script scans the code automatically and determines which are the authorization scopes. In this case, all users you share the spreadsheet with will have to grant explicit permission for the script to modify the file on their behalf. This cannot be avoided.

Check this out for more information: https://developers.google.com/apps-script/guides/services/authorization

Upvotes: 1

Related Questions