MCP Gsheets

{
  "mcpServers": {
    "mcp-gsheets": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-gsheets"
      ],
      "env": {
        "GOOGLE_PROJECT_ID": "your-value",
        "GOOGLE_APPLICATION_CREDENTIALS": "your-value",
        "GOOGLE_SERVICE_ACCOUNT_KEY": "your-value",
        "GOOGLE_PRIVATE_KEY": "your-value"
      }
    }
  }
}

claude mcp add --env GOOGLE_PROJECT_ID=your-value --env GOOGLE_APPLICATION_CREDENTIALS=your-value --env GOOGLE_SERVICE_ACCOUNT_KEY=your-value --env GOOGLE_PRIVATE_KEY=your-value --transport stdio mcp-gsheets -- npx -y mcp-gsheets

{
  "mcpServers": {
    "mcp-gsheets": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "mcp-gsheets"
      ],
      "env": {
        "GOOGLE_PROJECT_ID": "your-value",
        "GOOGLE_APPLICATION_CREDENTIALS": "your-value",
        "GOOGLE_SERVICE_ACCOUNT_KEY": "your-value",
        "GOOGLE_PRIVATE_KEY": "your-value"
      }
    }
  }
}

{
  "inputs": [
    {
      "type": "promptString",
      "id": "google_application_credentials",
      "description": "GOOGLE_APPLICATION_CREDENTIALS",
      "password": true
    },
    {
      "type": "promptString",
      "id": "google_service_account_key",
      "description": "GOOGLE_SERVICE_ACCOUNT_KEY",
      "password": true
    },
    {
      "type": "promptString",
      "id": "google_private_key",
      "description": "GOOGLE_PRIVATE_KEY",
      "password": true
    }
  ],
  "servers": {
    "mcp-gsheets": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "mcp-gsheets"
      ],
      "env": {
        "GOOGLE_PROJECT_ID": "your-value",
        "GOOGLE_APPLICATION_CREDENTIALS": "${input:google_application_credentials}",
        "GOOGLE_SERVICE_ACCOUNT_KEY": "${input:google_service_account_key}",
        "GOOGLE_PRIVATE_KEY": "${input:google_private_key}"
      }
    }
  }
}

Config formats checked against the official docs on Oct 7, 2026: modelcontextprotocol.io (opens in a new tab), code.claude.com (opens in a new tab), cursor.com (opens in a new tab), code.visualstudio.com (opens in a new tab).

• sheets_get_values

  Read cell values from a single range

• sheets_batch_get_values

  Read cell values from multiple ranges in one request

• sheets_get_metadata

  Get spreadsheet metadata: title, locale, sheets list with IDs, row/column counts

• sheets_check_access

  Verify that the service account can access a spreadsheet

• sheets_update_values

  Write values to a single range (overwrites existing content)

• sheets_batch_update_values

  Write values to multiple ranges in one request

• sheets_append_values

  Append rows after the last row of an existing table. Default insertDataOption is OVERWRITE — set INSERTROWS to push…

• sheets_clear_values

  Clear all values in a range (preserves formatting)

• sheets_insert_rows

  Insert blank or pre-filled rows at a specific position

• sheets_delete_columns

  Delete one or more columns using a full-column A1 range

• sheets_delete_rows

  Delete one or more rows using a full-row A1 range

• sheets_insert_link

  Insert a hyperlink formula into a cell

• sheets_insert_date

  Insert a date/datetime value formatted correctly into a cell

• sheets_create_spreadsheet

  Create a new Google Sheets file

• sheets_insert_sheet

  Add a new sheet tab to an existing spreadsheet

• sheets_delete_sheet

  Remove a sheet tab by its numeric sheet ID

• sheets_duplicate_sheet

  Copy a sheet within the same spreadsheet

• sheets_copy_to

  Copy a sheet to a different spreadsheet

• sheets_update_sheet_properties

  Rename a sheet, change tab colour, toggle grid lines, etc.

• sheets_batch_delete_sheets

  Delete multiple sheet tabs in one request

• sheets_format_cells

  Apply background colour, font style, alignment and number format to a range

• sheets_batch_format_cells

  Apply different formats to multiple ranges in one request

• sheets_update_borders

  Set or remove borders on a range (style, width, colour per side)

• sheets_merge_cells

  Merge a range of cells

• sheets_unmerge_cells

  Unmerge previously merged cells in a range

• sheets_add_conditional_formatting

  Add a conditional formatting rule (gradient or boolean) to a range

• sheets_add_table

  Create a native Google Sheets table with typed columns and optional dropdown values

• sheets_update_table

  Update an existing native Google Sheets table by table ID using an explicit field mask

• sheets_delete_table

  Delete a native Google Sheets table by table ID

• sheets_get_tables

  Read native tables for a spreadsheet or a specific sheet

• sheets_create_chart

  Create a bar, line, pie, column or other chart on a sheet

• sheets_update_chart

  Modify an existing chart's spec or position

• sheets_delete_chart

  Remove a chart from a spreadsheet

• sheets_get_merged_cells

  Return all merged cell ranges for a sheet, with A1 notation and raw GridRange coordinates

• sheets_get_sheet_dimensions

  Return column widths, row heights, frozen column/row counts, and hidden flags for every column and row

• sheets_get_sheet_formatting

  Read raw cell formatting (background colour, font, borders, alignment, number format) for a range without returning…

• sheets_get_conditional_formatting

  Read all conditional formatting rules and banded (alternating-colour) ranges defined on a sheet

• sheets_get_sheet_structure

  Lightweight structural metadata only — no per-cell data. Returns dimensions, frozen rows/cols, tab colour, column…

• sheets_get_formatting_compact

  Read cell formatting for a range and return it as compact A1Range→format pairs (run-length encoded).

• sheets_get_full_sheet_snapshot

  Master one-shot tool — returns all structural and formatting metadata (merges, dimensions, conditional formatting, and…

A Model Context Protocol (MCP) server for Google Sheets API integration. Enables reading, writing, and managing Google Sheets documents directly from your MCP client (e.g., Claude Code, Claude Desktop, Cursor, etc.).

• automation
• google-sheets-api
• mcp
• nodejs
• typescript