v1
latestOpenAPI 3.0.12026-07-1711094.7 KBBatch retrieves values from multiple ranges in a Google Sheet.
This function allows for efficient retrieval of data from multiple ranges within a Google Sheet using a single batch request. It takes a sheet ID and an array of range notations, returning a three-dimensional array containing the values from each specified range. This approach minimizes API calls and improves performance when fetching data from multiple areas of a spreadsheet.
post/batchGetValues
Request body
Response
Successful response