GoogleSheets_Suite_v2

Add a new sheet/tab to an existing spreadsheet

Append rows of data to the end of a sheet

Apply one or more updates to a spreadsheet (formatting, structural changes, etc.). Accepts an array of request objects.

Clear cell values from a named range in a spreadsheet.

Create a new spreadsheet with specified properties

Convenience tool to apply formatting (background color, text style, etc.) to a specific range. Uses repeatCell internally.

Retrieve spreadsheet metadata including title, sheet names, and properties

Read cell values from a named range in a spreadsheet

Convenience tool to sort data in a range based on specified criteria.

Write values to a range in a spreadsheet, replacing existing content