title: Google app script: getting data from spreadsheets without having viewing rights (not installable trigger)
body: <p>The problem is that I have various spreadsheets (a) for which only one person has viewing and editing permissions, still other persons need some data from those spreadsheets (a) for their spreadsheets (b), they also need to be able to get an updated version of the data from the spreadsheets (a)</p>
  
  <p>I created now a workaround using installable triggers with an on edit function (they have to change a specific field in the spreadsheet) to update the data, but the persons want to have a button/drawing which they can click or a menu entry  to get the updated data from the spreadsheets (a). </p>
  
  <p>From my perspective to combine an installable trigger with a button/drawing/menu entry is a dead end. Therefore my question is, if there is any other possibility to grant access to data from spreadsheets without giving viewing or editing rights to the documents where the data comes from...</p>
  
  <p>Would be great if anybody would have an idea, thanks in advance</p>