How to use

loadInfo

function

in

GoogleSpreadsheet

async getSheetByTitle(title) {
  await doc.loadInfo();

  // Find sheet by title
  const sheetIndex = doc.sheetsByIndex.findIndex((i) => i.title === title);

  if (sheetIndex === -1) {
   throw {
    message: 'Sheet not found',
   };
  }

  const sheet = doc.sheetsByIndex[sheetIndex];

  const rows = await sheet.getRows();
  return rows;
 }

await spreadSheet.loadInfo();