append_row
Add new rows to the end of Google Sheets spreadsheets programmatically to maintain updated data records and automate spreadsheet management tasks.
Instructions
スプレッドシートの最後に新しい行を追加します
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheetName | Yes | シート名 | |
| spreadsheetId | Yes | スプレッドシートのID | |
| values | Yes | 追加する行のデータ |
Input Schema (JSON Schema)
{
"properties": {
"sheetName": {
"description": "シート名",
"type": "string"
},
"spreadsheetId": {
"description": "スプレッドシートのID",
"type": "string"
},
"values": {
"description": "追加する行のデータ",
"items": {
"type": "string"
},
"type": "array"
}
},
"required": [
"spreadsheetId",
"sheetName",
"values"
],
"type": "object"
}