Sheets Append Values

Immutable Catalog Entry

This descriptor comes from the active versioned Portal catalog.

DESTRUCTIVEgoogle.sheets_append_values

• Contract tier: agent_ready
• Risk: destructive
• Catalog version: google-2026.07.12.2
• Descriptor hash: 8ff9c784a3875709312018ba825590a3d320ea43894a01d2ada24f690912a839

Append rows to a Google Sheet range. It can overwrite, send, move, remove, or permanently delete Google data. Use it only after preview and the manifest-defined confirmation; it requires per-request Google OAuth.

Request Body

{
  "jsonrpc": "2.0",
  "id": "google-sheets-append-values-example",
  "method": "tools/call",
  "params": {
    "name": "google.sheets_append_values",
    "arguments": {
      "spreadsheet_id": "spreadsheet_id_123",
      "range_a1": "range_a1_example",
      "values": [],
      "insert_data_option": "OVERWRITE",
      "value_input_option": "RAW"
    }
  }
}

Arguments Schema

{
  "type": "object",
  "title": "sheets_append_valuesArguments",
  "required": [
    "spreadsheet_id",
    "range_a1",
    "values"
  ],
  "properties": {
    "values": {
      "type": "array",
      "items": {
        "type": "array",
        "items": {
          "anyOf": [
            {
              "type": "string"
            },
            {
              "type": "integer"
            },
            {
              "type": "number"
            },
            {
              "type": "boolean"
            },
            {
              "type": "null"
            }
          ]
        }
      },
      "title": "Values",
      "description": "Two-dimensional array of cell values."
    },
    "range_a1": {
      "type": "string",
      "title": "Range A1",
      "description": "A1 notation range, for example Sheet1!A1:C20."
    },
    "spreadsheet_id": {
      "type": "string",
      "title": "Spreadsheet Id",
      "description": "Google Sheets spreadsheet ID."
    },
    "insert_data_option": {
      "enum": [
        "OVERWRITE",
        "INSERT_ROWS"
      ],
      "type": "string",
      "title": "Insert Data Option",
      "default": "INSERT_ROWS",
      "description": "Argument for sheets_append_values."
    },
    "value_input_option": {
      "enum": [
        "RAW",
        "USER_ENTERED"
      ],
      "type": "string",
      "title": "Value Input Option",
      "default": "RAW",
      "description": "How Google Sheets should interpret written values."
    }
  },
  "additionalProperties": false
}

Output Schema

{
  "type": "object",
  "required": [
    "ok",
    "data",
    "error",
    "meta"
  ],
  "properties": {
    "ok": {
      "type": "boolean",
      "description": "Whether the local or Google provider operation completed successfully."
    },
    "data": {
      "anyOf": [
        {
          "type": "object",
          "additionalProperties": true
        },
        {
          "type": "array",
          "items": {}
        },
        {
          "type": "string"
        },
        {
          "type": "number"
        },
        {
          "type": "boolean"
        },
        {
          "type": "null"
        }
      ],
      "description": "Bounded local navigation or Google provider result when ok is true."
    },
    "meta": {
      "type": "object",
      "description": "Safe timing, pagination, cache, request, and truncation metadata.",
      "additionalProperties": true
    },
    "error": {
      "anyOf": [
        {
          "type": "object",
          "additionalProperties": true
        },
        {
          "type": "null"
        }
      ],
      "description": "Safe structured error when ok is false."
    }
  },
  "description": "Google MCP normalized operation envelope.",
  "additionalProperties": false
}

Code Examples

cURL

curl -X POST 'https://portal.madpanda3d.com/api/mcp' \
  -H 'Authorization: Bearer mad_live_***' \
  -H 'Content-Type: application/json' \
  -d '{
  "jsonrpc": "2.0",
  "id": "google-sheets-append-values-example",
  "method": "tools/call",
  "params": {
    "name": "google.sheets_append_values",
    "arguments": {
      "spreadsheet_id": "spreadsheet_id_123",
      "range_a1": "range_a1_example",
      "values": [],
      "insert_data_option": "OVERWRITE",
      "value_input_option": "RAW"
    }
  }
}'

Node.js

const response = await fetch('https://portal.madpanda3d.com/api/mcp', {
  method: 'POST',
  headers: {
    Authorization: 'Bearer mad_live_***',
    'Content-Type': 'application/json',
  },
  body: JSON.stringify({
  "jsonrpc": "2.0",
  "id": "google-sheets-append-values-example",
  "method": "tools/call",
  "params": {
    "name": "google.sheets_append_values",
    "arguments": {
      "spreadsheet_id": "spreadsheet_id_123",
      "range_a1": "range_a1_example",
      "values": [],
      "insert_data_option": "OVERWRITE",
      "value_input_option": "RAW"
    }
  }
}),
});
const data = await response.json();
console.log(data);

Python

import requests

url = 'https://portal.madpanda3d.com/api/mcp'
headers = {
    'Authorization': 'Bearer mad_live_***',
    'Content-Type': 'application/json',
}
payload = {
  "jsonrpc": "2.0",
  "id": "google-sheets-append-values-example",
  "method": "tools/call",
  "params": {
    "name": "google.sheets_append_values",
    "arguments": {
      "spreadsheet_id": "spreadsheet_id_123",
      "range_a1": "range_a1_example",
      "values": [],
      "insert_data_option": "OVERWRITE",
      "value_input_option": "RAW"
    }
  }
}
response = requests.post(url, headers=headers, json=payload, timeout=60)
print(response.json())

Example Responses

200 Success

{
  "ok": true,
  "message": "Tool google.sheets_append_values executed successfully.",
  "note": "Response shape varies by MCP tool. Inspect live responses for exact fields."
}

502 Upstream Error

{
  "ok": false,
  "classification": "upstream_http_error",
  "message": "Upstream MCP returned a non-success status."
}