Get a spreadsheet's title, URL, and the list of its sheets.

Returns each sheet's title, numeric sheetId, index, dimensions, and any frozen rows/columns. Use this first to discover sheet names and sizes.

Create a new spreadsheet and return its id and URL.

Optionally provide sheet_titles to seed multiple named sheets/tabs.

Add a new sheet/tab to an existing spreadsheet.

Rename a sheet/tab.

Delete a sheet/tab by name or numeric sheetId.

Duplicate a sheet/tab, optionally setting the new title and index.

Run allowlisted raw Sheets API batchUpdate requests.

Each request must contain exactly one allowed request kind. Data-source lifecycle requests are blocked, and a call may contain at most 50 requests. Prefer the typed tools when one exists; use this for advanced API coverage.

Read cell values from an A1 range (e.g. Sheet1!A1:C10).

value_render_option: FORMATTED_VALUE (as shown, default), UNFORMATTED_VALUE (typed values), or FORMULA (underlying formulas). Returns {"range", "values"} where values is a list of rows.

Read several A1 ranges at once. Returns {"valueRanges": [...]}.

Write a 2D array of values to an A1 range.

value_input_option: RAW (store verbatim as strings; default) or USER_ENTERED (parse like a user typing — formulas, dates, and numbers are evaluated). Opt in to USER_ENTERED explicitly; it evaluates formulas including those that can make external network requests.

Append rows after the last row of data within/near the given A1 range.

The range selects the table to append to (e.g. Sheet1!A1 or Sheet1!A:D); new rows are added below the existing data.

value_input_option: RAW (verbatim strings; default) or USER_ENTERED (evaluate formulas/dates/numbers — opt in explicitly).

Clear the values in an A1 range (formatting is preserved).

Write values to multiple ranges in one values batchUpdate call.

data items use the Sheets API ValueRange shape, e.g. {"range": "Sheet1!A1:B2", "values": [[1, 2], [3, 4]]}.

Clear values from multiple A1 ranges in one call.

Apply cell formatting to an A1 range. Only the arguments you pass change.

• text_color / background_color: "#RRGGBB", a named color (red, blue, lightgray, ...), or omit to leave unchanged.

• horizontal_alignment: LEFT | CENTER | RIGHT.

• vertical_alignment: TOP | MIDDLE | BOTTOM.

• wrap_strategy: OVERFLOW_CELL | CLIP | WRAP.

• number_format_type: TEXT | NUMBER | PERCENT | CURRENCY | DATE | TIME | DATE_TIME | SCIENTIFIC; pair with an optional number_format_pattern (e.g. "$#,##0.00", "0.0%").

Set borders on an A1 range.

style: SOLID | SOLID_MEDIUM | SOLID_THICK | DASHED | DOTTED | DOUBLE | NONE (use NONE to clear). top/bottom/ left/right are the outer edges; inner_* set borders between cells.

Merge cells in an A1 range.

merge_type: MERGE_ALL (one cell), MERGE_COLUMNS (merge each column vertically), or MERGE_ROWS (merge each row horizontally).

Unmerge any merged cells overlapping an A1 range.

Set a fixed pixel size for a band of columns or rows.

dimension: COLUMNS or ROWS. Indices are zero-based and half-open (start_index=0, end_index=3 covers the first three columns/rows).

Auto-fit columns or rows to their contents (zero-based, half-open range).

Freeze the first rows rows and/or columns columns of a sheet.

Pass 0 to unfreeze. Leaving an argument as None keeps it unchanged.

Insert rows before start_index; indices are zero-based and half-open.

Delete rows; indices are zero-based and half-open.

Insert columns before start_index; indices are zero-based and half-open.

Delete columns; indices are zero-based and half-open.

Append empty rows to the end of a sheet.

Append empty columns to the end of a sheet.

Move rows or columns to destination_index; indices are zero-based.

Insert cells in an A1 range, shifting existing cells by ROWS or COLUMNS.

Delete cells in an A1 range, shifting remaining cells by ROWS or COLUMNS.

Copy a range to another range.

Cut a range and paste it starting at a destination cell.

Paste delimited text/HTML starting at a single cell.

Sort a range using Sheets API SortSpec objects.

Find and replace text in one range or all sheets.

Trim leading/trailing/repeated whitespace in each cell in an A1 range.

Remove duplicate rows from a range, optionally comparing only column indexes.

Split a single-column range into multiple columns.

Autofill within an A1 range by detecting existing source data.

Randomize row order inside an A1 range.

Set the sheet's basic filter over an A1 range.

Clear the basic filter on a sheet.

Add a filter view over an A1 range.

Update a filter view using a Sheets API FilterView object.

Delete a filter view by ID.

Set a data validation rule on an A1 range.

Clear data validation from an A1 range.

Create a named range over an A1 range.

Update a named range's name and/or range.

Delete a named range by ID.

Protect an A1 range; defaults to warning-only protection.

Update a protected range using a Sheets API ProtectedRange object.

Delete a protected range by ID.

Add alternating-color banding to an A1 range.

Update banding using a Sheets API BandedRange object.

Delete banding by ID.

Group rows or columns over a zero-based, half-open range.

Collapse or expand a row/column group.

Delete a row/column group.

Add a Sheets table over an A1 range.

Update a table using a Sheets API Table object.

Delete a table by ID.

Create an embedded chart from existing sheet data.

chart_type: COLUMN, BAR, LINE, AREA, SCATTER, COMBO, STEPPED_AREA, PIE, or DONUT.

domain_range is the category/label range; series_ranges is one or more value ranges. Each source must be a single row or single column, e.g. Sheet1!A2:A10 plus Sheet1!B2:B10. Ranges without a sheet prefix use sheet. anchor_cell is where the chart is overlaid on that sheet.

Create an embedded chart from a full Sheets API ChartSpec object.

Use this for histogram, scorecard, bubble, candlestick, waterfall, treemap, org, or other chart specs not covered by create_chart.

Replace a chart's spec. Use move_chart to move or resize it.

Delete a chart or other embedded object by ID.

Move and/or resize a chart using overlay positioning.

Set an embedded object's border color.

Create a pivot table at a destination cell.

rows, columns, values, and filter_specs use the Sheets API PivotGroup/PivotValue/PivotFilterSpec shapes.

Add a slicer for a data range.

Update a slicer spec by ID.

Delete a slicer by embedded object ID.

Add a boolean conditional-format rule to an A1 range.

condition_type is a Sheets ConditionType such as NUMBER_GREATER, NUMBER_LESS, NUMBER_BETWEEN, TEXT_CONTAINS, TEXT_EQ, CUSTOM_FORMULA, BLANK, NOT_BLANK. values supplies the comparison operands (e.g. ["100"] or ["10","20"]; for CUSTOM_FORMULA a single ["=$A1>5"]). The format applies when the condition is true.

Replace a conditional-format rule at index.

Delete a conditional-format rule by sheet and index.

Compact, model-friendly snapshot of a spreadsheet in one call.

Accepts a spreadsheet ID or a full Google Sheets URL. Returns, per sheet: dimensions, frozen rows/cols, column headers with inferred types (number/date-ish/boolean/text/formula), a few sample rows, and any tables/charts. Use this first to ground natural requests like "the Revenue column" before calling other tools.

Write a titled table and format it in one shot.

anchor is where the top-left header goes: Sheet1!A1, a bare cell (first sheet), or a sheet name (its A1). Applies a style preset (clean/financial/report-header/input) to the header, optionally freezes the header row, adds banding, auto-fits columns, and applies per-column number_formats ({"Revenue": "currency"}). Set preview=True to get the planned ranges/requests without changing anything.

Apply a named style preset to a range.

Presets: clean (bold shaded header + underline), financial (currency, right-aligned body + bold header), report-header (merged centered title), input (highlighted bordered input cells). range accepts A1 or natural refs like "whole sheet".

Conditionally highlight cells from a natural predicate.

condition examples: "> 100", "between 10 and 20", "contains overdue", "blank", "duplicates", "top 10%". Applies the given background color (default light amber), and/or text_color/bold. range accepts A1 or natural refs.

Apply a number format to a range.

kind: currency | percent | date | datetime | thousands | number | plain. range accepts A1 or natural refs (e.g. a header name resolves to its whole column).

Append a bold totals row beneath a table.

By default sums every column except the first (which gets a "Total" label). Override per column with functions keyed by header name, e.g. {"Margin": "AVERAGE", "Count": "COUNT"}.

Auto-fit column widths to their contents.

target may be a sheet name (fits all columns) or an A1 range like Sheet1!A:D (fits just those columns).

Sort a range by a column identified by its header name (or letter).

order is asc or desc. Assumes the first row of range is a header (its cells are not sorted into the body).