Google Sheets

21 tools found.

• Add sheet

  Tool name: add_sheet

  Add a new sheet (tab) to an existing spreadsheet.

• Append

  Tool name: append

  Append data to a spreadsheet.

• Autofill

  Tool name: autofill

  Extend a formula or detected series from a source range into a larger destination range (like dragging the fill handle).

• Clear

  Destructive

  Tool name: clear

  Clear the values in a range while leaving the rows, columns, and formatting in place.

• Clear filter

  Destructive

  Tool name: clear_filter

  Remove a sheet's filter, restoring any rows it was hiding.

• Create

  Tool name: create

  Create a new spreadsheet.

• Create filter

  Tool name: create_filter

  Turn on filtering over a range of a sheet (the funnel button in the Sheets UI), so rows can be sorted and filtered by column.

• Delete rows

  Destructive

  Tool name: delete_rows

  Delete rows from a sheet, shifting the rows below them up.

• Fetch

  Read only

  Tool name: fetch

  Fetch the content of a Google Sheets spreadsheet using its spreadsheet ID.

• Format cells

  Tool name: format_cells

  Apply cell formatting over an A1 range: number format, bold/italic/underline/strikethrough, font family & size, text & background color, horizontal/vertical alignment, and text wrapping.

• Get metadata

  Read only

  Tool name: get_metadata

  Get metadata about a spreadsheet, including sheet names and properties.

• Group rows

  Tool name: group_rows

  Create a collapsible group over a contiguous range of rows, optionally collapsing it.

• Insert rows

  Tool name: insert_rows

  Insert blank rows at a specific position in a sheet, shifting existing rows down.

• List

  Read only

  Tool name: list

  List your Google Sheets spreadsheets.

• Search

  Read only

  Tool name: search

  Search Google Sheets spreadsheets by query and return basic details.

• Set column width

  Tool name: set_column_width

  Set the width of one or more adjacent columns, either to an explicit pixel size or to fit their contents (auto_fit).

• Set row height

  Tool name: set_row_height

  Set the height of one or more adjacent rows, either to an explicit pixel size or to fit their contents (auto_fit).

• Set row visibility

  Tool name: set_row_visibility

  Hide or unhide a contiguous range of rows in a sheet.

• Ungroup rows

  Destructive

  Tool name: ungroup_rows

  Remove a row group over a contiguous range of rows.

• Update

  Tool name: update

  Update values in a specific range.

• Update ranges

  Tool name: update_ranges

  Update several ranges (including non-contiguous ones) in a single call.