Google Sheets
GOOGLESHEETS_SEARCH_SPREADSHEETS
Search for Google Spreadsheets using various filters including name, content, date ranges, and more.
Remote googlesheets
Other tools also called GOOGLESHEETS_SEARCH_SPREADSHEETS?
See providers with this name
Input Schema
{
"type": "object",
"properties": {
"query": {
"type": [
"string",
"null"
],
"default": null,
"description": "Search query to filter spreadsheets using Google Drive query syntax. ALWAYS use field names like 'name contains', 'fullText contains'. DO NOT use plain keywords without field names (wrong: 'finance', correct: 'name contains \"finance\"'). DO NOT use spreadsheet IDs as search terms. For non-ASCII characters, use proper field syntax. Invalid operators like 'related to' or 'shared with' won't work - use 'sharedWithMe = true' instead. Leave empty to get all spreadsheets. IMPORTANT: This action requires Google Drive API scope.\nExamples:\n \"name contains 'budget'\"\n \"fullText contains 'sales'\"\n \"name contains 'report' and fullText contains 'quarterly'\"\n \"name contains 'finance' or name contains 'accounting'\"\n \"name contains 'データ'\"\n \"sharedWithMe = true\""
},
"order_by": {
"type": [
"string",
"null"
],
"default": "modifiedTime desc",
"description": "Order results by field. Common options: 'modifiedTime desc', 'modifiedTime asc', 'name', 'createdTime desc'\nExamples:\n \"modifiedTime desc\"\n \"name\"\n \"createdTime desc\"\n \"viewedByMeTime desc\""
},
"max_results": {
"anyOf": [
{
"type": "integer",
"maximum": 1000,
"minimum": 1
},
{
"type": "null"
}
],
"default": 10,
"description": "Maximum number of spreadsheets to return (1-1000). Defaults to 10."
},
"starred_only": {
"type": [
"boolean",
"null"
],
"default": false,
"description": "Whether to return only starred spreadsheets. Defaults to False."
},
"created_after": {
"type": [
"string",
"null"
],
"default": null,
"description": "Return spreadsheets created after this date. Use RFC 3339 format like '2024-01-01T00:00:00Z'.\nExamples:\n \"2024-01-01T00:00:00Z\"\n \"2024-12-01T12:00:00-08:00\""
},
"modified_after": {
"type": [
"string",
"null"
],
"default": null,
"description": "Return spreadsheets modified after this date. Use RFC 3339 format like '2024-01-01T00:00:00Z'.\nExamples:\n \"2024-01-01T00:00:00Z\"\n \"2024-12-01T12:00:00-08:00\""
},
"shared_with_me": {
"type": [
"boolean",
"null"
],
"default": false,
"description": "Whether to return only spreadsheets shared with the current user. Defaults to False."
},
"include_trashed": {
"type": [
"boolean",
"null"
],
"default": false,
"description": "Whether to include spreadsheets in trash. Defaults to False."
}
}
}