Requesting the data for a smaller range works, obviously. But how do I know the range of the data in the sheet? Like, how do I know the entire table is A1:F25 or so? It would be great if the API can tell me that. It kinda does, but it says the sheet has 26 columns and 1000 rows. Yeah, thanks for the useless info.
How come that the bigger the company, the shittier their APIs?

