How to use google-spreadsheet

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.useApiKey(credentials);
} else if (typeof credentials === "object") {
 await spreadSheet.useServiceAccountAuth(credentials);
} else {
 await spreadSheet.useApiKey(process.env.SPREADSHEET_API_KEY);
await spreadSheet.loadInfo();
 { length: spreadSheet.sheetCount },
 (k, v) => spreadSheet.sheetsByIndex[v].title
);
  worksheet: spreadSheet.sheetsByIndex[sheetsNames.indexOf(title)],
  formatCell
 });

async getDOHDataDrop(query) {
  const { page, itemsPerPage = 100, filterBy, filterByValue } = query;
  let rows = (await this.getSheetByTitle('DOH Data Drop')).sort(
   (a, b) => +new Date(a.DateRepConf) - +new Date(b.DateRepConf)
  );