list_spreadsheets

Retrieve and display a list of Google Drive spreadsheets accessible to a specified user, including file names, IDs, and modification times. Configure results limit for precise output.

Instructions

Lists spreadsheets from Google Drive that the user has access to.

Args:
    user_google_email (str): The user's Google email address. Required.
    max_results (int): Maximum number of spreadsheets to return. Defaults to 25.

Returns:
    str: A formatted list of spreadsheet files (name, ID, modified time).

Input Schema

Name	Required	Description	Default
`max_results`	No
`service`	Yes
`user_google_email`	Yes

Input Schema (JSON Schema)

{
  "properties": {
    "max_results": {
      "default": 25,
      "title": "Max Results",
      "type": "integer"
    },
    "service": {
      "title": "service",
      "type": "string"
    },
    "user_google_email": {
      "title": "User Google Email",
      "type": "string"
    }
  },
  "required": [
    "service",
    "user_google_email"
  ],
  "title": "list_spreadsheetsArguments",
  "type": "object"
}

Google Workspace MCP Server

list_spreadsheets

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from Google Workspace MCP Server

Related Tools

MCP directory API