Model Context Protocol moderate risk

Gsheets

MCP server for Google Sheets API, enabling read, write, and management of spreadsheets via various authentication methods.

Connections & Capabilities

Connects To

GitHubGCPGoogle Sheets

Capabilities

readwriteadmin

Quickstart

Install

npm install

npm

Config

{
  "mcpServers": {
    "mcp-gsheets": {
      "command": "npx",
      "args": ["-y", "mcp-gsheets@latest"],
      "env": {
        "GOOGLE_PROJECT_ID": "your-project-id",
        "GOOGLE_APPLICATION_CREDENTIALS": "/absolute/path/to/service-account-key.json"
      }
    }
  }
}

Exposed MCP Tools (24)

safe

sheets_get_values

Reads data from a specified range in a Google Sheet.

Read-only operation; no data modification.

safe

sheets_batch_get_values

Reads data from multiple ranges in a Google Sheet.

Read-only operation; no data modification.

safe

sheets_get_metadata

Retrieves metadata about a Google Sheet, such as its properties and structure.

Read-only operation; no data modification.

safe

sheets_check_access

Checks the access permissions for a Google Sheet.

Read-only operation; no data modification.

moderate

sheets_update_values

Writes data to a specified range in a Google Sheet, overwriting existing content.

Modifies spreadsheet data, but doesn't alter structure.

moderate

sheets_batch_update_values

Writes data to multiple ranges in a Google Sheet.

Modifies spreadsheet data, but doesn't alter structure.

moderate

sheets_append_values

Appends rows of data to the end of a table in a Google Sheet.

Adds data to the spreadsheet, but doesn't alter structure unless configured to insert rows.

moderate

sheets_clear_values

Clears the contents of cells within a specified range in a Google Sheet.

Removes data from the spreadsheet, but doesn't alter structure.

high

sheets_insert_rows

Inserts new rows at a specific position in a Google Sheet.

Modifies the structure of the spreadsheet by adding rows.

high

sheets_insert_sheet

Adds a new sheet to a Google Sheets spreadsheet.

Modifies the structure of the spreadsheet by adding a new sheet.

critical

sheets_delete_sheet

Removes a sheet from a Google Sheets spreadsheet.

Destructive operation; permanently removes a sheet and its data.

moderate

sheets_duplicate_sheet

Creates a copy of an existing sheet within a Google Sheets spreadsheet.

Adds a new sheet based on an existing one.

moderate

sheets_copy_to

Copies a sheet to another spreadsheet.

Copies data to another spreadsheet.

high

sheets_update_sheet_properties

Updates the properties of a sheet, such as its name or hidden state.

Modifies sheet settings.

critical

sheets_batch_delete_sheets

Deletes multiple sheets from a Google Sheets spreadsheet in a single batch operation.

Destructive operation; permanently removes multiple sheets and their data.

moderate

sheets_batch_format_cells

Formats multiple cell ranges at once.

Modifies the appearance of cells, but not the data itself.

moderate

sheets_format_cells

Formats cells (colors, fonts, alignment, number formats).

Modifies the appearance of cells, but not the data itself.

moderate

sheets_update_borders

Adds or modifies cell borders.

Modifies the appearance of cells, but not the data itself.

moderate

sheets_merge_cells

Merges cells together.

Modifies the structure of the spreadsheet by merging cells.

moderate

sheets_unmerge_cells

Unmerges previously merged cells.

Modifies the structure of the spreadsheet by unmerging cells.

moderate

sheets_add_conditional_formatting

Adds conditional formatting rules to cells.

Modifies the appearance of cells based on conditions.

moderate

sheets_create_chart

Creates various types of charts within a Google Sheet.

Adds a chart to the spreadsheet.

moderate

sheets_update_chart

Modifies existing charts within a Google Sheet.

Modifies an existing chart.

moderate

sheets_delete_chart

Removes charts from a Google Sheet.

Removes a chart from the spreadsheet.

Safety Assessment

This server offers a balance of functionality and risk. It is safe when used with properly configured service accounts and limited permissions. It becomes risky if the service account has excessive permissions or if the spreadsheet is shared inappropriately.

Supports multiple authentication methods, including JSON string and private key.
Granular control over spreadsheet permissions via Google Sheets API.
No arbitrary code execution; limited to Google Sheets API operations.
Well-defined toolset limits scope of actions.

Requires Google Cloud project and service account setup, potentially complex.
Incorrectly configured permissions can lead to data breaches or unintended modifications.
Writing and deleting data within spreadsheets poses a risk if not carefully managed.
Reliance on external Google Sheets API introduces a dependency and potential point of failure.