Get data from Google Sheets with optional formatting

Update data in Google Sheets with optional formatting

Create a new Google Sheets with optional initial data and formatting

Apply formatting to cells including colors, fonts, borders, and alignment

Apply conditional formatting rules to cells

Merge cells in a range

Create various types of charts in Google Sheets

Update an existing chart in Google Sheets

Set data validation rules for cells

Protect a range of cells from editing

Insert rows at a specific position

Insert columns at a specific position

Delete rows from a specific position

Delete columns from a specific position

Set formulas in cells

Calculate the result of a formula

Create a new sheet in the spreadsheet

Duplicate an existing sheet

Delete a sheet from the spreadsheet

Rename an existing sheet

Hide a sheet from view (make it invisible)

Show a hidden sheet (make it visible again)

Move a sheet to a different position in the spreadsheet

Get detailed information about all sheets in a spreadsheet

Get properties of a specific sheet (title, index, hidden status, etc.)

Create a chart with data and automatically populate it

Create a chart from a table structure with headers and data

Update chart data and refresh the chart

Delete a chart from the spreadsheet

List all charts in a spreadsheet with their details

Search for Google Sheets by name or content

Share Google Sheets with specific permissions

Get comprehensive metadata about Google Sheets

Perform multiple operations in a single request for better performance

Get data from multiple ranges in a single request

Clear content and formatting from a range

Copy a sheet to another spreadsheet