create_spreadsheet

Generate a new Google Spreadsheet with specified title and optional sheet names. Input user Google email and receive details like ID and URL of the created spreadsheet.

Instructions

Creates a new Google Spreadsheet.

Args:
    user_google_email (str): The user's Google email address. Required.
    title (str): The title of the new spreadsheet. Required.
    sheet_names (Optional[List[str]]): List of sheet names to create. If not provided, creates one sheet with default name.

Returns:
    str: Information about the newly created spreadsheet including ID and URL.

Input Schema

Name	Required	Description	Default
`service`	Yes
`sheet_names`	No
`title`	Yes
`user_google_email`	Yes

Input Schema (JSON Schema)

{
  "properties": {
    "service": {
      "title": "service",
      "type": "string"
    },
    "sheet_names": {
      "anyOf": [
        {
          "items": {
            "type": "string"
          },
          "type": "array"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Sheet Names"
    },
    "title": {
      "title": "Title",
      "type": "string"
    },
    "user_google_email": {
      "title": "User Google Email",
      "type": "string"
    }
  },
  "required": [
    "service",
    "user_google_email",
    "title"
  ],
  "title": "create_spreadsheetArguments",
  "type": "object"
}

Google Workspace MCP Server - Control Gmail, Calendar, Docs, Sheets, Slides, Chat, Forms & Drive

create_spreadsheet

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from Google Workspace MCP Server - Control Gmail, Calendar, Docs, Sheets, Slides, Chat, Forms & Drive

Related Tools

MCP directory API