Google Sheets
GOOGLESHEETS_SEARCH_DEVELOPER_METADATA
Tool to search for developer metadata in a spreadsheet. Use when you need to find specific metadata entries based on filters.
Remote googlesheets
Other tools also called GOOGLESHEETS_SEARCH_DEVELOPER_METADATA?
See providers with this name
Input Schema
{
"type": "object",
"properties": {
"dataFilters": {
"type": "array",
"items": {
"type": "object",
"properties": {
"a1Range": {
"type": [
"string",
"null"
],
"default": null,
"description": "Selects DeveloperMetadata associated with the given A1 range. Must represent a single row or single column only. Valid examples: 'A:A' (entire column A), 'Sheet1!B:B' (column B in Sheet1), '1:1' (entire row 1), 'Sheet1!5:5' (row 5 in Sheet1). Invalid examples: 'A1:D7' (multi-row/multi-column range), 'A1' (single cell)."
},
"gridRange": {
"anyOf": [
{
"type": "object",
"properties": {},
"additionalProperties": true
},
{
"type": "null"
}
],
"default": null,
"description": "Selects DeveloperMetadata associated with the given grid range. The developer metadata must be associated with a location that overlaps the range."
},
"developerMetadataLookup": {
"anyOf": [
{
"type": "object",
"properties": {},
"additionalProperties": true
},
{
"type": "null"
}
],
"default": null,
"description": "Selects DeveloperMetadata by its ID."
}
},
"description": "DataFilter",
"additionalProperties": false
},
"description": "The data filters describing the criteria used to determine which DeveloperMetadata entries to return."
},
"spreadsheetId": {
"type": "string",
"description": "The ID of the spreadsheet to retrieve metadata from.\nExample: \"1q2w3e4r5t6y7u8i9o0p\""
}
}
}