Workspace
Google Sheets capabilities
Google Sheets holds the numbers behind the work. The agent can read ranges, add rows, build summary tables, format cells, and turn raw data into something you can act on.
50 capabilities
Good for
- Updating a tracker without opening it
- Turning raw exports into summaries
- Finding and fixing rows in bulk
- Formatting and validating data
What it cannot do
- Edits save immediately; undoing them relies on Drive's version history.
- Reads return calculated values, so a formula that has not recalculated in Sheets is read as it stands.
- Exports produce a new XLSX or PDF file rather than changing the original sheet.
What we'll ask for
- Read your spreadsheets and their values
- Create, edit, and organise sheets, rows, columns, and charts
- Manage formatting, filters, and data validation
Try asking
- "Add this week's expenses to my tracker and total them by category"
- "Turn the raw export into a summary sheet with a chart"
- "Find every row where the status is overdue and highlight it"
All Google Sheets capabilities
These act through your connected Google Sheets account.
Read
- Aggregate column dataGOOGLESHEETS_AGGREGATE_COLUMN_DATA
Matches rows on a column value and totals the matching numbers.
- Batch get valuesGOOGLESHEETS_BATCH_GET
Reads several cell ranges in one request.
- Export as XLSXGOOGLESHEETS_EXPORT_DRIVE_FILE
Exports a whole spreadsheet as an XLSX file.
- Export sheet as PDFGOOGLESHEETS_EXPORT_SHEET_AS_PDF
Renders one tab or range as a PDF with layout controls.
- Get conditional format rulesGOOGLESHEETS_GET_CONDITIONAL_FORMAT_RULES
Lists the conditional formatting rules on each sheet.
- Get data validation rulesGOOGLESHEETS_GET_DATA_VALIDATION_RULES
Reads the data validation rules in a spreadsheet.
- Get file metadataGOOGLESHEETS_GET_DRIVE_FILE_METADATA
Reads a Drive file's metadata without downloading it.
- Get sheet namesGOOGLESHEETS_GET_SHEET_NAMES
Lists every tab name in a spreadsheet.
- Get spreadsheet by filterGOOGLESHEETS_GET_SPREADSHEET_BY_DATA_FILTER
Reads spreadsheet data narrowed by a data filter.
- Get spreadsheet infoGOOGLESHEETS_GET_SPREADSHEET_INFO
Reads a spreadsheet's structure and metadata.
- List chartsGOOGLESHEETS_LIST_CHARTS
Lists every chart across a spreadsheet's sheets.
- List Drive changesGOOGLESHEETS_LIST_DRIVE_CHANGES
Starts or continues a Drive change feed.
- Batch get values by filterGOOGLESHEETS_SPREADSHEETS_VALUES_BATCH_GET_BY_DATA_FILTER
Reads the ranges that match a data filter.
- Get valuesGOOGLESHEETS_VALUES_GET
Reads a range of values from a spreadsheet.
Create
- Add sheetGOOGLESHEETS_ADD_SHEET
Adds a new tab to a spreadsheet.
- Append rows or columnsGOOGLESHEETS_APPEND_DIMENSION
Extends a sheet by adding rows or columns at the end.
- Create chartGOOGLESHEETS_CREATE_CHART
Adds a chart built from a chosen data range.
- Create spreadsheetGOOGLESHEETS_CREATE_GOOGLE_SHEET1
Creates a new spreadsheet in Drive.
- Add columnGOOGLESHEETS_CREATE_SPREADSHEET_COLUMN
Adds a new column to a spreadsheet.
- Insert rowGOOGLESHEETS_CREATE_SPREADSHEET_ROW
Inserts an empty row at a chosen position.
- Insert rows or columnsGOOGLESHEETS_INSERT_DIMENSION
Inserts rows or columns at a chosen position.
- Copy sheetGOOGLESHEETS_SPREADSHEETS_SHEETS_COPY_TO
Copies a sheet into another spreadsheet.
- Append valuesGOOGLESHEETS_SPREADSHEETS_VALUES_APPEND
Adds rows of values after the last row of data.
Update
- Auto-fit dimensionsGOOGLESHEETS_AUTO_RESIZE_DIMENSIONS
Fits column widths or row heights to their content.
- Clear values by filterGOOGLESHEETS_BATCH_CLEAR_VALUES_BY_DATA_FILTER
Clears the ranges that match a data filter.
- Batch update by filterGOOGLESHEETS_BATCH_UPDATE_VALUES_BY_DATA_FILTER
Updates the ranges that match a data filter.
- Clear basic filterGOOGLESHEETS_CLEAR_BASIC_FILTER
Removes the basic filter from a sheet.
- Clear valuesGOOGLESHEETS_CLEAR_VALUES
Clears cell contents while keeping formatting and notes.
- Find and replaceGOOGLESHEETS_FIND_REPLACE
Finds text in a spreadsheet and replaces it.
- Format cellsGOOGLESHEETS_FORMAT_CELL
Applies text and background formatting to a range.
- Move chartGOOGLESHEETS_MOVE_CHART
Moves or resizes a chart on a sheet.
- Move to folderGOOGLESHEETS_MOVE_SPREADSHEET_TO_FOLDER
Moves a spreadsheet into a different Drive folder.
- Edit conditional format rulesGOOGLESHEETS_MUTATE_CONDITIONAL_FORMAT_RULES
Adds, updates, removes, or reorders conditional format rules.
- Set basic filterGOOGLESHEETS_SET_BASIC_FILTER
Applies a basic filter to a sheet.
- Set data validationGOOGLESHEETS_SET_DATA_VALIDATION_RULE
Sets or clears validation rules, including dropdowns.
- Sort rangeGOOGLESHEETS_SORT_RANGE
Sorts a range by one or more columns.
- Batch clear valuesGOOGLESHEETS_SPREADSHEETS_VALUES_BATCH_CLEAR
Clears several ranges in one request.
- Update chartGOOGLESHEETS_UPDATE_CHART
Changes an existing chart's specification.
- Update dimension propertiesGOOGLESHEETS_UPDATE_DIMENSION_PROPERTIES
Hides or shows rows and columns and sets their sizes.
- Update sheet propertiesGOOGLESHEETS_UPDATE_SHEET_PROPERTIES
Changes a tab's name, colour, or grid properties.
- Update spreadsheet propertiesGOOGLESHEETS_UPDATE_SPREADSHEET_PROPERTIES
Changes spreadsheet-level properties such as the title.
- Update values in batchGOOGLESHEETS_UPDATE_VALUES_BATCH
Writes values into one or more ranges.
- Upsert rowsGOOGLESHEETS_UPSERT_ROWS
Updates rows by key and appends the ones that are new.
- Update valuesGOOGLESHEETS_VALUES_UPDATE
Writes values into a range.
Delete
- Delete chartGOOGLESHEETS_DELETE_CHART
Removes a chart from a spreadsheet.
- Delete rows or columnsGOOGLESHEETS_DELETE_DIMENSION
Removes chosen rows or columns from a sheet.
- Delete sheetGOOGLESHEETS_DELETE_SHEET
Removes a tab from a spreadsheet.
Search
- Look up rowGOOGLESHEETS_LOOKUP_SPREADSHEET_ROW
Finds the first row whose cell exactly matches a value.
- Search developer metadataGOOGLESHEETS_SEARCH_DEVELOPER_METADATA
Searches a spreadsheet's developer metadata.
- Search spreadsheetsGOOGLESHEETS_SEARCH_SPREADSHEETS
Finds spreadsheets by name, content, or date.
Common questions
- Can OptInsta google sheets handle everything I need?
- Google Sheets: Edits save immediately; undoing them relies on Drive's version history.
- Can OptInsta google sheets handle everything I need?
- Google Sheets: Reads return calculated values, so a formula that has not recalculated in Sheets is read as it stands.
- Can OptInsta google sheets handle everything I need?
- Google Sheets: Exports produce a new XLSX or PDF file rather than changing the original sheet.
Also works with
Last updated: 2026-09-24