function readData() { var coordinates = [1, 1, 1, 26]; reset(); var range = read(coordinates); storeData(range); logProperties(); } function read(coordinates) { Logger.log(coordinates.toString()); var spreadSheet = SpreadsheetApp.openById("1L3Sd-J780mQtb7JYsmJzInI1kMdrQA8GbLspQJ5eVW4"); var sheet = spreadSheet.getSheetByName("tracker"); var range = sheet.getRange(coordinates[0], coordinates[1], coordinates[2], coordinates[3]).getValues(); return JSON.stringify(range); } function logProperties() { var keys = PropertiesService.getScriptProperties().getKeys(); Logger.log(keys); } function reset() { PropertiesService.getScriptProperties().deleteAllProperties();} function storeData(range) { Logger.log(range); } Execution log 1:48:00 AM Notice Execution started 1:48:01 AM Info 1,1,1,26 1:48:01 AM Info [["one","two","three","four","five","","","","","","","","","","","","","","","","","","","","",""]] 1:48:01 AM Info [] 1:48:01 AM Notice Execution completed