try { let ss = SpreadsheetApp.openById(SHEET_ID); let sheet = ss.getSheetByName(SHEET_NAME); if (sheet == null) { throw (`Error opening ${SHEET_NAME}`); } /** Get all data in sheet and convert to objects */ let data = sheet.getRange(1, 1, sheet.getLastRow(), sheet.getLastColumn()).getValues(); const header = data.shift(); const objData = getObjects(data, header); data = null; // Hopefully this triggers some garbage collection } catch (err) { Logger.log(`ERROR: ${err}`) }