Model Context Protocol moderate risk

Google Sheets

This MCP server bridges AI clients to Google Sheets, enabling read/write operations, spreadsheet management, and data manipulation via natural language commands.

Connections & Capabilities

Connects To

GitHubDockerKubernetesFilesystemGCPGoogle SheetsGoogle Drive

Capabilities

readwrite

Quickstart

Install

uvx mcp-google-sheets@latest

Config

{
  "mcpServers": {
    "google-sheets": {
      "command": "uvx",
      "args": ["mcp-google-sheets@latest"],
      "env": {
        "SERVICE_ACCOUNT_PATH": "/full/path/to/your/service-account-key.json",
        "DRIVE_FOLDER_ID": "your_shared_folder_id_here"
      }
    }
  }
}

Exposed MCP Tools (19)

safe

list_spreadsheets

Lists spreadsheets within a specified Google Drive folder.

Read-only operation, no data modification.

moderate

create_spreadsheet

Creates a new spreadsheet in a specified Google Drive folder.

Creates new data, but doesn't modify existing data.

safe

get_sheet_data

Retrieves data from a specified range within a Google Sheet.

Read-only operation, no data modification.

safe

get_sheet_formulas

Retrieves formulas from a specified range within a Google Sheet.

Read-only operation, no data modification.

moderate

update_cells

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

Modifies existing data, but within a defined range.

moderate

batch_update_cells

Updates multiple ranges in a Google Sheet in a single API call.

Modifies existing data, but within defined ranges.

moderate

add_rows

Adds empty rows to a Google Sheet at a specified index.

Modifies the structure of the sheet, but doesn't delete data.

safe

list_sheets

Lists all sheet/tab names within a spreadsheet.

Read-only operation, no data modification.

moderate

create_sheet

Adds a new sheet/tab to a spreadsheet.

Creates new data, but doesn't modify existing data.

safe

get_multiple_sheet_data

Fetches data from multiple ranges across different sheets in a spreadsheet.

Read-only operation, no data modification.

safe

get_multiple_spreadsheet_summary

Retrieves summaries from multiple spreadsheets.

Read-only operation, no data modification.

moderate

add_columns

Adds columns to a sheet.

Modifies the structure of the sheet, but doesn't delete data.

moderate

batch_update

Performs multiple updates to a spreadsheet in a single batch request.

Can modify spreadsheet structure and data.

moderate

copy_sheet

Copies a sheet within a spreadsheet or to another spreadsheet.

Creates a copy of a sheet, potentially duplicating data.

safe

find_in_spreadsheet

Finds a specific value within a spreadsheet.

Read-only operation, no data modification.

safe

list_folders

Lists folders in Google Drive.

Read-only operation, no data modification.

moderate

rename_sheet

Renames a sheet in a spreadsheet.

Modifies the name of a sheet.

safe

search_spreadsheets

Searches for spreadsheets in Google Drive.

Read-only operation, no data modification.

high

share_spreadsheet

Shares a spreadsheet with specified users or groups.

Modifies permissions, potentially exposing data to unauthorized users.

Safety Assessment

This server provides powerful spreadsheet interaction but requires careful configuration. It's safe for read-only operations and controlled write access with tool filtering. Risky when used without proper access controls or when blindly trusting AI-generated commands.

Supports Service Account authentication, limiting scope.
Tool filtering allows disabling risky operations.
No direct code execution capabilities.
Relies on Google's API security for data protection.

Write operations can modify or corrupt spreadsheet data.
Improperly configured permissions can expose sensitive data.
No built-in input validation or sanitization.
Over-reliance on AI for spreadsheet changes can lead to errors.