Google Sheets

Methods (8)

• createSpreadsheet

  write

  Create a new Google Sheets spreadsheet.

  Required paramstitle
  Input schema

  {
    "type": "object",
    "properties": {
      "title": {
        "type": "string",
        "description": "Spreadsheet title."
      },
      "sheets": {
        "type": "array",
        "description": "Optional initial sheet definitions.",
        "items": {
          "type": "object"
        }
      }
    },
    "required": [
      "title"
    ],
    "additionalProperties": true
  }

• getSpreadsheet

  read

  Fetch spreadsheet metadata by ID.

  Required paramsspreadsheetId
  Input schema

  {
    "type": "object",
    "properties": {
      "spreadsheetId": {
        "type": "string",
        "description": "Google Sheets spreadsheet ID."
      },
      "ranges": {
        "type": "array",
        "description": "Optional list of A1 ranges to limit returned grid data.",
        "items": {
          "type": "string"
        }
      }
    },
    "required": [
      "spreadsheetId"
    ],
    "additionalProperties": true
  }

• getSheetValues

  read

  Read values from a spreadsheet range.

  Required paramsspreadsheetIdrange
  Input schema

  {
    "type": "object",
    "properties": {
      "spreadsheetId": {
        "type": "string",
        "description": "Google Sheets spreadsheet ID."
      },
      "range": {
        "type": "string",
        "description": "A1 notation range."
      },
      "majorDimension": {
        "type": "string",
        "description": "ROWS or COLUMNS."
      },
      "valueRenderOption": {
        "type": "string",
        "description": "How values should be rendered."
      }
    },
    "required": [
      "spreadsheetId",
      "range"
    ],
    "additionalProperties": true
  }

• batchGetSheetValues

  read

  Read values from multiple spreadsheet ranges in one request.

  Required paramsspreadsheetIdranges
  Input schema

  {
    "type": "object",
    "properties": {
      "spreadsheetId": {
        "type": "string",
        "description": "Google Sheets spreadsheet ID."
      },
      "ranges": {
        "type": "array",
        "description": "List of A1 notation ranges.",
        "items": {
          "type": "string"
        }
      },
      "majorDimension": {
        "type": "string",
        "description": "ROWS or COLUMNS."
      },
      "valueRenderOption": {
        "type": "string",
        "description": "How values should be rendered."
      }
    },
    "required": [
      "spreadsheetId",
      "ranges"
    ],
    "additionalProperties": true
  }

• updateCells

  write

  Write values into a spreadsheet range.

  Required paramsspreadsheetIdrangevalues
  Input schema

  {
    "type": "object",
    "properties": {
      "spreadsheetId": {
        "type": "string",
        "description": "Google Sheets spreadsheet ID."
      },
      "range": {
        "type": "string",
        "description": "A1 notation range."
      },
      "values": {
        "type": "array",
        "description": "2D array of values to write.",
        "items": {
          "type": "array",
          "items": {}
        }
      },
      "valueInputOption": {
        "type": "string",
        "description": "RAW or USER_ENTERED."
      }
    },
    "required": [
      "spreadsheetId",
      "range",
      "values"
    ],
    "additionalProperties": true
  }

• appendRows

  unknown

  Append rows to the end of an existing data table in a sheet. Pass the column-only range like "Sheet1!A:D" — Google detects the table extent and appends below.

  Required paramsspreadsheetIdrangevalues
  Input schema

  {
    "type": "object",
    "properties": {
      "spreadsheetId": {
        "type": "string",
        "description": "Google Sheets spreadsheet ID."
      },
      "range": {
        "type": "string",
        "description": "A1 notation range covering the columns to append into, e.g. \"Sheet1!A:D\"."
      },
      "values": {
        "type": "array",
        "description": "2D array of row values.",
        "items": {
          "type": "array",
          "items": {}
        }
      },
      "valueInputOption": {
        "type": "string",
        "description": "RAW or USER_ENTERED. Defaults to USER_ENTERED."
      },
      "insertDataOption": {
        "type": "string",
        "description": "INSERT_ROWS or OVERWRITE. Defaults to INSERT_ROWS."
      }
    },
    "required": [
      "spreadsheetId",
      "range",
      "values"
    ],
    "additionalProperties": true
  }

• createSheet

  write

  Add a new tab (sheet) to an existing spreadsheet.

  Required paramsspreadsheetIdtitle
  Input schema

  {
    "type": "object",
    "properties": {
      "spreadsheetId": {
        "type": "string",
        "description": "Google Sheets spreadsheet ID."
      },
      "title": {
        "type": "string",
        "description": "Tab title."
      },
      "gridProperties": {
        "type": "object",
        "description": "Optional grid sizing (rowCount, columnCount, frozenRowCount, frozenColumnCount).",
        "additionalProperties": true
      }
    },
    "required": [
      "spreadsheetId",
      "title"
    ],
    "additionalProperties": true
  }

• formatRange

  unknown

  Apply formatting (textFormat, backgroundColor, alignment, numberFormat) to a cell range. Range MUST use A1 notation including the sheet name (e.g. "Sheet1!A1:D1") — the handler resolves the sheet name to its sheetId automatically.

  Required paramsspreadsheetIdrangeformat
  Input schema

  {
    "type": "object",
    "properties": {
      "spreadsheetId": {
        "type": "string",
        "description": "Google Sheets spreadsheet ID."
      },
      "range": {
        "type": "string",
        "description": "A1 range with sheet name, e.g. \"Sheet1!A1:D1\"."
      },
      "format": {
        "type": "object",
        "description": "CellFormat. Common keys: textFormat:{bold,italic,fontSize,foregroundColor}, backgroundColor:{red,green,blue}, horizontalAlignment, numberFormat.",
        "additionalProperties": true
      }
    },
    "required": [
      "spreadsheetId",
      "range",
      "format"
    ],
    "additionalProperties": true
  }