Tool

What it does

describe_sheet

Structural X-ray of a tab: header row, first data row, first free row, allowed dropdown values per column, merged cells, protected ranges and conditional-format rules. Call this before writing to any tab you don't already know

get_spreadsheet_info

Title, tabs and dimensions of the spreadsheet

get_sheet_data

All data of a tab as an array of rows

read_range

Read a specific A1 range

read_multiple_ranges

Read several ranges in a single API call — more efficient than calling read_range repeatedly

get_hyperlinks

Extract hyperlink URLs from cells in a range — useful when a cell displays text that links elsewhere

Tool

What it does

write_range

Write data into a range (overwrites)

update_cell

Update a single cell

batch_update_cells

Update multiple individual cells in a single API call

append_rows

Append rows at the end of a tab — the safe way to add data, never overwrites

find_replace

Find and replace text across the whole spreadsheet

clear_range

Clear a range

Tool

What it does

insert_rows

Insert N blank rows starting at a given row, pushing existing content down

delete_rows

Delete a range of rows

move_rows

Move rows to another position keeping their values, format, dropdowns and notes — a real move, not a copy+delete

insert_columns

Insert blank columns, pushing the rest to the right

delete_columns

Delete columns

sort_range

Sort a range by a column (ascending or descending)

auto_resize_columns

Auto-fit column widths to content

Tool

What it does

add_sheet

Create a new tab

rename_sheet

Rename a tab

copy_sheet

Duplicate a tab within the same spreadsheet

delete_sheet

Delete an entire tab

create_spreadsheet

Create a new empty spreadsheet

duplicate_spreadsheet

Clone an entire spreadsheet (all tabs and data)

Tool

What it does

insert_block

Create a new block (e.g. a month section) copying the look of existing ones — separator row, repeated header and blank rows ready to fill

Tool

What it does

set_data_validation

Create a dropdown on a range: the cell only accepts the given values

add_conditional_format

Auto-color cells that match a condition (e.g. green for DONE)

delete_conditional_format

Remove a conditional-format rule by index

Tool

What it does

set_borders

Add borders (outer and/or inner) to a range

merge_cells

Merge cells, e.g. for a block title spanning several columns

unmerge_cells

Undo merged cells in a range

add_banding

Apply alternating row colors ("zebra stripes")

Tool

What it does

delete_duplicates

Remove duplicate rows from a range, keeping the first occurrence

trim_whitespace

Strip leading/trailing/extra whitespace from cells — a stray space breaks exact-match dropdowns and formulas

text_to_columns

Split a text column into several by a separator

auto_fill

Continue a series automatically (dates, numbers, formulas), like dragging the corner handle

Tool

What it does

group_rows

Group rows so they can be collapsed/expanded with the +/- in the margin

ungroup_rows

Undo a row grouping

set_rows_visibility

Hide or show rows

set_column_width

Fix the width of one or more columns, in pixels

freeze_rows

Freeze the top N rows

set_filter

Turn on the header filter (the funnel icons for sort/filter)

clear_filter

Remove the filter from a tab

Tool

What it does

protect_range

Protect a range from accidental edits

unprotect_range

Remove a protection

add_named_range

Name a range so it can be referenced in formulas without breaking when rows move

copy_range

Copy a range to another location, choosing what to copy (values, format, or both)

cut_paste_range

Move a range of cells (cut from source, paste into destination, with formatting)

Name

Use

hecho

Light green — task done

in_progress

Light yellow — in progress

por_hacer

Light grey — pending

alta

Light red — high priority

media

Light yellow — medium priority

baja

Light blue — low priority

header

Steel blue — table header

white, red, green, blue, yellow, orange, purple, grey

Basic colors

#RRGGBB

Direct hex

Env var

Default

Purpose

GOOGLE_WORKSPACE_TOKEN_PATH

~/.config/google-workspace-mcp/token.json

Path to the OAuth token