Google Sheets MCP server

Read from the package source without running it. The installed server may list more.

• append_sheet_values

  Appends values to the next row of a detected data table in a spreadsheet. The operation automatically locates the table within the specified range and adds new rows starting from the first column of that table.

• apply_spreadsheet_updates

  Applies one or more updates to a spreadsheet atomically. All requests are validated before being applied; if any request is invalid, the entire batch fails and no changes are made. Responses mirror the structure of requests, with replies provided only for updates that generate them.

• clear_spreadsheet_values

  Clears all values from one or more specified ranges in a spreadsheet while preserving cell formatting, data validation, and other properties. Useful for resetting data while maintaining spreadsheet structure.

• clear_spreadsheet_values_by_filter

  Clears cell values from a spreadsheet based on one or more data filters, while preserving all formatting, validation rules, and other cell properties. Use this to selectively remove data from ranges matching your specified filter criteria.

• clear_spreadsheet_values_range

  Clears all values from specified cells in a spreadsheet while preserving formatting, data validation, and other cell properties. Specify the spreadsheet and target range using A1 or R1C1 notation.

• copy_sheet

  Copies a sheet from one spreadsheet to another and returns the properties of the newly created sheet. If no destination spreadsheet is specified, the sheet is copied within the same spreadsheet.

• create_spreadsheetwrite action
• get_developer_metadata

  Retrieves a specific developer metadata entry from a spreadsheet by its unique metadata ID. Use this to access custom metadata properties attached to spreadsheet resources.

• get_spreadsheet

  Retrieves a spreadsheet by its ID with optional support for specific cell ranges and grid data. By default, grid data is excluded; use field masks or the includeGridData parameter to include it.

• get_spreadsheet_values_batch

  Retrieves one or more ranges of values from a spreadsheet. Specify the spreadsheet ID and one or more ranges to fetch, with options to control how values and dates are formatted in the response.

• get_spreadsheet_values_by_filter

  Retrieves one or more ranges of values from a spreadsheet that match specified data filters. Multiple ranges matching any of the provided filters are returned in a single response.

• read_spreadsheet_range

  Retrieves cell values from a specified range in a spreadsheet. Supports flexible formatting options for dates, times, and formulas, with configurable output structure.

• retrieve_spreadsheet_by_data_filter

  Retrieves a spreadsheet by ID with the ability to filter which data ranges are returned. Use data filters to selectively fetch specific portions of the spreadsheet, optionally including grid data.

• search_developer_metadata

  Search for developer metadata entries in a spreadsheet that match specified criteria. Returns all metadata matching the provided data filters, which can target specific metadata lookups or location-based regions.

• update_sheet_valueswrite action

  Updates cell values in a spreadsheet within a specified range using A1 notation. Specify how input data should be interpreted (raw or user-entered formulas) and optionally retrieve the updated values in the response.

• update_sheet_values_batchwrite action

  Updates multiple ranges of cells in a spreadsheet with new values. Specify which ranges to update, how to interpret the input data, and optionally request the updated values in the response.

• update_spreadsheet_values_by_filterwrite action

  Updates cell values in one or more ranges of a spreadsheet using data filters to target specific cells. Allows you to set values across multiple matched ranges simultaneously and optionally retrieve the updated values in the response.

• Code scan5 source files scanned25/25
• –Live reliabilityno gateway calls yet and no remote to proben/a
• –Tool poisoningtools not inspected (local package is not executed); not countedn/a
• Auth qualitylocal package, no credentials required12/15
• Maintenancelast push 138 days ago8/15
• Maintainer identityregistry namespace matches repository owner7/10

Safety score

80/100

higher than 53% of 1,299 Productivity servers

Tools

17

the typical Productivity server has 7

Tools that change things

24%

typical: 0%. Fewer write tools means less an agent can break

GitHub stars

31

more than 86% of 854 Productivity servers

Google Sheets: common questions

Is Google Sheets MCP server safe?

Mostly: it is graded B (80/100). Read the Google Sheets safety report

How do I install Google Sheets?

It runs on your machine. Copy the Claude Code, Cursor, VS Code or Claude Desktop config from the install section.

Does Google Sheets need an API key?

Not as far as the registry entry and our scan can tell: no credentials are declared or required.

Is Google Sheets maintained?

The last commit was 176 days ago (2026-05-12). The latest release is v1.0.3.

What can I use instead of Google Sheets?

Servers from other publishers that do the same job: Gsheets MCP server, Sheets MCP server and Google Drive MCP server.

How does Google Sheets compare with other Productivity MCP servers?

safety score 80/100 (higher than 53% of 1,299 Productivity servers); tools 17 (the typical Productivity server has 7); tools that change things 24% (typical: 0%. Fewer write tools means less an agent can break). Full comparison.