Read Sheet of Data

PHOTO EMBED

Tue Jul 12 2022 15:08:24 GMT+0000 (Coordinated Universal Time)

Saved by @Waydes

 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}`) }
content_copyCOPY