gsheets

Using the gsheets library, I can calculate the total number of rows in a specific sheet: var sheet = ss.worksheetByTitle('test'); var rows = await sheet?.values.map.allRows(); var totalRows = rows?.length; However, the above code requires fetching the row data from the…