Skip to content

Instantly share code, notes, and snippets.

@tariqhamid
Forked from mogsdad/Dashboard-Code.gs
Created June 21, 2016 18:10
Show Gist options
  • Save tariqhamid/2972eec6cba60231e2a7c13f3dff3e2e to your computer and use it in GitHub Desktop.
Save tariqhamid/2972eec6cba60231e2a7c13f3dff3e2e to your computer and use it in GitHub Desktop.
/**
* Serves HTML of the application for HTTP GET requests.
* From gist.github.com/mogsdad/24518dff348ad14d3929
*
* @param {Object} e event parameter that can contain information
* about any URL parameters provided.
*/
function doGet(e) {
var template = HtmlService.createTemplateFromFile('Index');
// Build and return HTML in IFRAME sandbox mode.
return template.evaluate()
.setTitle('Dashboard demo')
.setSandboxMode(HtmlService.SandboxMode.IFRAME);
}
/**
* Return all data from first spreadsheet as an array. Can be used
* via google.script.run to get data without requiring publication
* of spreadsheet.
* From gist.github.com/mogsdad/24518dff348ad14d3929
*
* Returns null if spreadsheet does not contain more than one row.
*/
function getSpreadsheetData() {
// This does not work, see https://code.google.com/p/google-apps-script-issues/issues/detail?id=5233
// var ss = SpreadsheetApp.getActiveSpreadsheet();
// var data = ss.getSheets()[0].getDataRange().getValues();
var sheetId = '16pAw9zeQFEFfuq1ec-UykFlFbL-Kd_yGxNJ49i-sAok'; // Replace with your spreadsheet ID. (Ick.)
var data = SpreadsheetApp.openById(sheetId).getSheets()[0].getDataRange().getValues();
return (data.length > 1) ? data : null;
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment