MCP Google Sheets Server

Name: MCP Google Sheets Server
Author: freema

@freema

Repository

About MCP Google Sheets Server

MCP server for Google Sheets - Read, write and manipulate spreadsheets through Claude Desktop

#nodejs #automation #typescript #mcp #google-sheets-api

Basic information

Config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "mcp-gsheets": {
      "command": "node",
      "args": [
        "/absolute/path/to/mcp-gsheets/dist/index.js"
      ],
      "env": {
        "GOOGLE_PROJECT_ID": "",
        "GOOGLE_APPLICATION_CREDENTIALS": ""
      }
    }
  }
}

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is MCP Google Sheets Server?

MCP Google Sheets Server is a Model Context Protocol (MCP) server that integrates the Google Sheets API directly into MCP clients such as Claude Desktop. It enables reading, writing, and managing Google Sheets documents programmatically. Designed for developers and users who need to control spreadsheets via natural language or automation in an MCP environment.

How to use MCP Google Sheets Server?

Requires Node.js 18+, a Google Cloud project with the Sheets API enabled, and a service account JSON key. Install via git clone, then run npm install and npm run build. Use the interactive setup script (npm run setup) or manually configure your MCP client (e.g., Claude Desktop) by adding the server configuration with absolute paths to the built script and environment variables for GOOGLE_PROJECT_ID and GOOGLE_APPLICATION_CREDENTIALS. After configuration, restart your MCP client.

Key features of MCP Google Sheets Server

Read cell values, ranges, and metadata from spreadsheets
Write, update, append, and clear cell data
Add, delete, duplicate, and copy sheets
Format cells with colors, fonts, alignment, and borders
Merge and unmerge cells; add conditional formatting rules

Use cases of MCP Google Sheets Server

Automatically populate a spreadsheet from chat prompts
Read and summarize spreadsheet data in natural language
Manage sheet structure (add/delete sheets) from an MCP client
Apply consistent formatting across multiple ranges
Check permissions before performing operations

FAQ from MCP Google Sheets Server

What are the prerequisites?

Node.js v18 or higher, a Google Cloud project with the Sheets API enabled, and a service account JSON key file.

How do I authenticate with Google Sheets?

Create a service account in Google Cloud Console, download its JSON key, and share your spreadsheet with the service account email (Editor permissions). Set the GOOGLE_APPLICATION_CREDENTIALS environment variable to the absolute path of that key.

How do I find a spreadsheet ID?

The spreadsheet ID is the long string in the sheet’s URL: https://docs.google.com/spreadsheets/d/[SPREADSHEET_ID]/edit.

What tools does MCP Google Sheets Server provide?

It offers tools for reading data (sheets_get_values, sheets_batch_get_values, sheets_get_metadata, sheets_check_access), writing data (sheets_update_values, sheets_batch_update_values, sheets_append_values, sheets_clear_values), sheet management (sheets_insert_sheet, sheets_delete_sheet, sheets_duplicate_sheet, sheets_copy_to, sheets_update_sheet_properties), and cell formatting (sheets_format_cells, sheets_update_borders, sheets_merge_cells, sheets_unmerge_cells, sheets_add_conditional_formatting).

How can I debug connection issues?

Ensure you are using the built version (dist/index.js), that the Node.js path in your MCP client config is correct, and check the client logs. You can also run npm run inspector to debug the MCP server.

Comments

More Other MCP servers

Reactive Resume

amruthpillai

A one-of-a-kind resume builder that keeps your privacy in mind. Completely secure, customizable, portable, open-source and free forever. Try it out today!

39.5K