get_multiple_sheet_data
Retrieve data from multiple ranges across Google Sheets in one request. Specify spreadsheet ID, sheet, and range for each query.
Instructions
Get data from multiple specific ranges in Google Spreadsheets.
Args: queries: A list of dictionaries, each specifying a query. Each dictionary should have 'spreadsheet_id', 'sheet', and 'range' keys. Example: [{'spreadsheet_id': 'abc', 'sheet': 'Sheet1', 'range': 'A1:B5'}, {'spreadsheet_id': 'xyz', 'sheet': 'Data', 'range': 'C1:C10'}]
Returns: A list of dictionaries, each containing the original query parameters and the fetched 'data' or an 'error'.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| queries | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |