List permissions for a spreadsheet
This function lists all the permissions for a spreadsheet, as reported via the permissions feed of the Google Drive API. A simplified view of this information is available in the browser in the sharing dialog of a Google Sheet.
a registered Google spreadsheet, i.e. a
character, optional; the email or unique ID of a user that, if provided, will be used to filter the results
The first row corresponds to the owner of the spreadsheet. Permissions for other users or groups, if such exist, follow in additional rows.
A permission for a sheet includes the following information: the name for this permission, the email of the user or group the permission refers to, the primary role for the user, any additional roles they have, the type of user they are, the (unique) ID of the user this permission refers to, a link back to this permission, and the ETag of the permission.
a tbl_df, one row per permission
1 2 3 4 5 6