APPSHARELIST
The APPSHARELIST function returns a list of all users with whom an app is shared.
The APPSHARELIST function returns a list of all users with whom an app is shared.
APPSHARELIST(appName)
appName - the name of the app from which the list of shared users should be returned - Value type: text
The function returns a range where each row contains this user information:
email - the email address of the user
workspaceRole- the workspace role of the user Possible values are: βEditorβ and βViewerβ
If the function is executed by a user who doesnβt have the Editor role assigned for the specified app, it returns !ERROR.