Google Sheets
GOOGLESHEETS_SPREADSHEETS_VALUES_APPEND
Tool to append values to a spreadsheet. Use when you need to add new data to the end of an existing table in a Google Sheet.
Remote googlesheets
Other tools also called GOOGLESHEETS_SPREADSHEETS_VALUES_APPEND?
See providers with this name
Input Schema
{
"type": "object",
"properties": {
"range": {
"type": "string",
"description": "The A1 notation of a range to search for a logical table of data. Values are appended after the last row of the table.\nExample: \"Sheet1!A1:B2\""
},
"values": {
"type": "array",
"items": {
"type": "array",
"items": {
"anyOf": [
{
"type": "string"
},
{
"type": "integer"
},
{
"type": "number"
},
{
"type": "boolean"
}
]
}
},
"description": "The data to be written. This is an array of arrays, the outer array representing all the data and each inner array representing a major dimension. Each item in the inner array corresponds with one cell.\nExample: [[\"A1_val1\",\"A1_val2\"],[\"A2_val1\",\"A2_val2\"]]"
},
"spreadsheetId": {
"type": "string",
"description": "The ID of the spreadsheet to update.\nExample: \"1q0gLhLdGXYZblahblahblah\""
},
"majorDimension": {
"anyOf": [
{
"enum": [
"ROWS",
"COLUMNS"
],
"type": "string"
},
{
"type": "null"
}
],
"default": null,
"description": "The major dimension of the values. For output, if the spreadsheet data is: A1=1,B1=2,A2=3,B2=4, then requesting range=A1:B2,majorDimension=ROWS will return [[1,2],[3,4]], whereas requesting range=A1:B2,majorDimension=COLUMNS will return [[1,3],[2,4]].\nExample: \"ROWS\""
},
"insertDataOption": {
"anyOf": [
{
"enum": [
"OVERWRITE",
"INSERT_ROWS"
],
"type": "string"
},
{
"type": "null"
}
],
"default": null,
"description": "How the input data should be inserted.\nExample: \"INSERT_ROWS\""
},
"valueInputOption": {
"enum": [
"RAW",
"USER_ENTERED"
],
"type": "string",
"description": "How the input data should be interpreted.\nExample: \"USER_ENTERED\""
},
"includeValuesInResponse": {
"type": [
"boolean",
"null"
],
"default": null,
"description": "Determines if the update response should include the values of the cells that were appended. By default, responses do not include the updated values.\nExample: true"
},
"responseValueRenderOption": {
"anyOf": [
{
"enum": [
"FORMATTED_VALUE",
"UNFORMATTED_VALUE",
"FORMULA"
],
"type": "string"
},
{
"type": "null"
}
],
"default": null,
"description": "Determines how values in the response should be rendered. The default render option is FORMATTED_VALUE.\nExample: \"FORMATTED_VALUE\""
},
"responseDateTimeRenderOption": {
"anyOf": [
{
"enum": [
"SERIAL_NUMBER",
"FORMATTED_STRING"
],
"type": "string"
},
{
"type": "null"
}
],
"default": null,
"description": "Determines how dates, times, and durations in the response should be rendered. This is ignored if responseValueRenderOption is FORMATTED_VALUE. The default dateTime render option is SERIAL_NUMBER.\nExample: \"SERIAL_NUMBER\""
}
}
}