How to prevent viewer using app script to get values from shared google spreadsheet, especially for hidden sheets

Mar 19 '21 Comments: 2 Answers: 0

0

For shared spreadsheets, the permission has been set to viewer, and unticked the checkbox "Viewers and commenters can see the option to download, print, and copy". However, the viewer still able to get values by using App Script, for example function:

function grabValues(){
  const ss = SpreadsheetApp.openById(sheetId)
  const sheet =

…

Open Full Question