Google Sheets
gs_append_values
Append rows after the last row with data in the specified range. Automatically finds the end of existing data and adds new rows below.
Remote node2flow/google-sheets
Other tools also called gs_append_values?
See providers with this name
Input Schema
{
"type": "object",
"properties": {
"range": {
"type": "string",
"description": "A1 notation range that defines the table to append to (e.g. \"Sheet1!A:E\")"
},
"values": {
"type": "array",
"items": {
"type": "array",
"items": {}
},
"description": "2D array of rows to append. Example: [[\"Alice\",30],[\"Bob\",25]]"
},
"spreadsheet_id": {
"type": "string",
"description": "The spreadsheet ID"
},
"insert_data_option": {
"type": "string",
"description": "\"INSERT_ROWS\" (default, inserts new rows) or \"OVERWRITE\" (writes over existing)"
},
"value_input_option": {
"type": "string",
"description": "How input is interpreted: \"USER_ENTERED\" (default) or \"RAW\""
}
}
}