sheets_append

Parameters schema

{
  "type": "object",
  "examples": [
    {
      "range": "Sheet1!A1",
      "values": [
        [
          "Charlie",
          "28",
          "Chicago"
        ],
        [
          "Diana",
          "32",
          "Boston"
        ]
      ],
      "spreadsheet_id": "1BxiMVs0XRA5nFMmqvzausWYMYq6nS8twLu0gKBvMZsk"
    },
    {
      "range": "Inventory!A1",
      "values": [
        [
          "Product X",
          "50"
        ],
        [
          "Product Y",
          "75"
        ]
      ],
      "spreadsheet_id": "1BxiMVs0XRA5nFMmqvzausWYMYq6nS8twLu0gKBvMZsk",
      "value_input_option": "RAW"
    }
  ],
  "required": [
    "spreadsheet_id",
    "range",
    "values"
  ],
  "properties": {
    "range": {
      "type": "string",
      "description": "A1 notation range to append after (e.g., \"Sheet1!A1\")"
    },
    "values": {
      "type": "array",
      "items": {
        "type": "array",
        "items": {
          "type": "string"
        }
      },
      "description": "Array of rows to append"
    },
    "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