Google Sheets

Add a new sheet (tab) to an existing spreadsheet with customizable properties.

Permanently delete a sheet (tab) from a spreadsheet. Cannot be undone.

Update sheet properties like title, position, visibility, or tab color.

Copy a sheet within the same spreadsheet or to a different spreadsheet.

Sorts data in rows based on a sort order per column. Supports multi-column sorting and color-based sorting.

Sets data validation rules to cells in a range. Supports number, text, date validation, dropdown lists, and custom rules. Use empty rule to clear validation.

Sets a basic filter on a sheet with optional sorting and column-specific filter criteria. Supports text, number, and date filtering.

Add a chart (bar, line, area, column, scatter, combo, stepped area) to a spreadsheet. Requires A1 ranges for domain (x-axis) and series (y-axis) data.

Create a new spreadsheet with specified title and optional properties.

Retrieve spreadsheet information including metadata, sheets, and optionally cell data.

Update spreadsheet properties such as title, locale, or timezone.

Read cell values from a specified range using A1 notation (e.g., ‘Sheet1!A1:B10’).

Write cell values to a specified range. Supports formulas and raw values.

Append rows to the end of a table, automatically finding the last row with data.

Clear cell values from a range while preserving formatting and structure.

Read cell values from multiple ranges in a single efficient API call.

Update multiple ranges with values in a single efficient API call.

Clear values from multiple ranges in a single API call while preserving formatting.