MCP Server for Google Spreadsheets

What is MCP Server for Google Spreadsheets?

MCP Server for Google Spreadsheets is a Model Context Protocol (MCP) server that integrates with Google Spreadsheets, enabling AI assistants like Claude to retrieve and modify spreadsheet data.

How to use MCP Server for Google Spreadsheets?

Install Node.js v18+, clone the repository, install dependencies with pnpm, then build and run the server. Configure authentication via Google Cloud CLI and add the server to Claude for Desktop’s configuration file (claude_desktop_config.json) with your project ID and credentials.

Key features of MCP Server for Google Spreadsheets

• Retrieve all sheets information from a spreadsheet
• Get values from a specific sheet with optional range
• Update cell values in a defined range
• Batch update multiple ranges across sheets
• Add a new sheet with customizable dimensions

Use cases of MCP Server for Google Spreadsheets

• Ask Claude to list sheets in a Google Spreadsheet
• Retrieve data from a specific sheet by name
• Update budget figures in a range of cells
• Add a new planning sheet to an existing spreadsheet
• Perform bulk updates across multiple sheets at once

FAQ from MCP Server for Google Spreadsheets

What authentication does the server use?

It uses Google Cloud Application Default Credentials. You need to run gcloud auth application-default login with the required scopes and ensure the Sheets API is enabled in your Google Cloud project.

What are the runtime requirements?

Node.js v18 or higher, a Google Cloud project with the Sheets API enabled, and Claude Desktop for integration.

How do I integrate with Claude for Desktop?

Add a configuration entry in claude_desktop_config.json specifying the command (node), the path to the built server, and environment variables for your Google project ID and credentials file.

Where does my data live?

Data stays in your Google Spreadsheets on Google’s servers. The MCP server only accesses it via the Google Sheets API based on the credentials and URLs you provide.

What transport does the server use?

The server communicates via standard input/output (stdio) for MCP, as configured in Claude for Desktop.