Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save white5168/8e27559295942593c6e51b36c8b8b178 to your computer and use it in GitHub Desktop.
Save white5168/8e27559295942593c6e51b36c8b8b178 to your computer and use it in GitHub Desktop.
function doGet() {
return HtmlService.createTemplateFromFile("index.html")
.evaluate()
.setSandboxMode(HtmlService.SandboxMode.IFRAME);
}
function include(filename) {
return HtmlService.createHtmlOutputFromFile(filename)
.setSandboxMode(HtmlService.SandboxMode.IFRAME)
.getContent();
}
function getData(){
var sheetid = "your sheet id";
var sheet = SpreadsheetApp.openById(sheetid).getSheets()[0];
return sheet.getDataRange().getValues();
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment