sheets_append_values
Add rows of data to a specified table in Google Sheets using a spreadsheet ID and A1 notation range. Choose how data is interpreted and inserted for precise control.
Instructions
Append values to the end of a table in a Google Sheets spreadsheet
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| insertDataOption | No | How the input data should be inserted (default: OVERWRITE) | |
| range | Yes | The A1 notation range of the table to append to (e.g., "Sheet1!A:B") | |
| spreadsheetId | Yes | The ID of the spreadsheet (found in the URL after /d/) | |
| valueInputOption | No | How the input data should be interpreted (default: USER_ENTERED) | |
| values | Yes | A 2D array of values to append, where each inner array represents a row |
Input Schema (JSON Schema)
{
"properties": {
"insertDataOption": {
"description": "How the input data should be inserted (default: OVERWRITE)",
"enum": [
"OVERWRITE",
"INSERT_ROWS"
],
"type": "string"
},
"range": {
"description": "The A1 notation range of the table to append to (e.g., \"Sheet1!A:B\")",
"type": "string"
},
"spreadsheetId": {
"description": "The ID of the spreadsheet (found in the URL after /d/)",
"type": "string"
},
"valueInputOption": {
"description": "How the input data should be interpreted (default: USER_ENTERED)",
"enum": [
"RAW",
"USER_ENTERED"
],
"type": "string"
},
"values": {
"description": "A 2D array of values to append, where each inner array represents a row",
"items": {
"type": "array"
},
"type": "array"
}
},
"required": [
"spreadsheetId",
"range",
"values"
],
"type": "object"
}