Update sheet settings
update_sheet_settingsUpdate display settings for one sheet, or show and hide columns. Pass sheet_id or sheet_number. Display keys: hide_empty_columns, wrap_text, wrap_header_text, table_compactness (compact, normal, or plus), show_images, image_field, image_field_fallback, export_all_columns. To show or hide columns, pass columns: [{ column, visible }]. column is a column id (such as data3) or the header name. The value is trimmed and matched case-insensitively. A column id wins when it matches. If several columns share a header name, pass the column id. Optional value_kind is text, currency, ean13_body, ean8_body, upca_body, or upce_body. Optional currency_code is three uppercase letters (ISO 4217), for example NOK. An empty currency_code clears the code. A code without value_kind sets the column to currency. Names, order, width, and image_field stay as stored. Existing cell values are not converted. Shopify store sheets are refused. Hiding a catalog variant axis column is refused. An unknown column, a shared header name, two different visible values, or two different currency settings for the same column returns an error and nothing is saved.
Tool call template
This tool declares no required parameters. Add optional parameters from the input schema as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {},
"name": "update_sheet_settings"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| columns | No | ||
| sheet_id | No | ||
| wrap_text | No | ||
| image_field | No | ||
| show_images | No | ||
| sheet_number | No | ||
| wrap_header_text | No | ||
| table_compactness | No | ||
| export_all_columns | No | ||
| hide_empty_columns | No | ||
| image_field_fallback | No |