Google Sheets
GOOGLESHEETS_UPDATE_SPREADSHEET_PROPERTIES
Tool to update properties of a spreadsheet, such as its title, locale, or auto-recalculation settings. Use when you need to modify the overall configuration of a Google Sheet.
Remote googlesheets
Other tools also called GOOGLESHEETS_UPDATE_SPREADSHEET_PROPERTIES?
See providers with this name
Input Schema
{
"type": "object",
"properties": {
"fields": {
"type": "string",
"description": "The fields that should be updated. Use '*' for all fields in 'properties' or a comma-separated list (e.g., 'title,locale,iterativeCalculationSettings.maxIterations'). The root 'properties' is implied.\nExamples:\n \"title,locale\"\n \"iterativeCalculationSettings.maxIterations\"\n \"*\""
},
"properties": {
"type": "object",
"properties": {
"title": {
"type": [
"string",
"null"
],
"default": null,
"description": "The title of the spreadsheet.\nExample: \"My Awesome Spreadsheet\""
},
"locale": {
"type": [
"string",
"null"
],
"default": null,
"description": "The locale of the spreadsheet in BCP 47 format.\nExamples:\n \"en-US\"\n \"fr-FR\""
},
"timeZone": {
"type": [
"string",
"null"
],
"default": null,
"description": "The time zone of the spreadsheet in CLDR format (e.g., 'America/New_York').\nExample: \"America/Los_Angeles\""
},
"autoRecalc": {
"anyOf": [
{
"enum": [
"ON_CHANGE",
"MINUTE",
"HOUR"
],
"type": "string"
},
{
"type": "null"
}
],
"default": null,
"description": "The recalculation interval for the spreadsheet.\nExample: \"ON_CHANGE\""
},
"defaultFormat": {
"anyOf": [
{
"type": "object",
"properties": {
"textFormat": {
"anyOf": [
{
"type": "object",
"properties": {},
"additionalProperties": true
},
{
"type": "null"
}
],
"default": null,
"description": "The text format of the cell. Represents a TextFormat object."
},
"wrapStrategy": {
"type": [
"string",
"null"
],
"default": null,
"description": "The wrap strategy of the cell content. E.g., 'OVERFLOW_CELL', 'LEGACY_WRAP', 'CLIP', 'WRAP'."
},
"verticalAlignment": {
"type": [
"string",
"null"
],
"default": null,
"description": "The vertical alignment of the cell content. E.g., 'TOP', 'MIDDLE', 'BOTTOM'."
},
"horizontalAlignment": {
"type": [
"string",
"null"
],
"default": null,
"description": "The horizontal alignment of the cell content. E.g., 'LEFT', 'CENTER', 'RIGHT'."
},
"backgroundColorStyle": {
"anyOf": [
{
"type": "object",
"properties": {},
"additionalProperties": true
},
{
"type": "null"
}
],
"default": null,
"description": "The background color style of the cell. Represents a ColorStyle object."
}
},
"additionalProperties": false
},
{
"type": "null"
}
],
"default": null,
"description": "The default cell format for the entire spreadsheet."
},
"spreadsheetTheme": {
"anyOf": [
{
"type": "object",
"properties": {
"themeColors": {
"anyOf": [
{
"type": "array",
"items": {
"type": "object",
"properties": {},
"additionalProperties": true
}
},
{
"type": "null"
}
],
"default": null,
"description": "The theme colors of the spreadsheet. This is a list of ThemeColorPair."
},
"primaryFontFamily": {
"type": [
"string",
"null"
],
"default": null,
"description": "The primary font family of the spreadsheet theme."
}
},
"additionalProperties": false
},
{
"type": "null"
}
],
"default": null,
"description": "The theme of the spreadsheet."
},
"iterativeCalculationSettings": {
"anyOf": [
{
"type": "object",
"properties": {
"maxIterations": {
"anyOf": [
{
"type": "integer"
},
{
"type": "null"
}
],
"default": null,
"description": "The maximum number of iterations for iterative calculation.\nExample: 100"
},
"convergenceThreshold": {
"type": [
"number",
"null"
],
"default": null,
"description": "The threshold for convergence in iterative calculation.\nExample: 0.001"
}
},
"additionalProperties": false
},
{
"type": "null"
}
],
"default": null,
"description": "Settings for iterative calculation."
}
},
"description": "The properties to update. At least one field within properties must be set.",
"additionalProperties": false
},
"spreadsheetId": {
"type": "string",
"description": "The ID of the spreadsheet to update.\nExample: \"abc123spreadsheetId\""
}
}
}