google-sheets

Server path: /google-sheets | Type: Application | PCID required: Yes Spreadsheet read, write, and formatting

Tools

Tool	Description
`google-sheets_create_spreadsheet`	Create a new Google Spreadsheet with customizable title
`google-sheets_list_sheets`	List all sheets/tabs within a Google Spreadsheet
`google-sheets_create_sheet`	Create a new sheet/tab within an existing Google Spreadsheet
`google-sheets_read_all_from_sheet`	Read all data from a specified sheet in a Google Spreadsheet with pagination support
`google-sheets_read_col_headings`	Read column headers/names from the first row of a Google Sheet
`google-sheets_read_rows`	Read specific rows from a Google Spreadsheet
`google-sheets_read_columns`	Read specific columns from a Google Spreadsheet
`google-sheets_edit_cell`	Edit a single cell in a Google Spreadsheet
`google-sheets_edit_row`	Edit an entire row in a Google Spreadsheet
`google-sheets_edit_column`	Edit an entire column in a Google Spreadsheet
`google-sheets_insert_row`	Insert a new row at a specified position in a Google Spreadsheet
`google-sheets_insert_column`	Insert a new column at a specified position in a Google Spreadsheet
`google-sheets_rename_sheet`	Rename a sheet/tab within a Google Spreadsheet
`google-sheets_rename_spreadsheet`	Rename the entire Google Spreadsheet file
`google-sheets_get_sheet_row_column_count`	Get the total dimensions of a Google Sheet including maximum rows and columns
`google-sheets_delete_sheet`	Delete a sheet/tab from a Google Spreadsheet
`google-sheets_delete_spreadsheet`	Delete an entire Google Spreadsheet file
`google-sheets_add_column`	Add a new column to a Google Sheets worksheet
`google-sheets_clear_cell`	Clear the content of a specific cell in a spreadsheet
`google-sheets_clear_rows`	Clear content from multiple rows in a spreadsheet
`google-sheets_find_row`	Find rows by searching for a value in a specific column
`google-sheets_copy_worksheet`	Copy a worksheet within the same spreadsheet or to another spreadsheet
`google-sheets_insert_comment`	Insert a comment on a specific cell in a spreadsheet
`google-sheets_update_formatting`	Update cell formatting (bold, italic, background color, etc.)

google-sheets_create_spreadsheet

Create a new Google Spreadsheet with customizable title Parameters:

Parameter	Type	Required	Default	Description
`title`	string	Yes	—	Title/name for the new spreadsheet

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "title": {
      "type": "string",
      "description": "Title/name for the new spreadsheet"
    }
  },
  "required": [
    "PCID",
    "title"
  ]
}

google-sheets_list_sheets

List all sheets/tabs within a Google Spreadsheet Parameters:

Parameter	Type	Required	Default	Description
`spreadsheetId`	string	Yes	—	Google Spreadsheet ID to list sheets from

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "Google Spreadsheet ID to list sheets from"
    }
  },
  "required": [
    "PCID",
    "spreadsheetId"
  ]
}

google-sheets_create_sheet

Create a new sheet/tab within an existing Google Spreadsheet Parameters:

Parameter	Type	Required	Default	Description
`spreadsheetId`	string	Yes	—	Google Spreadsheet ID to create a new sheet in
`title`	string	Yes	—	Name for the new sheet/tab

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "Google Spreadsheet ID to create a new sheet in"
    },
    "title": {
      "type": "string",
      "description": "Name for the new sheet/tab"
    }
  },
  "required": [
    "PCID",
    "spreadsheetId",
    "title"
  ]
}

google-sheets_read_all_from_sheet

Read all data from a specified sheet in a Google Spreadsheet with pagination support Parameters:

Parameter	Type	Required	Default	Description
`spreadsheetId`	string	Yes	—	Google Spreadsheet ID to read from
`sheetName`	string	No	—	Name of specific sheet to read from (defaults to first sheet)
`pageSize`	number	No	—	Number of rows to return per page (default: 1000, max: 10000)
`startRow`	number	No	—	Row number to start reading from (1-based indexing, default: 1)

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "Google Spreadsheet ID to read from"
    },
    "sheetName": {
      "type": "string",
      "description": "Name of specific sheet to read from (defaults to first sheet)"
    },
    "pageSize": {
      "type": "number",
      "description": "Number of rows to return per page (default: 1000, max: 10000)"
    },
    "startRow": {
      "type": "number",
      "description": "Row number to start reading from (1-based indexing, default: 1)"
    }
  },
  "required": [
    "PCID",
    "spreadsheetId"
  ]
}

google-sheets_read_col_headings

Read column headers/names from the first row of a Google Sheet Parameters:

Parameter	Type	Required	Default	Description
`spreadsheetId`	string	Yes	—	Google Spreadsheet ID to read from
`sheetName`	string	No	—	Name of sheet to read headers from (defaults to first sheet)

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "Google Spreadsheet ID to read from"
    },
    "sheetName": {
      "type": "string",
      "description": "Name of sheet to read headers from (defaults to first sheet)"
    }
  },
  "required": [
    "PCID",
    "spreadsheetId"
  ]
}

google-sheets_read_rows

Read specific rows from a Google Spreadsheet Parameters:

Parameter	Type	Required	Default	Description
`spreadsheetId`	string	Yes	—	Google Spreadsheet ID to read from
`sheetName`	string	No	—	Name of sheet to read from (defaults to first sheet)
`startRow`	number	No	—	Starting row index to read from (1-based, defaults to first row after header)
`endRow`	number	No	—	Ending row index to read to (1-based, defaults to last row with data)
`pageSize`	number	No	—	Number of rows to return per page (default: 1000)
`pageStartRow`	number	No	—	Row number to start the current page from (for pagination)

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "Google Spreadsheet ID to read from"
    },
    "sheetName": {
      "type": "string",
      "description": "Name of sheet to read from (defaults to first sheet)"
    },
    "startRow": {
      "type": "number",
      "description": "Starting row index to read from (1-based, defaults to first row after header)"
    },
    "endRow": {
      "type": "number",
      "description": "Ending row index to read to (1-based, defaults to last row with data)"
    },
    "pageSize": {
      "type": "number",
      "description": "Number of rows to return per page (default: 1000)"
    },
    "pageStartRow": {
      "type": "number",
      "description": "Row number to start the current page from (for pagination)"
    }
  },
  "required": [
    "PCID",
    "spreadsheetId"
  ]
}

google-sheets_read_columns

Read specific columns from a Google Spreadsheet Parameters:

Parameter	Type	Required	Default	Description
`spreadsheetId`	string	Yes	—	Google Spreadsheet ID to read from
`sheetName`	string	No	—	Name of sheet to read from (defaults to first sheet)
`columns`	number[]	No	—	Column indices to read (1-based, e.g., [1, 3, 5] for columns A, C, E. Defaults to all columns with data)
`pageSize`	number	No	—	Number of rows to return per page (default: 1000)
`startRow`	number	No	—	Row number to start reading from (1-based, default: 1)

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "Google Spreadsheet ID to read from"
    },
    "sheetName": {
      "type": "string",
      "description": "Name of sheet to read from (defaults to first sheet)"
    },
    "columns": {
      "type": "array",
      "items": {
        "type": "number"
      },
      "description": "Column indices to read (1-based, e.g., [1, 3, 5] for columns A, C, E. Defaults to all columns with data)"
    },
    "pageSize": {
      "type": "number",
      "description": "Number of rows to return per page (default: 1000)"
    },
    "startRow": {
      "type": "number",
      "description": "Row number to start reading from (1-based, default: 1)"
    }
  },
  "required": [
    "PCID",
    "spreadsheetId"
  ]
}

google-sheets_edit_cell

Edit a single cell in a Google Spreadsheet Parameters:

Parameter	Type	Required	Default	Description
`spreadsheetId`	string	Yes	—	Google Spreadsheet ID to edit
`sheetName`	string	No	—	Name of sheet to edit (defaults to first sheet)
`cellAddress`	string	Yes	—	Cell address in A1 notation (e.g., “A1”, “B5”, “Z100”)
`value`	string	Yes	—	New value to set in the cell (text, number, or formula)

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "Google Spreadsheet ID to edit"
    },
    "sheetName": {
      "type": "string",
      "description": "Name of sheet to edit (defaults to first sheet)"
    },
    "cellAddress": {
      "type": "string",
      "description": "Cell address in A1 notation (e.g., \"A1\", \"B5\", \"Z100\")"
    },
    "value": {
      "type": "string",
      "description": "New value to set in the cell (text, number, or formula)"
    }
  },
  "required": [
    "PCID",
    "spreadsheetId",
    "cellAddress",
    "value"
  ]
}

google-sheets_edit_row

Edit an entire row in a Google Spreadsheet Parameters:

Parameter	Type	Required	Default	Description
`spreadsheetId`	string	Yes	—	Google Spreadsheet ID to edit
`sheetName`	string	No	—	Name of sheet to edit (defaults to first sheet)
`rowIndex`	number	Yes	—	Row number to edit (1-based indexing)
`values`	string[]	Yes	—	Array of values to set in the row (one value per column)

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "Google Spreadsheet ID to edit"
    },
    "sheetName": {
      "type": "string",
      "description": "Name of sheet to edit (defaults to first sheet)"
    },
    "rowIndex": {
      "type": "number",
      "description": "Row number to edit (1-based indexing)"
    },
    "values": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "description": "Array of values to set in the row (one value per column)"
    }
  },
  "required": [
    "PCID",
    "spreadsheetId",
    "rowIndex",
    "values"
  ]
}

google-sheets_edit_column

Edit an entire column in a Google Spreadsheet Parameters:

Parameter	Type	Required	Default	Description
`spreadsheetId`	string	Yes	—	Google Spreadsheet ID to edit
`sheetName`	string	No	—	Name of sheet to edit (defaults to first sheet)
`columnLetter`	string	Yes	—	Column letter to edit (e.g., “A”, “B”, “C”, “AA”, “AB”)
`values`	string[]	Yes	—	Array of values to set in the column (one value per row)
`startRow`	number	Yes	—	Row number to start writing values from (1-based)

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "Google Spreadsheet ID to edit"
    },
    "sheetName": {
      "type": "string",
      "description": "Name of sheet to edit (defaults to first sheet)"
    },
    "columnLetter": {
      "type": "string",
      "description": "Column letter to edit (e.g., \"A\", \"B\", \"C\", \"AA\", \"AB\")"
    },
    "values": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "description": "Array of values to set in the column (one value per row)"
    },
    "startRow": {
      "type": "number",
      "description": "Row number to start writing values from (1-based)"
    }
  },
  "required": [
    "PCID",
    "spreadsheetId",
    "columnLetter",
    "values",
    "startRow"
  ]
}

google-sheets_insert_row

Insert a new row at a specified position in a Google Spreadsheet Parameters:

Parameter	Type	Required	Default	Description
`spreadsheetId`	string	Yes	—	Google Spreadsheet ID to edit
`sheetName`	string	No	—	Name of sheet to edit (defaults to first sheet)
`rowIndex`	number	No	—	Position to insert the new row (1-based, defaults to end of sheet)
`values`	string[]	No	—	Optional initial values for the new row

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "Google Spreadsheet ID to edit"
    },
    "sheetName": {
      "type": "string",
      "description": "Name of sheet to edit (defaults to first sheet)"
    },
    "rowIndex": {
      "type": "number",
      "description": "Position to insert the new row (1-based, defaults to end of sheet)"
    },
    "values": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "description": "Optional initial values for the new row"
    }
  },
  "required": [
    "PCID",
    "spreadsheetId"
  ]
}

google-sheets_insert_column

Insert a new column at a specified position in a Google Spreadsheet Parameters:

Parameter	Type	Required	Default	Description
`spreadsheetId`	string	Yes	—	Google Spreadsheet ID to edit
`sheetName`	string	No	—	Name of sheet to edit (defaults to first sheet)
`columnLetter`	string	No	—	Position to insert the new column (e.g., “A”, “B”, “C”, defaults to end of sheet)
`values`	string[]	No	—	Optional initial values for the new column

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "Google Spreadsheet ID to edit"
    },
    "sheetName": {
      "type": "string",
      "description": "Name of sheet to edit (defaults to first sheet)"
    },
    "columnLetter": {
      "type": "string",
      "description": "Position to insert the new column (e.g., \"A\", \"B\", \"C\", defaults to end of sheet)"
    },
    "values": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "description": "Optional initial values for the new column"
    }
  },
  "required": [
    "PCID",
    "spreadsheetId"
  ]
}

google-sheets_rename_sheet

Rename a sheet/tab within a Google Spreadsheet Parameters:

Parameter	Type	Required	Default	Description
`spreadsheetId`	string	Yes	—	Google Spreadsheet ID to edit
`sheetName`	string	No	—	Current name of sheet to rename (defaults to first sheet)
`newName`	string	Yes	—	New name for the sheet/tab

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "Google Spreadsheet ID to edit"
    },
    "sheetName": {
      "type": "string",
      "description": "Current name of sheet to rename (defaults to first sheet)"
    },
    "newName": {
      "type": "string",
      "description": "New name for the sheet/tab"
    }
  },
  "required": [
    "PCID",
    "spreadsheetId",
    "newName"
  ]
}

google-sheets_rename_spreadsheet

Rename the entire Google Spreadsheet file Parameters:

Parameter	Type	Required	Default	Description
`spreadsheetId`	string	Yes	—	Google Spreadsheet ID to rename
`newName`	string	Yes	—	New name for the spreadsheet file

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "Google Spreadsheet ID to rename"
    },
    "newName": {
      "type": "string",
      "description": "New name for the spreadsheet file"
    }
  },
  "required": [
    "PCID",
    "spreadsheetId",
    "newName"
  ]
}

google-sheets_get_sheet_row_column_count

Get the total dimensions of a Google Sheet including maximum rows and columns Parameters:

Parameter	Type	Required	Default	Description
`spreadsheetId`	string	Yes	—	Google Spreadsheet ID to get dimensions from
`sheetName`	string	No	—	Name of sheet to get row and column count from (defaults to first sheet)

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "Google Spreadsheet ID to get dimensions from"
    },
    "sheetName": {
      "type": "string",
      "description": "Name of sheet to get row and column count from (defaults to first sheet)"
    }
  },
  "required": [
    "PCID",
    "spreadsheetId"
  ]
}

google-sheets_delete_sheet

Delete a sheet/tab from a Google Spreadsheet Parameters:

Parameter	Type	Required	Default	Description
`spreadsheetId`	string	Yes	—	Google Spreadsheet ID to delete sheet from
`sheetName`	string	Yes	—	Name of sheet/tab to delete

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "Google Spreadsheet ID to delete sheet from"
    },
    "sheetName": {
      "type": "string",
      "description": "Name of sheet/tab to delete"
    }
  },
  "required": [
    "PCID",
    "spreadsheetId",
    "sheetName"
  ]
}

google-sheets_delete_spreadsheet

Delete an entire Google Spreadsheet file Parameters:

Parameter	Type	Required	Default	Description
`spreadsheetId`	string	Yes	—	Google Spreadsheet ID to delete

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "Google Spreadsheet ID to delete"
    }
  },
  "required": [
    "PCID",
    "spreadsheetId"
  ]
}

google-sheets_add_column

Add a new column to a Google Sheets worksheet Parameters:

Parameter	Type	Required	Default	Description
`spreadsheetId`	string	Yes	—	Google Spreadsheet ID
`sheetName`	string	Yes	—	Name of the worksheet to add column to
`columnIndex`	number	No	—	Index where to insert column (0-based). If not provided, adds at the end

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "Google Spreadsheet ID"
    },
    "sheetName": {
      "type": "string",
      "description": "Name of the worksheet to add column to"
    },
    "columnIndex": {
      "type": "number",
      "description": "Index where to insert column (0-based). If not provided, adds at the end"
    }
  },
  "required": [
    "PCID",
    "spreadsheetId",
    "sheetName"
  ]
}

google-sheets_clear_cell

Clear the content of a specific cell in a spreadsheet Parameters:

Parameter	Type	Required	Default	Description
`spreadsheetId`	string	Yes	—	Google Spreadsheet ID
`sheetName`	string	Yes	—	Name of the worksheet
`cell`	string	Yes	—	Cell reference in A1 notation (e.g., “A1”, “B5”)

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "Google Spreadsheet ID"
    },
    "sheetName": {
      "type": "string",
      "description": "Name of the worksheet"
    },
    "cell": {
      "type": "string",
      "description": "Cell reference in A1 notation (e.g., \"A1\", \"B5\")"
    }
  },
  "required": [
    "PCID",
    "spreadsheetId",
    "sheetName",
    "cell"
  ]
}

google-sheets_clear_rows

Clear content from multiple rows in a spreadsheet Parameters:

Parameter	Type	Required	Default	Description
`spreadsheetId`	string	Yes	—	Google Spreadsheet ID
`sheetName`	string	Yes	—	Name of the worksheet
`startRow`	number	Yes	—	Starting row number (1-based)
`endRow`	number	Yes	—	Ending row number (1-based)

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "Google Spreadsheet ID"
    },
    "sheetName": {
      "type": "string",
      "description": "Name of the worksheet"
    },
    "startRow": {
      "type": "number",
      "description": "Starting row number (1-based)"
    },
    "endRow": {
      "type": "number",
      "description": "Ending row number (1-based)"
    }
  },
  "required": [
    "PCID",
    "spreadsheetId",
    "sheetName",
    "startRow",
    "endRow"
  ]
}

google-sheets_find_row

Find rows by searching for a value in a specific column Parameters:

Parameter	Type	Required	Default	Description
`spreadsheetId`	string	Yes	—	Google Spreadsheet ID
`sheetName`	string	Yes	—	Name of the worksheet
`column`	string	Yes	—	Column to search in (A1 notation, e.g., “A”, “B”)
`value`	string	Yes	—	Value to search for
`exportRow`	boolean	No	`false`	Return full row data for matches

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "Google Spreadsheet ID"
    },
    "sheetName": {
      "type": "string",
      "description": "Name of the worksheet"
    },
    "column": {
      "type": "string",
      "description": "Column to search in (A1 notation, e.g., \"A\", \"B\")"
    },
    "value": {
      "type": "string",
      "description": "Value to search for"
    },
    "exportRow": {
      "type": "boolean",
      "default": false,
      "description": "Return full row data for matches"
    }
  },
  "required": [
    "PCID",
    "spreadsheetId",
    "sheetName",
    "column",
    "value"
  ]
}

google-sheets_copy_worksheet

Copy a worksheet within the same spreadsheet or to another spreadsheet Parameters:

Parameter	Type	Required	Default	Description
`spreadsheetId`	string	Yes	—	Source Google Spreadsheet ID
`sheetName`	string	Yes	—	Name of the worksheet to copy
`newSheetName`	string	Yes	—	Name for the copied worksheet
`destinationSpreadsheetId`	string	No	—	Destination spreadsheet ID (if copying to different spreadsheet)

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "Source Google Spreadsheet ID"
    },
    "sheetName": {
      "type": "string",
      "description": "Name of the worksheet to copy"
    },
    "newSheetName": {
      "type": "string",
      "description": "Name for the copied worksheet"
    },
    "destinationSpreadsheetId": {
      "type": "string",
      "description": "Destination spreadsheet ID (if copying to different spreadsheet)"
    }
  },
  "required": [
    "PCID",
    "spreadsheetId",
    "sheetName",
    "newSheetName"
  ]
}

google-sheets_insert_comment

Insert a comment on a specific cell in a spreadsheet Parameters:

Parameter	Type	Required	Default	Description
`spreadsheetId`	string	Yes	—	Google Spreadsheet ID
`sheetName`	string	Yes	—	Name of the worksheet
`cell`	string	Yes	—	Cell reference in A1 notation (e.g., “A1”, “B5”)
`comment`	string	Yes	—	Comment text to add

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "Google Spreadsheet ID"
    },
    "sheetName": {
      "type": "string",
      "description": "Name of the worksheet"
    },
    "cell": {
      "type": "string",
      "description": "Cell reference in A1 notation (e.g., \"A1\", \"B5\")"
    },
    "comment": {
      "type": "string",
      "description": "Comment text to add"
    }
  },
  "required": [
    "PCID",
    "spreadsheetId",
    "sheetName",
    "cell",
    "comment"
  ]
}

google-sheets_update_formatting

Update cell formatting (bold, italic, background color, etc.) Parameters:

Parameter	Type	Required	Default	Description
`spreadsheetId`	string	Yes	—	Google Spreadsheet ID
`sheetName`	string	Yes	—	Name of the worksheet
`range`	string	Yes	—	Range to format in A1 notation (e.g., “A1:B5”)
`bold`	boolean	No	—	Make text bold
`italic`	boolean	No	—	Make text italic
`backgroundColor`	string	No	—	Background color (hex format, e.g., “#FF0000”)
`textColor`	string	No	—	Text color (hex format, e.g., “#000000”)

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "Google Spreadsheet ID"
    },
    "sheetName": {
      "type": "string",
      "description": "Name of the worksheet"
    },
    "range": {
      "type": "string",
      "description": "Range to format in A1 notation (e.g., \"A1:B5\")"
    },
    "bold": {
      "type": "boolean",
      "description": "Make text bold"
    },
    "italic": {
      "type": "boolean",
      "description": "Make text italic"
    },
    "backgroundColor": {
      "type": "string",
      "description": "Background color (hex format, e.g., \"#FF0000\")"
    },
    "textColor": {
      "type": "string",
      "description": "Text color (hex format, e.g., \"#000000\")"
    }
  },
  "required": [
    "PCID",
    "spreadsheetId",
    "sheetName",
    "range"
  ]
}

Triggers API

Platform API

Embedded MCP Servers

Application MCP Servers

Tools

google-sheets_create_spreadsheet

google-sheets_list_sheets

google-sheets_create_sheet

google-sheets_read_all_from_sheet

google-sheets_read_col_headings

google-sheets_read_rows

google-sheets_read_columns

google-sheets_edit_cell

google-sheets_edit_row

google-sheets_edit_column

google-sheets_insert_row

google-sheets_insert_column

google-sheets_rename_sheet

google-sheets_rename_spreadsheet

google-sheets_get_sheet_row_column_count

google-sheets_delete_sheet

google-sheets_delete_spreadsheet

google-sheets_add_column

google-sheets_clear_cell

google-sheets_clear_rows

google-sheets_find_row

google-sheets_copy_worksheet

google-sheets_insert_comment

google-sheets_update_formatting

Triggers API

Platform API

Embedded MCP Servers

Application MCP Servers

​Tools

​google-sheets_create_spreadsheet

​google-sheets_list_sheets

​google-sheets_create_sheet

​google-sheets_read_all_from_sheet

​google-sheets_read_col_headings

​google-sheets_read_rows

​google-sheets_read_columns

​google-sheets_edit_cell

​google-sheets_edit_row

​google-sheets_edit_column

​google-sheets_insert_row

​google-sheets_insert_column

​google-sheets_rename_sheet

​google-sheets_rename_spreadsheet

​google-sheets_get_sheet_row_column_count

​google-sheets_delete_sheet

​google-sheets_delete_spreadsheet

​google-sheets_add_column

​google-sheets_clear_cell

​google-sheets_clear_rows

​google-sheets_find_row

​google-sheets_copy_worksheet

​google-sheets_insert_comment

​google-sheets_update_formatting

Tools

google-sheets_create_spreadsheet

google-sheets_list_sheets

google-sheets_create_sheet

google-sheets_read_all_from_sheet

google-sheets_read_col_headings

google-sheets_read_rows

google-sheets_read_columns

google-sheets_edit_cell

google-sheets_edit_row

google-sheets_edit_column

google-sheets_insert_row

google-sheets_insert_column

google-sheets_rename_sheet

google-sheets_rename_spreadsheet

google-sheets_get_sheet_row_column_count

google-sheets_delete_sheet

google-sheets_delete_spreadsheet

google-sheets_add_column

google-sheets_clear_cell

google-sheets_clear_rows

google-sheets_find_row

google-sheets_copy_worksheet

google-sheets_insert_comment

google-sheets_update_formatting