Google Super
GOOGLESUPER_GET_SPREADSHEET_BY_DATA_FILTER
Returns the spreadsheet at the given ID, filtered by the specified data filters. Use this tool when you need to retrieve specific subsets of data from a Google Sheet based on criteria like A1 notation, developer metadata, or grid ranges.
Remote googlesuper
Other tools also called GOOGLESUPER_GET_SPREADSHEET_BY_DATA_FILTER?
See providers with this name
Input Schema
{
"type": "object",
"properties": {
"dataFilters": {
"type": "array",
"items": {
"type": "object",
"title": "DataFilter",
"properties": {
"a1Range": {
"type": "string",
"title": "A1 Range",
"default": null,
"examples": [
"Sheet1!A1:B2"
],
"nullable": true,
"description": "Selects data that matches the specified A1 range."
},
"gridRange": {
"type": "object",
"title": "GridRange",
"default": null,
"nullable": true,
"properties": {
"sheetId": {
"type": "integer",
"title": "Sheet Id",
"default": null,
"examples": [
0
],
"nullable": true,
"description": "The ID of the sheet this range is on."
},
"endRowIndex": {
"type": "integer",
"title": "End Row Index",
"default": null,
"examples": [
10
],
"nullable": true,
"description": "The end row (0-based, exclusive) of the range.",
"exclusiveMinimum": 0
},
"startRowIndex": {
"type": "integer",
"title": "Start Row Index",
"default": null,
"minimum": 0,
"examples": [
0
],
"nullable": true,
"description": "The start row (0-based, inclusive) of the range."
},
"endColumnIndex": {
"type": "integer",
"title": "End Column Index",
"default": null,
"examples": [
5
],
"nullable": true,
"description": "The end column (0-based, exclusive) of the range.",
"exclusiveMinimum": 0
},
"startColumnIndex": {
"type": "integer",
"title": "Start Column Index",
"default": null,
"minimum": 0,
"examples": [
0
],
"nullable": true,
"description": "The start column (0-based, inclusive) of the range."
}
},
"description": "Selects data that matches the range described by the GridRange.",
"additionalProperties": false
},
"developerMetadataLookup": {
"type": "object",
"title": "DeveloperMetadataLookup",
"default": null,
"nullable": true,
"properties": {
"metadataId": {
"type": "integer",
"title": "Metadata Id",
"default": null,
"examples": [
123
],
"nullable": true,
"description": "Filter by metadata ID."
},
"visibility": {
"enum": [
"DOCUMENT",
"PROJECT"
],
"type": "string",
"title": "DeveloperMetadataLookupVisibility",
"default": null,
"nullable": true,
"description": "Metadata visibility."
},
"metadataKey": {
"type": "string",
"title": "Metadata Key",
"default": null,
"examples": [
"project_id"
],
"nullable": true,
"description": "Filter by metadata key."
},
"locationType": {
"enum": [
"ROW",
"COLUMN",
"SHEET",
"SPREADSHEET",
"OBJECT"
],
"type": "string",
"title": "DeveloperMetadataLookupLocationType",
"default": null,
"nullable": true,
"description": "Location type of metadata."
},
"metadataValue": {
"type": "string",
"title": "Metadata Value",
"default": null,
"examples": [
"alpha"
],
"nullable": true,
"description": "Filter by metadata value."
}
},
"description": "Selects data associated with developer metadata.",
"additionalProperties": false
}
}
},
"title": "Data Filters",
"description": "The DataFilters used to select which ranges to retrieve."
},
"spreadsheetId": {
"type": "string",
"title": "Spreadsheet Id",
"examples": [
"abc123xyz789"
],
"description": "The ID of the spreadsheet to request."
},
"includeGridData": {
"type": "boolean",
"title": "Include Grid Data",
"default": null,
"examples": [
true
],
"nullable": true,
"description": "True if grid data should be returned. Ignored if a field mask is set."
},
"excludeTablesInBandedRanges": {
"type": "boolean",
"title": "Exclude Tables In Banded Ranges",
"default": null,
"examples": [
false
],
"nullable": true,
"description": "True if tables should be excluded in the banded ranges. False if not set."
}
}
}