Google Sheets MCP

com.renzojohnsonPublished by renzojohnson.comv26.11.14Updated Nov 13, 2026

Google Sheets MCP server: read ranges, append rows, update cells and add tabs.

VerifiedSTDIODesktop onlyProductivity & WorkflowData & Analytics

Overview

AI-generated overview

Local MCP server that lets an assistant read ranges, append rows, update cells and add tabs in Google Sheets.

What you can do
  • Read cell ranges from Google Sheets spreadsheets
  • Append new rows to existing sheets
  • Update values in existing cells
  • Add new tabs to a spreadsheet
When to use it
Useful when you keep data, trackers or reports in Google Sheets and want an assistant to pull values out or write rows and cell updates back without manual copy-paste.
Requirements
Runs as a local stdio process from an npm package on a desktop machine. Needs Google credentials: a service account or authorized_user JSON file via GOOGLE_APPLICATION_CREDENTIALS, or gcloud Application Default Credentials, or OAuth values in GOOGLE_OAUTH_CLIENT_ID, GOOGLE_OAUTH_CLIENT_SECRET and GOOGLE_OAUTH_REFRESH_TOKEN. Network access to Google APIs.
Before you install
Requires Google OAuth secrets (GOOGLE_OAUTH_CLIENT_SECRET, GOOGLE_OAUTH_REFRESH_TOKEN) or a service account key file, which grant access to your spreadsheets; store them carefully. The server can write to sheets by appending rows, updating cells and adding tabs, so mistakes can alter or overwrite existing data. Grant access only to the spreadsheets it needs.

Installation

In SourceWeft

  1. Open Google Sheets MCP in the dashboard and add it to a workspace.
  2. Enable the server for the chats that should use its tools.

Desktop only via STDIO. STDIO servers start a local process, so they need the SourceWeft desktop host.

Tools

0
SourceWeft has not started this package in its sandbox yet, so its tools are not known.

Version history

1
  1. v26.11.14LatestNov 13, 2026

Score

25% of the applicable checks met

How complete this listing is, computed from the registry entry, the endpoint and public sources. Not a rating of the server and not a statement that it is safe or working today: reachability is a dated check, and no installs or reviews go into the score.

  • Reached in the last 30 days25 pts

    Keep the endpoint answering the MCP handshake; SourceWeft probes it every 30 days.

  • Auth declared10 pts

    Declare the credential headers in the registry entry, or keep the endpoint answering the probe so its auth can be classified.

  • Tools listed15 pts

    Answer tools/list without a credential, or ship a package that starts in a sandbox without one.

  • DescriptionRequired15 pts
  • Logo10 pts
  • Documentation15 pts

    Declare a GitHub repository with a README, or serve resource_documentation in the OAuth protected-resource metadata.

  • License10 pts

    Declare a license in the repository or the registry entry.