javascript - Run Google Sheet Add-On as Admin

Question

I have three spreadsheets (Files) with three different users. Tech SSheet, Admin SSheet and Manager SSheet. Tech SSheet data should be sent to Manager SSheet when Tech user click on the Add-On.

Admin user is Owner of all three files. Tech user doesn't have access to Manager SSheet. All the code is placed in Admin Sheet and Add on is created. So here I have to call code in Admin Sheet from Tech Sheet/user.

I created Add-On but it is taking Tech Sheet as reference. Since Tech Sheet do not have permission to Manager Sheet, copy data is failing.

Is there any possibility to run Add-on as Admin without providing permission to Tech user?

Answer 1

On G Suite document editors, including Google Sheets, if the documents are on "My Unit" and not on a "Shared Unit" (formerly "Team Drive") the permissions roles are

• Owner
• Editor
• Commenter
• Viewer

In other words, there is no "admin", by the other hand, permissions are granted to users not to "sheets".

References

• Share files from Google Drive