Skip to main content
Append rows to a spreadsheet range

Tool details

FieldValue
Namesheets__append_rows
GroupIntegrations

Playground

Input schema

Input schema
{
  "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 can be interpreted"
    },
    "insertDataOption": {
      "type": "string",
      "description": "How inserted data can be handled"
    },
    "includeValuesInResponse": {
      "type": "boolean",
      "description": "Whether the response can 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": "Input schema for the sheets__append_rows tool."
}

Output schema

This tool does not publish an output schema.