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 });