mcpField
S
sheetport

sheetport

Local
github.com/CloudCorpRecordsData & Analytics0Updated 2w ago
Repository

About sheetport

sheetport is an MCP server for managing Google Sheets spreadsheets, cell values, and basic sheets through Google Sheets API v4. It provides a focused set of operations for clients using a Google OAuth access token.

Key features

  1. 01Read and create spreadsheets
  2. 02Read, update, append, and clear values
  3. 03Batch update cell values
  4. 04Add, copy, and rename sheets

Use cases

  1. 01Inspect spreadsheet data from an MCP client
  2. 02Update or append cell ranges
  3. 03Create and organize basic sheets

MCP support

Exposes spreadsheet and cell-value operations as tools to MCP clients. Run it as a stdio MCP server and provide a Google OAuth access token.

Configuration

Local server config is the same for every client. Copy it into your client’s MCP config file.

mcp.json · Universal config
{
  "mcpServers": {
    "cloudcorprecords-sheetport": {
      "command": "npx",
      "args": [
        "-y",
        "@reneturcios/sheetport"
      ]
    }
  }
}
Run commandnpx -y @reneturcios/sheetport

Local servers need a runtime on your machine (e.g. Node.js 18+). Config file locations differ by client; see your client’s docs.

Packages
npm@reneturcios/sheetport0.1.0
ocighcr.io/cloudcorprecords/sheetport:0.1.0

Tools

10

Saved tool list · updated 1w ago

ParameterTypeRequiredDescription
spreadsheet_idstringYesThe unique identifier of the spreadsheet to retrieve.

Details

From the project README

sheetport

Google Sheets spreadsheets and cell values as MCP tools, talking to the Google Sheets API v4. sheetport is a clean-room rebuild of the core subset of the Google Sheets MCP surface, under a new name: spreadsheet and value operations plus basic sheet management, fresh code, no copied branding.

Tools (core subset, 10)

get_spreadsheet, create_spreadsheet, get_values, update_values, append_values, clear_values, batch_update_values, add_sheet, copy_sheet, rename_sheet.

Formatting, charts, pivot tables, conditional formatting, developer metadata, protected ranges, named ranges, general spreadsheet batchUpdate passthrough and Drive file operations are not in this subset.

Setup

Set a Google OAuth access token:

export GOOGLE_ACCESS_TOKEN=ya29....

Optionally override the API base with SHEETS_API_URL (default https://sheets.googleapis.com/v4). Without the token, every tool call fails with an error naming the missing variable.

CLI

npx @reneturcios/sheetport get_values '{"spreadsheet_id":"abc","range":"Sheet1!A1:B2"}'
npx @reneturcios/sheetport mcp        # stdio MCP server

Each tool name is a subcommand taking one JSON object argument.

MCP client config

{
  "mcpServers": {
    "sheetport": {
      "command": "npx",
      "args": ["-y", "@reneturcios/sheetport", "mcp"],
      "env": { "GOOGLE_ACCESS_TOKEN": "ya29...." }
    }
  }
}

Docker

docker run -i -e GOOGLE_ACCESS_TOKEN ghcr.io/cloudcorprecords/sheetport

Development

npm install
npm run build
npm test

License

MIT

Comments

Markdown supported

New to MCP?

From what the protocol is to installing your first server, these answers cover most first questions.

An open protocol that defines how AI applications connect to external tools and data in a uniform way. Clients talk to the model; MCP servers provide tools, resources and prompt templates. They exchange standard messages, so one server can be reused by many clients.