Coming ProfileData

//function doGet(e) { var template = HtmlService.createTemplateFromFile("index"); var output = template.evaluate(); output.setXFrameOptionsMode(HtmlService.XFrameOptionsMode.ALLOWALL); return output; } function getSheetData() { var spreadsheet = SpreadsheetApp.getActiveSpreadsheet(); var sheet1 = spreadsheet.getSheetByName('From Responses 1'); var sheet2 = spreadsheet.getSheetByName('Sheet1'); var data = []; if (sheet1) { var dataRange1 = sheet1.getDataRange(); var values1 = dataRange1.getValues(); data = data.concat(values1); // Add data from 'From Responses 1' } if (sheet2) { var dataRange2 = sheet2.getDataRange(); var values2 = dataRange2.getValues(); data = data.concat(values2); // Add data from 'Sheet1' } return data; }

Comments