sheets_write

Parameters schema

{
  "type": "object",
  "examples": [
    {
      "range": "Sheet1!A1",
      "values": [
        [
          "Name",
          "Age",
          "City"
        ],
        [
          "Alice",
          "30",
          "New York"
        ],
        [
          "Bob",
          "25",
          "Los Angeles"
        ]
      ],
      "spreadsheet_id": "1BxiMVs0XRA5nFMmqvzausWYMYq6nS8twLu0gKBvMZsk"
    },
    {
      "range": "Data!B2:C5",
      "values": [
        [
          "100",
          "200"
        ],
        [
          "300",
          "400"
        ]
      ],
      "spreadsheet_id": "1BxiMVs0XRA5nFMmqvzausWYMYq6nS8twLu0gKBvMZsk",
      "value_input_option": "USER_ENTERED"
    }
  ],
  "required": [
    "spreadsheet_id",
    "range",
    "values"
  ],
  "properties": {
    "range": {
      "type": "string",
      "description": "A1 notation range (e.g., \"Sheet1!A1\")"
    },
    "values": {
      "type": "array",
      "items": {
        "type": "array",
        "items": {
          "type": "string"
        }
      },
      "description": "Array of rows, each row is an array of cell values"
    },
    "spreadsheet_id": {
      "type": "string",
      "description": "Spreadsheet ID"
    },
    "value_input_option": {
      "enum": [
        "USER_ENTERED",
        "RAW"
      ],
      "type": "string",
      "description": "How to interpret input. USER_ENTERED (default) parses formulas/dates/numbers. RAW stores literal strings."
    }
  }
}

• Data resourceGoogle Sheets API

  Google · productivity

  schema key0.80

Parent server