I have the following code to query a single sheet (Sheet1) from a google sheet document. Haven’t been able to find any documentation on how to query all sheets from the file

const GoogleSpreadsheet = require('google-spreadsheet');
const { google } = require("googleapis");
const spreadsheetId = '123456';

const auth = new google.auth.GoogleAuth({
    keyFile: "credentials/sheets_token.json",
    scopes: "https://www.googleapis.com/auth/spreadsheets",
});


const client = await auth.getClient();
const googleSheets = google.sheets({ version: "v4", auth: client });

const res = await googleSheets.spreadsheets.values.get({
    auth,
    spreadsheetId: spreadsheetId,
    range: 'Sheet1'
});

Tried using empty range, or excluding range parameter, or using range “Sheet1:Sheet10” none worked. Also tried fetching all sheets from the metadata, but you can only get various sheets’ titles not their rows data