write_sheet_data
Write data directly to a specified range in a Google Sheet using the Sheets API, no Apps Script required.
Instructions
✍️ Google Sheets API経由でデータ直接書き込み(Apps Script不要)
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | 書き込み開始位置(例: A1) | |
| values | Yes | 2D配列データ(例: [["A1", "B1"], ["A2", "B2"]]) | |
| spreadsheet_id | Yes | スプレッドシートID | |
| value_input_option | No | 入力方式 | USER_ENTERED |