You can manage which users and other components can interact with the sheet that you own by setting the sheet permissions.

There are 3 elements that might try to view or edit your sheet. They are

  • Users: There are two predefined sets of users, All Users and Public and you can define the permissions to these. Further if you want to define a different permission to one or few specific users you can do so by selecting those users and defining their permission.
  • Apps: There is a predefined option to set the permission for all other apps to which you can define the permission. Further you can give specific apps a different permission by selecting the app and defining the permission for the same.

  • Other sheets: Similar to apps there is a predefined option to set the permission for all other sheets to which you can define the permission. Further you can give specific sheets a different permission by selecting the app and defining the permission for the same.

You can set the permission for each of these and their interactions will be accordingly. The permission can be set to

  • View Only: This gives the permission to just view the contents of the sheet.
  • Can Edit: This gives the permission to update the sheet data or add new data to the sheet.
  • No Access: This prevents viewing or editing the sheet.
Did this answer your question?