Google Sheets MCP server for Claude, ChatGPT, Claude Code and Cursor

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 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.

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).

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.

Creates a new Google Spreadsheet in your Google Drive. Optionally specify a 'title' for the new spreadsheet; if omitted, a default name will be used.

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.

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 detailed information about a Google Spreadsheet. It provides metadata such as properties, sheets, and external data sources associated with the spreadsheet.

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.

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.

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 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.

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 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.

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.

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.

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 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.

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.

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.

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.

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.

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