Create a new Google Spreadsheet

Get metadata about a spreadsheet including all sheet names

Read data from a range of cells in a spreadsheet

Write data to a range of cells in a spreadsheet

Append rows to the end of a sheet

Clear values from a range of cells

Add a new sheet to an existing spreadsheet

Delete a sheet from a spreadsheet

Apply formatting to a range of cells

Perform multiple updates in a single request

Read formulas from cells (not just their calculated values)

Write formulas to cells

Create a named range in the spreadsheet

List all named ranges in a spreadsheet

Delete a named range

Apply advanced formatting including alignment, fonts, borders, and number formats

Set data validation rules for cells (e.g., dropdown lists, number ranges)

Insert columns or rows

Delete columns or rows

Auto-resize columns or rows to fit content

Find and replace text in a sheet

Duplicate an existing sheet

Sort a range by one or more columns

Merge cells in a range

Unmerge cells in a range

Create a chart in a spreadsheet

Update an existing chart in a spreadsheet

Delete a chart from a spreadsheet

List all charts in a spreadsheet

Create a native Google Sheets table with defined range, columns, and formatting

Retrieve information about a specific table

Update properties of an existing table

Delete a table from the spreadsheet

List all tables in a spreadsheet