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>"]);