Is it possible to run a script in google sheets from a specific user, regardless of the user that opens the sheet?
UPDATE: From a comment by the OP
So basically id want to the script to run as/from User A at all times. For example. User B, C, or D can all open the sheet and run the script, however i'd want it to run as User A all the time.
Only Google Apps Script Web Apps and installable triggers could be ran as the owner/creator, other scripts doesn't require permissions or if the require them run as the user that executed the script.
Yes, it's possible.
Bounded to spreadsheet scripts could be ran by any user that has edit access to the spreadsheet. If there aren't custom menus, to run a script, the user should
- Open the script editor, Tools > Script editor,
- If the script is not in the default file, open the corresponding file that holds the script,
- Select the script the the drop-down menu,
- Click the Run button