add_named_range
ChatGPTCreates a named range in a spreadsheet.
Overview
Create and update spreadsheets with plain-language requests—no formulas to remember and no copying between tabs. Write or append data, build formulas, sort and filter rows, clean duplicates and whitespace, split text into columns, and find and replace values. Format cells with borders, merged cells, validation rules, and conditional formatting. Freeze and resize columns, manage named and protected ranges, and add charts linked to your data. Create new spreadsheets and sheets, duplicate or merge sheets, and move data between tabs. The plugin works with spreadsheets available to your connected account.
Tools
add_protected_range
ChatGPTAdds a protected range to prevent editing.
add_sheet
ChatGPTAdds a new sheet to a spreadsheet with optional properties.
add_table
ChatGPTConverts a header + data range into a native Google Sheets table (named, typed columns, header styling, filter chips) and optionally gives columns a type — DROPDOWN columns with options render as native dropdown chips. Use it for a new list-style table with dropdown columns; do not use it for matrices, calculation grids, report layouts or chart-source ranges. The range must start with a non-empty header row and contain at least one data row. Returns the table id and range.
append_cells
ChatGPTAppends rows of cells to the end of a sheet.
apply_conditional_format_to_sheet_range
ChatGPTCreates a new conditional format rule for a specific sheet range. IMPORTANT: Sheet conditional formatting does NOT support borders, alignment, font size, text wrap, padding, or number formats. This tool can only set fontColor, backgroundColor, bold, italic, underline, strikethrough. For borders/alignment/size, apply STATIC formatting via update_borders / update_cells on the specific cells that already meet the condition; do not pretend a CF rule will paint them.
apply_formula_to_sheet_range
ChatGPTWraps the existing content of every NON-EMPTY cell in an A1 range (on the sheet chosen by sheetId) in one function, e.g. turning 12 into =ROUND(12;2) or =A12 into =ROUND(A12;2) via the {__current__} argument. Empty cells are skipped, so this cannot fill an empty column — write formulas into empty cells with the update-cells tool (formulaValue) instead.
auto_resize_dimensions
ChatGPTAuto-resizes rows or columns to fit their content.
clear_basic_filter
ChatGPTRemoves the basic filter from a sheet.
copy_paste
ChatGPTCopies data from source range and pastes to destination.
create_sheet
ChatGPTCreates a new sheet within an existing spreadsheet.
create_spreadsheet
ChatGPTCreates a new spreadsheet.
cut_paste
ChatGPTCuts data from source range and pastes to destination.
delete_comment
ChatGPTPermanently deletes a comment thread, or a single reply when postId is given. Only the author's own comments can be deleted (Google rejects others). Prefer resolving (reply_comment with RESOLVE) over deleting; delete only comments you created in this conversation or that the user explicitly asked to remove.
delete_dimension
ChatGPTDeletes rows or columns from a sheet.
delete_duplicates
ChatGPTRemoves rows with duplicate values in specified columns.
delete_embedded_object
ChatGPTDeletes an embedded object like a chart or image.
delete_named_range
ChatGPTDeletes a named range from a spreadsheet.
delete_protected_range
ChatGPTRemoves a protected range from a sheet.
delete_range
ChatGPTDeletes a range of cells, shifting remaining cells.
delete_sheet
ChatGPTDeletes a sheet from a spreadsheet.
duplicate_sheet
ChatGPTDuplicates an existing sheet within a spreadsheet.
edit_sheet_conditional_format
ChatGPTEdits an existing conditional format rule for specific sheet.
find_replace
ChatGPTFinds and replaces text or formulas in a sheet or range. This EDITS the spreadsheet — to search without modifying anything, use search_sheet_values instead.
get_sheet_conditional_formats
ChatGPTRetrieves a list of conditional formats for specific sheet.
get_spreadsheet_info
ChatGPTGets a spreadsheet's structure: locale and formula separators, and for every sheet its exact title, sheetId, grid size, frozen rows/columns, basic filter, conditional-format count, chart ids with anchor cell and size, native tables (id, name, range, typed columns) and merged ranges, plus named ranges. Read this before writing so ranges use real titles and sheetIds.
insert_comment
ChatGPTAdds a comment thread anchored to one cell of a sheet, optionally assigned to a collaborator. Cell values and formats are not changed. Use it to review data, flag a suspicious value or formula, ask a question or leave feedback on a specific cell; anchor each comment to the exact cell it is about. Returns the new commentId.
insert_dimension
ChatGPTInserts new rows or columns into a sheet.
insert_dynamic_chart
ChatGPTInsert dynamic chart into the sheet from the data found in the given range.
insert_range
ChatGPTInserts empty cells in a range, shifting other cells.
list_comments
ChatGPTLists the comment threads of a spreadsheet: commentId, status, the anchored cell ('Sheet'!A1), quoted cell text, author, content, assignee and replies with postId. Read it before replying to, resolving or deleting a comment, and after inserting one to confirm it landed.
merge_cells
ChatGPTMerges cells in a specified range.
merge_sheets
ChatGPTMerges sheets inside single spreadsheet
modify_sheet_values
ChatGPTModifies values in a specific sheet range - can write, update, or clear values.
move_dimension
ChatGPTMoves rows or columns to a different position.
randomize_range
ChatGPTRandomizes the order of rows in a range.
read_cell_formats
ChatGPTReads cell formatting metadata (borders, fonts, fills, alignment, number formats, wrap, padding) and, with fields ['dataValidation'], each cell's dropdown/validation rule, for a range. USE THIS BEFORE making visual repairs (borders, alignment, fonts, fills) and before writing into cells that may carry dropdown validation — read_sheet_values returns ONLY values, never formatting or validation. Returns a compact JSON map keyed by A1 cell reference; cells with no relevant formatting or validation are omitted.
read_sheet_values
ChatGPTReads values from a specific sheet range.
remove_sheet_conditional_formats
ChatGPTRemoves an existing conditional format rules for specific sheet.
repeat_cell
ChatGPTRepeats a single cell format and/or value across a range.
replace_formulas_with_values
ChatGPTReplaces formulas in cells with their calculated values, freezes formula calculations.
reply_comment
ChatGPTReplies to a comment thread, resolves it (action RESOLVE, optionally with a closing reply) or reopens it (REOPEN). Read the thread with list_comments first so the reply answers what was actually asked; resolve only threads whose request is done or that the user told you to close.
search_sheet_values
ChatGPTSearches cell values across a spreadsheet (or a range) and returns the matching cell addresses with excerpts. Read-only — never modifies the spreadsheet. Use this to locate data; never use find_replace for searching.
search_spreadsheets
ChatGPTSearches for spreadsheets by name using Drive API (mimeType filter).
set_basic_filter
ChatGPTSets a basic filter on a sheet to enable data filtering.
set_data_validation
ChatGPTSets data validation rules for cells in a range.
sort_range
ChatGPTSorts data in a range based on specified columns.
text_to_columns
ChatGPTSplits text in cells into multiple columns based on a delimiter.
trim_whitespace
ChatGPTTrims leading and trailing whitespace from cells.
unmerge_cells
ChatGPTUnmerges previously merged cells.
update_borders
ChatGPTUpdates border formatting of cells in a range.
update_cells
ChatGPTUpdates multiple cells at once with formatting and values.
update_chart_spec
ChatGPTUpdates an existing chart's specification (type, data ranges, styling).
update_dimension_properties
ChatGPTUpdates row height or column width properties.
update_embedded_object_position
ChatGPTMoves and/or resizes an embedded object (a chart or image) by changing its anchor cell, pixel offsets, width or height. Only the given fields change; the chart spec is untouched (use update_chart_spec for content changes). Keep moves and spec edits as separate calls.
update_sheet_properties
ChatGPTUpdates properties of an existing sheet (title, hidden state, grid size, colors, etc.).
update_table
ChatGPTRenames a native Google Sheets table, changes its range (e.g. to cover rows appended below it) or replaces its typed columns / dropdown options. Only the given fields change. A table's range must cover every used row and column of the table; end indexes are exclusive.
Capabilities
Writes
Example Prompts
Click any prompt to copy it.
