MCP Gsheets

sheets_get_values

Read cell values from a single range

sheets_batch_get_values

Read cell values from multiple ranges in one request

sheets_get_metadata

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

sheets_check_access

Verify that the service account can access a spreadsheet

sheets_update_values

Write values to a single range (overwrites existing content)

sheets_batch_update_values

Write values to multiple ranges in one request

sheets_append_values

Append rows after the last row of an existing table.

sheets_clear_values

Clear all values in a range (preserves formatting)

sheets_insert_rows

Insert blank or pre-filled rows at a specific position

sheets_delete_columns

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

sheets_delete_rows

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

sheets_insert_link

Insert a hyperlink formula into a cell

sheets_insert_date

Insert a date/datetime value formatted correctly into a cell

sheets_create_spreadsheet

Create a new Google Sheets file

sheets_insert_sheet

Add a new sheet tab to an existing spreadsheet

sheets_delete_sheet

Remove a sheet tab by its numeric sheet ID

sheets_duplicate_sheet

Copy a sheet within the same spreadsheet

sheets_copy_to

Copy a sheet to a different spreadsheet

sheets_update_sheet_properties

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

sheets_batch_delete_sheets

Delete multiple sheet tabs in one request

sheets_format_cells

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

sheets_batch_format_cells

Apply different formats to multiple ranges in one request

sheets_update_borders

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

sheets_merge_cells

Merge a range of cells

sheets_unmerge_cells

Unmerge previously merged cells in a range

sheets_add_conditional_formatting

Add a conditional formatting rule (gradient or boolean) to a range

sheets_add_table

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

sheets_update_table

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

sheets_delete_table

Delete a native Google Sheets table by table ID

sheets_get_tables

Read native tables for a spreadsheet or a specific sheet

sheets_create_chart

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

sheets_update_chart

Modify an existing chart's spec or position

sheets_delete_chart

Remove a chart from a spreadsheet

sheets_get_merged_cells

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

sheets_get_sheet_dimensions

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

sheets_get_sheet_formatting

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

sheets_get_conditional_formatting

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

sheets_get_sheet_structure

Lightweight structural metadata only — no per-cell data.

sheets_get_formatting_compact

Read cell formatting for a range and return it as compact A1Range→format pairs (run-length encoded).

sheets_get_full_sheet_snapshot

Master one-shot tool — returns all structural and formatting metadata (merges, dimensions, conditional formatting, and optionally cell formatting) in a single…