Sheets append rows

sheets__append_rows

Access

Requires a project integration connection for sheets.

Call type: Can change resources.

Arguments

FieldTypeRequiredDescription and constraints
spreadsheetIdstringYesGoogle Sheets spreadsheet ID
rangestringYesA1 notation range/table to append to
valueInputOptionstringNoHow input values should be interpreted
insertDataOptionstringNoHow inserted data should be handled
includeValuesInResponsebooleanNoWhether the response should include appended values
valuesvalue[]Yes2D array of row values to append
majorDimensionstringNoMajor dimension of provided values

Example request

Send this JSON-RPC request through an initialized MCP client. Replace sample identifiers and values before calling the tool. See MCP client setup.

json
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "sheets__append_rows",
    "arguments": {
      "spreadsheetId": "example",
      "range": "example",
      "values": []
    }
  }
}

Result

No output schema is published for this tool. The input contract does not define its return fields. Inspect the MCP response content and isError; do not assume a fixed object shape. See the sheets integration reference for provider setup and tool context.

Full schemas

json
{
  "type": "object",
  "properties": {
    "spreadsheetId": {
      "type": "string",
      "description": "Google Sheets spreadsheet ID"
    },
    "range": {
      "type": "string",
      "description": "A1 notation range/table to append to"
    },
    "valueInputOption": {
      "type": "string",
      "description": "How input values should be interpreted"
    },
    "insertDataOption": {
      "type": "string",
      "description": "How inserted data should be handled"
    },
    "includeValuesInResponse": {
      "type": "boolean",
      "description": "Whether the response should include appended values"
    },
    "values": {
      "type": "array",
      "description": "2D array of row values to append"
    },
    "majorDimension": {
      "type": "string",
      "description": "Major dimension of provided values"
    }
  },
  "required": [
    "spreadsheetId",
    "range",
    "values"
  ],
  "description": "Arguments for the sheets__append_rows tool."
}