Google Sheets

This action creates a new worksheet within a specified Google Sheet. Supports three sheet types: GRID (standard spreadsheet), OBJECT (chart on its own sheet), and DATA_SOURCE (connected to BigQuery). Users can define properties such as sheet name, tab color, grid dimensions, and chart/data source configurations.

This action searches for specific rows in a Google Sheets spreadsheet based on a given column's value. It then performs selected mathematical operations on another column's data to provide aggregated results.

This action appends new rows or columns to a specified sheet in a Google Spreadsheet. Use it to increase the size of the sheet by adding empty rows or columns as needed.

Auto-fit column widths or row heights for a dimension range using batchUpdate.autoResizeDimensions. Use when you need to automatically adjust row heights or column widths to fit content after writing data.

Clears cell values from a Google Sheet based on data filters. Only the values are removed while keeping cell formatting, data validation, and other properties intact.

This action retrieves data from specific cell ranges in a Google Spreadsheet. Users can specify which ranges to get the values from, and the action handles the necessary authentication and API requests.

Write values to a single range in a Google Sheet (or append as new rows). NOTE: This tool handles ONE range per call - for multiple ranges, make separate calls. Requires 'sheet_name' and 'values' parameters (the Google API's native 'data' array format is NOT supported).

Updates values in a Google Sheet by matching data filters instead of fixed cell ranges. Use this when you need to update cells based on specific criteria like developer metadata or grid ranges.

This action clears any existing basic filter from the specified sheet of a Google Spreadsheet. It allows users to reset the sheet's filter settings for better data visibility.

This action clears the content from a specified range in a Google Spreadsheet, using the provided A1 notation. The formatting and notes within the cells remain intact, making it ideal for resetting data without losing layout specifics.

This action creates a chart in a specified Google Sheets spreadsheet. Users can define the type of chart and the data range from which the chart will draw its data.

Creates a new Google Spreadsheet in your Google Drive. Optionally specify a 'title' for the new spreadsheet and a 'folder_id' or 'folder_name' to place it in a specific folder.

This action creates a new column in the specified Google Spreadsheet. You can specify the target sheet by its numeric ID (sheet_id) or by name (sheet_name). If neither is provided, the column is added to the first sheet.

This action creates a new row in the specified Google Spreadsheet at the given index. It can also inherit formatting from the preceding row if requested.

Delete an existing chart from a Google Sheets spreadsheet. Use this action when you need to remove a chart that is no longer needed or needs to be replaced. This action is irreversible — once a chart is deleted, it cannot be recovered. The chart data source (the cells containing the data) remains unchanged; only the chart visualization is removed.

Deletes rows or columns from a Google Sheet. Specify the range of rows or columns you want to remove, and they will be permanently deleted from the spreadsheet.

This action deletes a specified sheet from a given spreadsheet. It ensures that the selected sheet, along with its associated data sources if applicable, is removed from the document.

This action executes SQL queries directly on Google Sheets tables, allowing users to perform SQL operations like SELECT, INSERT, UPDATE, DELETE, and complex queries using WITH clauses (Common Table Expressions). It simplifies data manipulation within spreadsheets using familiar SQL syntax.

Finds and replaces text across cells in a Google Sheet. Useful for bulk text updates, fixing formula errors, or cleaning up data formatting issues throughout your spreadsheet.

Finds a worksheet by its title in a Google Spreadsheet. It checks if the exact title exists and returns the matched worksheet's metadata when found, or indicates not found with minimal response.

This action formats a specific range of cells in a Google Sheet. It allows the user to apply various text and background styling options to enhance the appearance of the selected cells.

DEPRECATED: Use GOOGLESHEETS_BATCH_GET instead. Tool to return one or more ranges of values from a spreadsheet. Use when you need to retrieve data from multiple ranges in a single request.

List conditional formatting rules for each sheet (or a selected sheet) in a normalized, easy-to-edit form. Use when you need to view, audit, or prepare to modify conditional format rules.

Tool to extract data validation rules from a Google Sheets spreadsheet. Use when you need to understand dropdown lists, allowed values, custom formulas, or other validation constraints for cells.

This action retrieves the names of all sheets in a specified Google Spreadsheet. It helps users to identify available sheets before performing further operations on them.

Retrieves specific data from a Google Sheet using filters (A1 notation ranges, developer metadata, or grid ranges). Recommended: Use GOOGLESHEETS_GET_SPREADSHEET_INFO for unfiltered spreadsheet metadata retrieval.

This action retrieves information about a Google Spreadsheet. By default, it returns essential metadata (spreadsheet ID, title, locale, timezone, and basic sheet properties like sheetId, title, index, sheetType, gridProperties). For spreadsheets with substantial metadata, this default prevents 'payload too large' errors. Use the 'fields' parameter to customize which fields are returned - either request specific fields you need or use '*' for comprehensive metadata (not recommended for large spreadsheets).

This action retrieves the schema of a specified table from a Google Spreadsheet. It analyzes the table structure, inferring details such as column names, types, and constraints from the sampled data.

This action inserts new rows or columns at a specified index within a Google Sheet. It allows users to expand their spreadsheet dynamically by adding empty dimensions where needed.

Lists all charts in a Google Sheets spreadsheet across all sheets, returning chart_id, sheet metadata, chart type, title, and position.

This action retrieves and lists all tables present in a specified Google Spreadsheet. It analyzes the structure of the spreadsheet and identifies tabular data, allowing users to understand the organization of their data at a glance.

This action searches for a specific text within a designated range of a Google Spreadsheet. It returns the first matching row where the entire content of a cell matches the provided query string.

Moves or resizes an existing chart by chartId — supports moving to a new sheet, moving to an existing sheet, or repositioning via overlay pixel coordinates.

Add, update, delete, or reorder conditional format rules on a Google Sheet. Use when you need to create, modify, or remove conditional formatting without manually building batchUpdate requests. Supports four operations: ADD (create new rule), UPDATE (replace existing rule), DELETE (remove rule), MOVE (reorder rules by changing index).

This action allows users to retrieve data from a specified table in a Google Spreadsheet using SQL-like queries. It facilitates operations such as filtering, sorting, and limiting results, making it easier to obtain specific information from the spreadsheet.

Searches for developer metadata within a Google Sheet. Use this to find specific metadata entries that have been attached to rows, columns, or sheets based on your filter criteria.

Searches for Google Spreadsheets in your Drive using various filters like name, content, creation date, and modification date. Useful for finding specific spreadsheets among many files.

Sets up a basic filter on a Google Sheet to filter or sort data within a specific range. Useful for organizing and viewing only the data that meets your criteria.

Tool to set or clear data validation rules (including dropdowns) on a range in Google Sheets. Use when you need to apply dropdown lists, range-based dropdowns, or custom formula validation to cells.

This action creates a new Google Spreadsheet and fills its first worksheet with data provided in JSON format. It requires a title for the spreadsheet, a name for the sheet, and a list of data rows. An empty list is allowed to create an empty spreadsheet.

Sorts a range of cells in a Google Sheet by one or more columns. Useful for organizing data in ascending or descending order based on specific columns.

Copies a single sheet from one Google Spreadsheet to another. Use this when you need to duplicate a sheet's data and formatting into a different spreadsheet.

This action appends values to the specified range in a Google Sheets spreadsheet. It allows users to add new data seamlessly to existing tables.

This action clears specified ranges of values from a given spreadsheet. It allows you to selectively remove data while preserving the overall structure and formatting of the spreadsheet.

This action retrieves specific ranges of values from a Google Spreadsheet based on defined data filters. It allows users to extract relevant data without needing to access entire sheets or predefined ranges.

Update the specification of an existing chart in a Google Sheets spreadsheet. Use this action when you need to modify an existing chart's properties such as its title, chart type, data ranges, colors, axes, or other visual settings. This action updates the chart's specification but does not change its position or size on the sheet.

Tool to hide/unhide rows or columns and set row heights or column widths. Use when you need to change visibility or pixel sizing of dimensions in a Google Sheet.

This action updates properties of a specified sheet within a Google Spreadsheet. You can modify attributes such as the sheet's title, index, visibility, and other visual properties.

Updates the overall SPREADSHEET-LEVEL properties of a Google Spreadsheet like its title, locale, time zone, and auto-recalculation settings. Use this to modify the spreadsheet's configuration. For updating individual sheet/tab properties (like renaming a sheet), use GOOGLESHEETS_UPDATE_SHEET_PROPERTIES instead.

Tool to set values in one or more ranges of a spreadsheet. Use when you need to update multiple ranges in a single operation for better performance.

This action updates existing rows and inserts new ones in a Google Sheet based on a unique key column. It automatically handles missing columns and supports partial updates of the data, ensuring that unnecessary data remains intact.

This action retrieves specified values from a Google Spreadsheet. It allows users to access data from particular cells or ranges, facilitating data extraction for further processing.

This action updates the specified range in a Google Spreadsheet with new values. It allows you to overwrite existing cell data or set values in an unfilled range.