Google Super
GOOGLESUPER_LOOKUP_SPREADSHEET_ROW
Finds the first row in a Google Spreadsheet where a cell's entire content exactly matches the query string, searching within a specified A1 notation range or the first sheet by default.
Remote googlesuper
Other tools also called GOOGLESUPER_LOOKUP_SPREADSHEET_ROW?
See providers with this name
Input Schema
{
"type": "object",
"properties": {
"query": {
"type": "string",
"title": "Query",
"examples": [
"John",
"Completed",
"ID-12345"
],
"description": "Exact text value to find; matches the entire content of a cell in a row."
},
"range": {
"type": "string",
"title": "Range",
"default": null,
"examples": [
"Sheet1!A1:D5",
"Sheet1!A:Z",
"'Admin tickets'!A:A",
"MySheetName!C1:G10"
],
"nullable": true,
"description": "A1 notation range with explicit subrange (e.g., 'Sheet1!A1:D5', 'MySheet!A:Z'). Defaults to the first sheet if omitted. IMPORTANT: Sheet names with spaces must be single-quoted (e.g., \"'My Sheet'!A1:Z\"). Bare sheet names without ranges (e.g., 'Sheet1') are not supported - always specify a range."
},
"case_sensitive": {
"type": "boolean",
"title": "Case Sensitive",
"default": false,
"description": "If `True`, the query string search is case-sensitive."
},
"spreadsheet_id": {
"type": "string",
"title": "Spreadsheet Id",
"examples": [
"1BiexwqQYjfC_BXy6zDQYJqb6zxzRyP9"
],
"description": "Identifier of the Google Spreadsheet to search."
}
}
}