const driveApis = google.drive({
version: "v3",
auth,
});
const spreadsheetBuffer = (
await driveApis.files.export(
{
fileId: sheetId,
mimeType:
"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
},
{
responseType: "arraybuffer",
}
)
).data;
const workbook = xlsx.read(spreadsheetBuffer, { type: "buffer" });
const xlsxData = xlsx.utils.sheet_to_json(workbook.Sheets["<sheetname>"]);