Google Sheets

You can manage Google Sheets programmatically with this MCP Server, enabling you to create, read, write, append, and manage spreadsheets through a unified, scriptable interface. It handles authentication, efficient batch updates, and flexible range handling so you can automate data workflows in your applications.

How to use

You interact with the Google Sheets MCP Server through an MCP client. Start the local server and then issue guided tool calls to perform common tasks such as creating spreadsheets, reading data from ranges, writing data to ranges, appending new rows, clearing data, and fetching spreadsheet metadata. Use the available tools to orchestrate multi-step workflows: create a spreadsheet, populate it with initial data, and then update or read data as your project progresses. For large operations, prefer batch-update calls to minimize the number of requests and improve efficiency.

How to install

Prerequisites: you need the MCP runtime command line tool installed on your system. The recommended runtime is uv. You will also perform OAuth authentication during the first run.

Step 1. Install and set up the server directory.

cd sheets-mcp-server
uv sync

Step 2. Run the server in standalone mode to begin using the Google Sheets MCP server.

uv run sheets \
  --creds-file-path /path/to/your/credentials.json \
  --token-path /path/to/your/tokens.json

Step 3. Authenticate when prompted. The server opens a browser for OAuth authentication on first run. Access tokens are saved to the specified token path for subsequent uses.

Optional: integrate with Claude Desktop by configuring your client to start the server with the appropriate directory and credentials paths.

Configuration and usage details

The server exposes a set of core tools that you can call from your MCP client. Use these commands to perform common Google Sheets operations.

Tools and endpoints

• create-spreadsheet: create a new spreadsheet with a given title and optional sheet names.

• read-range: read data from a specified range in a spreadsheet.

• write-range: overwrite data in a specified range.

• append-rows: append rows to the end of a range.

• clear-range: clear all data from a specified range.

• get-spreadsheet-info: fetch metadata about a spreadsheet.

• batch-update: perform multiple range updates in a single request.

Security & credentials

The server requires OAuth authentication with the Google Sheets API. You will grant access to your spreadsheets during the initial authentication flow. Ensure credentials and tokens are stored securely and that access is restricted to authorized users.

Troubleshooting

If you encounter authentication errors, verify the credentials file path and ensure the OAuth consent screen is configured correctly. For range or sheet name issues, double-check A1 notations and sheet names, and confirm you are addressing the correct spreadsheet ID. If you hit quota limits, consider batching operations and monitoring usage in the Google Cloud Console.

Notes

This MCP server supports multiple range formats and is designed to handle both small and large data operations efficiently. You can perform batch updates to minimize network requests and reduce latency.

Available tools

create-spreadsheet

Creates a new Google Sheets spreadsheet with a given title and optional sheet names.

read-range

Reads data from a specific range in a spreadsheet.

write-range

Writes (overwrites) data to a specific range.

append-rows

Appends rows to the end of a range.

clear-range

Clears all data from a specified range.

get-spreadsheet-info

Fetches metadata about a spreadsheet, including title and sheet information.

batch-update

Performs multiple range updates in a single request.