sheets_insert_link

Create a native Google Sheets table with typed columns and optional dropdown values

Append rows after the last row of an existing table. Default insertDataOption is OVERWRITE — set INSERTROWS to push existing rows down

Delete multiple sheet tabs in one request

Apply different formats to multiple ranges in one request

Read cell values from multiple ranges in one request

Write values to multiple ranges in one request

Verify that the service account can access a spreadsheet

Clear all values in a range (preserves formatting)

Copy a sheet to a different spreadsheet

Create a bar, line, pie, column or other chart on a sheet

Create a new Google Sheets file

Remove a chart from a spreadsheet

Delete one or more columns using a full-column A1 range

Delete one or more rows using a full-row A1 range

Remove a sheet tab by its numeric sheet ID

Delete a native Google Sheets table by table ID

Copy a sheet within the same spreadsheet

Apply background colour, font style, alignment and number format to a range

Read all conditional formatting rules and banded (alternating-colour) ranges defined on a sheet

Read cell formatting for a range and return it as compact A1Range→format pairs (run-length encoded). Identical adjacent cells are collapsed into rectangular ranges — reduces output by 90 %+ compared to per-cell data

Master one-shot tool — returns all structural and formatting metadata (merges, dimensions, conditional formatting, and optionally cell formatting) in a single API call. Supports fields filter and compactMode to limit response size

Return all merged cell ranges for a sheet, with A1 notation and raw GridRange coordinates

Get spreadsheet metadata: title, locale, sheets list with IDs, row/column counts

Return column widths, row heights, frozen column/row counts, and hidden flags for every column and row

Read raw cell formatting (background colour, font, borders, alignment, number format) for a range without returning cell values

Lightweight structural metadata only — no per-cell data. Returns dimensions, frozen rows/cols, tab colour, column widths, row heights, hidden columns/rows, and all merges in A1 notation. Single fast API call

Read native tables for a spreadsheet or a specific sheet

Read cell values from a single range

Insert a date/datetime value formatted correctly into a cell

Insert blank or pre-filled rows at a specific position

Add a new sheet tab to an existing spreadsheet

Merge a range of cells

Unmerge previously merged cells in a range

Set or remove borders on a range (style, width, colour per side)

Modify an existing chart's spec or position

Rename a sheet, change tab colour, toggle grid lines, etc.

Update an existing native Google Sheets table by table ID using an explicit field mask

Write values to a single range (overwrites existing content)