Roles and Permissions

Understand the roles and privileges that you can configure in Rows.

There are several ways to give others access to your spreadsheets. Users get different permissions depending on the type of access you give them.

Here’s a summary of the access methods and the permissions that are granted.

ACCESS METHODUSER PERMISSIONS
Workspace inviteEdit any spreadsheet in the workspace that you’ve invited them to.
Spreadsheet inviteEdit only the specific spreadsheet that you’ve invited them to.
Private linkOpen the View mode of the linked spreadsheet.
Community linkOpen the View mode of the linked spreadsheet and duplicate it to another workspace.

Permissions



For a more complete picture, here’s a more detailed comparison of all the permissions that are granted across the different access methods.
PERMISSIONSWORKSPACE INVITESPREADSHEET INVITEPRIVATE LINKCOMMUNITY LINK
View all sheets in a Workspace
Edit all sheets in a Workspace
View specific sheets in a Workspace
Edit specific sheets in a Workspace
Duplicate a spreadsheet
Administer a Workspace
Access a sheet without being logged in

Roles



Users can also be invited to collaborate on workspaces and spreadsheets. When you invite new users, you can assign them with explicit roles that determine their user permissions.

The following table describes all the roles that are available in Rows—some of these are named roles that you can explicitly assign, and others are implied based on how a user accesses a spreadsheet:
ROLEDESCRIPTION
Workspace OwnerThe user who originally created the workspace. They have the same permissions as a Workspace Admin.

Workspace Owners have the following permissions:
  • Edit all workspace settings.
  • Add new members and change the roles of existing members.
  • Edit all folders and spreadsheets in the workspace.
They cannot change their own role or transfer ownership to another user.
Workspace AdminA Rows user who has been invited to administer the workspace by the workspace owner.

Workspace Admins have the following permissions:
  • Edit all workspace settings.
  • Add new members and change the roles of existing members.
  • Edit all folders and spreadsheets in the workspace.
  • Change the permissions for all folders and spreadsheets in the workspace.
  • Change their own role give and give other users the Admin role.
Workspace EditorA Rows user who has been invited to collaborate on all spreadsheets in a workspace.

Workspace Editors have the following permissions:
  • Edit all folders and spreadsheets in the workspace.
  • Change the spreadsheet permissions for other Editors and Viewers
  • Invite new Editors or Viewers to the workspace.
  • Invite Guest Users to collaborate on specific spreadsheets.
Editors cannot access workspace settings or update the permissions for Admins and Owners.
Workspace ViewerA Rows user who has been invited to a workspace with limited permissions and can only access to spreadsheets in view mode.

Workspace Viewers have the following permissions:
  • Browse all spreadsheets in the workspace and open them in view mode.
  • View a list of workspace members.
They cannot edit spreadsheets or duplicate them (unless they are community spreadsheets).
Guest EditorA Rows user who has been invited to collaborate on a specific spreadsheet.

Guest Editors have the following permissions:
  • Edit spreadsheets that they've been invited to.
  • Open the view mode of spreadsheets that they been invited to.
  • See the workspace that the spreadsheet belongs to.
Guest ViewerAny Rows user who has been invited to open a specific spreadsheet in view mode.

Guest Viewers have the following permissions:
  • Open spreadsheets that they been invited to in view mode.
  • See the workspace that the spreadsheet belongs to.
Anonymous UserAnyone who opens a spreadsheet without logging into Rows. Anonymous Users can only open spreadsheets in view mode.

Anonymous Users have the following permissions:
  • Open the view mode of spreadsheets that have been shared with them through a private link or are listed on the Community page.
  • See the workspace that the spreadsheet belongs to.
Unlike logged-in users, Anonymous Users cannot duplicate community spreadsheets.

Further reading

To learn more about sharing and collaborating with others, check out the following articles: