Google Sheets
GOOGLESHEETS_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 googlesheets
Other tools also called GOOGLESHEETS_LOOKUP_SPREADSHEET_ROW?
See providers with this name
Input Schema
{
"type": "object",
"properties": {
"query": {
"type": "string",
"description": "Exact text value to find; matches the entire content of a cell in a row.\nExamples:\n \"John\"\n \"Completed\"\n \"ID-12345\""
},
"range": {
"type": [
"string",
"null"
],
"default": null,
"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.\nExamples:\n \"Sheet1!A1:D5\"\n \"Sheet1!A:Z\"\n \"'Admin tickets'!A:A\"\n \"MySheetName!C1:G10\""
},
"case_sensitive": {
"type": "boolean",
"default": false,
"description": "If `True`, the query string search is case-sensitive."
},
"spreadsheet_id": {
"type": "string",
"description": "Identifier of the Google Spreadsheet to search.\nExample: \"1BiexwqQYjfC_BXy6zDQYJqb6zxzRyP9\""
}
}
}