1. Conduid
  2. Developer Tools
  3. Google Sheets MCP
MCP server · Developer Tools

Google Sheets MCP

by · github.com/mkummer225/google-sheets-mcp

Google Sheets MCP Server 📊🤖

Unclaimed MIT last commit a year ago devtools
InstallView source
52Fair

Scored 6 days ago · breakdown

About Google Sheets MCP

Google Sheets MCP is an MCP server published by mkummer225 in the Developer Tools category: google Sheets MCP Server 📊🤖.

The repository has 137 stars and 40 forks, with the last commit a year ago. Six months or more without a commit doesn't mean the server is broken, but check the open issues before depending on it in production.

Install

From source
git clone https://github.com/mkummer225/google-sheets-mcp

This server has no ConduID identity, so agent calls to it are not receipted. Pin the version you install and review the source before granting it credentials.

Ask AI

✦

Ask AI about Google Sheets MCP

Powered by Claude · Grounded in docs

I know everything about Google Sheets MCP. Ask me about installation, configuration, usage, or troubleshooting.

Security checks

Static checks derived from the repository 6 days ago. Heuristics on the source, not an audit.

  • ✓README presentThe repository ships documentation.
  • ✓License declaredUsable under a stated license.
  • !Tests presentNo tests found. Behaviour changes may go unnoticed between versions.
  • ✓Dependencies pinnedA lockfile pins dependency versions.
  • ✓No dynamic code executionSource scan found no eval, dynamic Function, or shell execution.

1 check has not been run yet.

README

Google Sheets MCP

A Model Context Protocol (MCP) connector for Google Sheets that allows AI agents to interact with spreadsheets directly.

Demo

https://github.com/user-attachments/assets/cc4729d9-4e6e-437b-848b-6da9a09418c3

Setup

  1. Clone this repository:
git clone https://github.com/mkummer225/google-sheets-mcp
cd google-sheets-mcp

  1. Install dependencies: npm install

  2. Build: npm run build

  3. Create OAuth credentials in Google Cloud Platform:

    • Create a new project in Google Cloud Console
    • Enable the Google Sheets API
    • Configure the OAuth consent screen
    • Create OAuth client ID credentials (Desktop application) with an appropriate redirect URI (ex: http://localhost:3000/oauth2callback)
    • Download the credentials and save as gcp-oauth.keys.json in the dist subdirectory

  4. Start the MCP server (you'll automatically be prompted to authenticate/re-authenticate your Google account when necessary): npm run start

Usage

Sample config:

{
    "mcpServers": {
    "google-sheets-mcp": {
      "command": "node",
      "args": [
        "/{path_to_dir}/google-sheets-mcp/dist/index.js"
      ]
    }
  }
}

Then you should be able to simply specify your spreadsheetId or ask your agent to create a new one for you.

Available Actions

Action Description
refresh_auth Re-authenticate your Google Account when credentials expire
list_sheets List all sheets/tabs in a Google Spreadsheet
create_sheet Create a new sheet/tab in a Google Spreadsheet
create_spreadsheet Create a new Google Spreadsheet
read_all_from_sheet Read all data from a specified sheet
read_headings Read the column headings from a sheet
read_rows Read specific rows from a sheet
read_columns Read specific columns from a sheet
edit_cell Edit a single cell in a sheet
edit_row Edit an entire row in a sheet
edit_column Edit an entire column in a sheet
insert_row Insert a new row at specified position
insert_column Insert a new column at specified position
rename_sheet Rename a sheet/tab in a spreadsheet
rename_doc Rename a Google Spreadsheet

License

MIT

README fetched from the repository 6 days ago. The original is authoritative.

Questions

About Google Sheets MCP

How do I install Google Sheets MCP?

No package has been published for this server, so install it from source: clone the repository and follow its README.

Is Google Sheets MCP safe to use with an AI agent?

Its trust score is 52 out of 100 (fair). It passes 4 of the 5 static security checks run so far; the failures are listed above. It has no ConduID identity yet, so agent calls to it are not receipted.

Is Google Sheets MCP still maintained?

The last commit was a year ago and 7 open issues. That's long enough that you should check whether the maintainer is responding to issues before depending on it.