Google Sheets MCP Server

MCP server for Google Sheets. Lets AI agents read and write cell ranges, create and update spreadsheets and tabs, append rows, and apply formatting via the Sheets API with OAuth. Useful for lightweight data entry, reporting, dashboards, and automating spreadsheet-driven workflows.

{
  "mcpServers": {
    "google-sheets": {
      "command": "uvx",
      "args": [
        "mcp-google-sheets"
      ],
      "env": {
        "GOOGLE_APPLICATION_CREDENTIALS": "<YOUR_GOOGLE_APPLICATION_CREDENTIALS>"
      }
    }
  }
}

{
  "type": "object",
  "required": [
    "spreadsheet_id",
    "range"
  ],
  "properties": {
    "range": {
      "type": "string",
      "description": "A1 notation range (e.g., Sheet1!A1:C10)"
    },
    "spreadsheet_id": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}

{
  "type": "object",
  "required": [
    "spreadsheet_id",
    "range",
    "values"
  ],
  "properties": {
    "range": {
      "type": "string",
      "description": "A1 notation range to write"
    },
    "values": {
      "type": "array",
      "items": {
        "type": "array",
        "items": {}
      },
      "description": "2D array of cell values"
    },
    "spreadsheet_id": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}