Skip to content

Instantly share code, notes, and snippets.

@landsurveyorsunited
Forked from mhawksey/code.gs
Created October 16, 2015 23:26
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save landsurveyorsunited/e4ccd34d822ad0b15b54 to your computer and use it in GitHub Desktop.
Save landsurveyorsunited/e4ccd34d822ad0b15b54 to your computer and use it in GitHub Desktop.
Google Apps Script snippet which uses viewer settings on Google Sheet to control who views
var DOC_ID = '1K5IJLwK7qBUfLAG-tic9hOK3L8x4qUIQgd3gryHNE6Y';
function doGet() {
var doc =SpreadsheetApp.openById(DOC_ID);
var auth_user = doc.getViewers();
var auth = auth_user.map(function(user) {
return String(user);
});
var user = Session.getActiveUser().getEmail();
if (auth.indexOf(user) > -1){
return HtmlService.createHtmlOutput("you are allowed to view this").setSandboxMode(HtmlService.SandboxMode.IFRAME);
} else {
return HtmlService.createHtmlOutput(user+"you are <b>not</b> allowed to view this").setSandboxMode(HtmlService.SandboxMode.IFRAME);
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment