write_sheet
Write data to specified ranges in Google Sheets using the Google Sheets MCP Server. Input spreadsheet ID, range, and values to update spreadsheets programmatically.
Instructions
スプレッドシートの指定された範囲にデータを書き込みます
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | 書き込む範囲（例: 'Sheet1!A1:C10'） | |
| spreadsheetId | Yes | スプレッドシートのID | |
| values | Yes | 書き込むデータ（2次元配列） |
Input Schema (JSON Schema)
{
"properties": {
"range": {
"description": "書き込む範囲（例: 'Sheet1!A1:C10'）",
"type": "string"
},
"spreadsheetId": {
"description": "スプレッドシートのID",
"type": "string"
},
"values": {
"description": "書き込むデータ（2次元配列）",
"items": {
"items": {
"type": "string"
},
"type": "array"
},
"type": "array"
}
},
"required": [
"spreadsheetId",
"range",
"values"
],
"type": "object"
}