Google Sheets
GoogleSheets_SearchSpreadsheets
Searches for spreadsheets in the user's Google Drive based on the titles and content and returns the title, ID, and URL for each matching spreadsheet. Does not return the content/data of the sheets in the spreadsheets - only the metadata. Excludes spreadsheets that are in the trash.
Remote googlesheets
Remote (network-hosted)
Other tools also called GoogleSheets_SearchSpreadsheets?
See providers with this name
Input Schema
{
"type": "object",
"properties": {
"limit": {
"type": "integer",
"description": "The maximum number of spreadsheets to list. Defaults to 10. Max is 50"
},
"order_by": {
"type": "array",
"items": {
"enum": [
"createdTime",
"createdTime desc",
"folder",
"folder desc",
"modifiedByMeTime",
"modifiedByMeTime desc",
"modifiedTime",
"modifiedTime desc",
"name",
"name desc",
"name_natural",
"name_natural desc",
"quotaBytesUsed",
"quotaBytesUsed desc",
"recency",
"recency desc",
"sharedWithMeTime",
"sharedWithMeTime desc",
"starred",
"starred desc",
"viewedByMeTime",
"viewedByMeTime desc"
],
"type": "string"
},
"description": "Sort order. Defaults to listing the most recently modified spreadsheets first. If spreadsheet_contains or spreadsheet_not_contains is provided, then the order_by will be ignored."
},
"pagination_token": {
"type": "string",
"description": "The pagination token to continue a previous request"
},
"spreadsheet_contains": {
"type": "array",
"items": {
"type": "string"
},
"description": "Keywords or phrases that must be in the spreadsheet title. Provide a list of keywords or phrases if needed."
},
"include_shared_drives": {
"type": "boolean",
"description": "Whether to include spreadsheets from shared drives. Defaults to False (searches only in the user's 'My Drive')."
},
"spreadsheet_not_contains": {
"type": "array",
"items": {
"type": "string"
},
"description": "Keywords or phrases that must NOT be in the spreadsheet title. Provide a list of keywords or phrases if needed."
},
"search_only_in_shared_drive_id": {
"type": "string",
"description": "The ID of the shared drive to restrict the search to. If provided, the search will only return spreadsheets from this drive. Defaults to None, which searches across all drives."
},
"include_organization_domain_spreadsheets": {
"type": "boolean",
"description": "Whether to include spreadsheets from the organization's domain. This is applicable to admin users who have permissions to view organization-wide spreadsheets in a Google Workspace account. Defaults to False."
}
}
}