sheets.googleapis.com

Add an embedded basic chart (column, line, or bar) to a Google Sheet, overlaid on a sheet or placed on a new sheet.

Sort a data range by one or more columns and apply a basic filter (with per-column sort/hide criteria) to a Google Sheet.

Find and replace text across a single range, one sheet, or every sheet in a Google Spreadsheet, with optional case matching and regex.

Protect a range or an entire sheet in Google Sheets from edits, optionally warning-only or restricted to specific editors.

Create an in-cell dropdown or numeric/text data-validation rule that restricts what values a range of Google Sheets cells can hold.

Create an in-cell dropdown or numeric/text data-validation rule that restricts what values a range of Google Sheets cells can hold.

Add a conditional formatting rule (boolean highlight or color gradient) to a range in a Google Sheet.

Bold-format a Google Sheet's header row and freeze it so it stays visible while scrolling.

Copy a single sheet/tab from one Google Spreadsheet into another spreadsheet, then rename the resulting sheet.

Clear cell values without touching formatting, or permanently delete entire rows/columns, choosing the correct Google Sheets API call for each.

Import raw CSV text directly into a Google Sheet using batchUpdate's PasteDataRequest instead of pre-parsing it client-side.

Read several non-contiguous ranges and write several ranges of a Google Sheet, each in one batch API call.

Add, rename, or delete a sheet (tab) within an existing Google Spreadsheet via a single batchUpdate call.

Create a new Google Sheet using a service account and share it with a human Google account so it appears in their Drive.