How to run a spreadsheet bound script as the creator (not viewer/editor) -


i made script spreadsheet, uses trigger , sendemail functionalities. have menu items in spreadsheet control these triggers , sendemails.

now when share spreadsheet other, when tried access trigger or sendemail functions menu, script asks authorization user. if authorized function user. e.g. send email user or make new trigger user. makes things double , useless

i want user accessing script can use functionalities, won't require authorization run user. script should run creator of sheet, no double triggering occurs. how should it?

you create web-app. web-apps have ability run either user himself, or developer/publisher.

under execute app as, select authorization app should run with: account (the developer's) or account of user visits app (see permissions). https://developers.google.com/apps-script/guides/web

this web-app wouldn't have sheet linked it, if use 1 sheet can have web-app access sheet through id of sheet. use existing menu-items trigger webapp

would possible solution problem?


Comments