Question : Google Web App Script Unknown Parameter Error on Load
Answered by : samer-saeid
//From
function getData(){ var spreadSheetId = "###"; //CHANGE var dataRange = "Base Stats!A2:L"; //CHANGE var range = Sheets.Spreadsheets.Values.get(spreadSheetId,dataRange); var values = range.values; return values;
}
//To
function getData(){ var spreadSheetId = "###"; // Please set your Spreadsheet ID. var sheet = SpreadsheetApp.openById(spreadSheetId).getSheetByName("Base Stats"); var values = sheet.getRange("A2:L" + sheet.getLastRow()).getDisplayValues(); return values;
}
Source : | Last Update : Tue, 17 May 22