I'm trying to get data from a spreadsheet (59 sheets) using this get request:
https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values:batchGet
I have noticed that 40 ranges (sheets) is the limit before I get illegal request.
Does anyone know if this is normal behaviour and where it is documented?