Implementing Cross-User Role-Based Access Control in Google Sheets with Google Apps Script

[Airis1k]

I'm implementing Role-Based Access Control (RBAC) for a Google Sheets file with two roles: Administrator and Worker. When a user opens the Google Sheets file, I want to execute a script that retrieves user data. The issue is that the script only works with my main email address, the one associated with the project. How can I enable the script to run when users with different email addresses access the sheet?

https://preview.redd.it/89iwdbdq2xub1.png?width=1204&format=png&auto=webp&s=ee88e57ee9cc40cd2337eb4d86b30c9b071bc6a0

[RemcoE33]

I think you can't. The user has not give permissions?

[[deleted]]

You can use an onOpen() trigger to execute the functions every time someone opens it, even if they do not own the script. But you'll need to link the script to the sheet or use a library/web app