Sheeter

You can connect Claude Desktop to Google Sheets through the Sheeter MCP server, enabling you to create, read, write, and manage spreadsheets directly from conversations. This MCP server provides secure, programmatic access to Sheets via the Sheeter API, streamlining data work in your workflows.

How to use

You will interact with Claude Desktop to perform operations on your Google Sheets. Use natural language prompts to create spreadsheets, read data, write or append cells, clear ranges, and retrieve metadata. Common patterns include asking Claude to create a new spreadsheet for a budget, read data from a sales sheet, add expenses, or generate a data-driven summary.

How to install

Prerequisites you need on your machine before starting:

• Node.js and npm installed on your system.

Follow these steps to run the MCP server locally or connect to an existing instance.

How to install

{
  "mcpServers": {
    "sheeter": {
      "command": "npx",
      "args": ["-y", "@modelcontextprotocol/server-web"],
      "env": {
        "WEB_BASE_URL": "https://sheeter-2.onrender.com",
        "WEB_API_KEY": "your_api_key_here"
      }
    }
  }
}

Additional sections

Configuration notes: The MCP server is configured to run as a stdio client. Use the following command structure to start the server from your MCP client configuration. The environment must include the base URL of the Sheeter API and your API key.

Security reminder: Keep your API key confidential. Do not hard-code keys in shared configurations. Use environment-based secrets where supported.

Notes on available actions

The server exposes a range of spreadsheet operations that you can invoke from Claude: creating spreadsheets, reading data, writing data to specific ranges, appending rows, clearing ranges, batch reading and updating multiple ranges, retrieving sheet metadata, deleting rows, and performing advanced batch updates.

Available tools

create_spreadsheet

Create new Google Spreadsheets from Claude with optional initial data and metadata.

read_sheet

Read data from one or more ranges within a spreadsheet to analyze or display.

write_sheet

Update specific ranges in a spreadsheet with new values.

append_to_sheet

Append data to the end of a sheet, adding new rows or entries.

clear_range

Clear data from specified ranges without deleting the sheet.

batch_get_ranges

Read multiple ranges in a single operation for efficiency.

batch_update_ranges

Update multiple ranges in a single operation to streamline changes.

get_sheet_metadata

Retrieve metadata about a spreadsheet, such as sheet names and properties.

delete_rows

Remove specific rows from a sheet.

batch_update_spreadsheet

Perform advanced batch operations to update multiple aspects of a spreadsheet at once.