Find sheet size using Google Sheets API

I am connecting to a google sheet using the API and want to find out the maximum (existing) dimensions of the sheet) so that I can pull in all the data

$service = new Google_Service_Sheets($client);  // would really like to calculate range  $range = 'Sheet1!A1:Z100';  $response = $service->spreadsheets_values->get($spreadsheetId, $range);  

Is there a way of determining what the maximum existing dimensions of the sheet are, or even getting the entire sheet so I can pre-calculate the range of cells I need more precisely?

https://stackoverflow.com/questions/67336050/find-sheet-size-using-google-sheets-api April 30, 2021 at 10:55PM