Google Sheets API MCP Server

@mattcoatsworth

Repository

Basic information

About Google Sheets API MCP Server

No overview available yet

#google-sheets #api #mcp-server

Google Sheets API MCP Server config

No standard config provided

This server doesn't expose a parseable MCP config block in its README. See the repository for install instructions.

Repository

Google Sheets API MCP Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

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

Overview

What is Google Sheets API MCP Server?

A comprehensive Model Context Protocol (MCP) server for interacting with the Google Sheets API. It provides tools and resources for managing spreadsheets, sheets, values, and developer metadata, intended for developers building AI or automation workflows that need to read and write Google Sheets data.

How to use Google Sheets API MCP Server?

Clone the repository, install dependencies with npm install, and create a .env file with your Google OAuth 2.0 credentials (CLIENT_ID, CLIENT_SECRET, REDIRECT_URI, REFRESH_TOKEN). Run the server with npm start, or use npm run dev for development mode and npm run inspect to test with the MCP Inspector.

Key features of Google Sheets API MCP Server

Create, read, update, and delete spreadsheets
Manage sheets within spreadsheets
Read, write, append, and clear cell values
Work with developer metadata
Access spreadsheet data through MCP resources

Use cases of Google Sheets API MCP Server

Automating spreadsheet creation and population
Reading and updating cell ranges in existing sheets
Managing sheet properties and metadata programmatically
Copying sheets between different spreadsheets
Batch reading or writing values across multiple ranges

Frequently asked questions

What are the prerequisites to use this server?

Node.js 16 or higher, a Google Cloud Platform project with the Google Sheets API enabled, and OAuth 2.0 credentials (client ID, client secret, refresh token).

How does authentication work?

The server uses OAuth 2.0. You must provide a CLIENT_ID, CLIENT_SECRET, REDIRECT_URI, and a REFRESH_TOKEN in the `.env` file.

What tools are available?

Tools for spreadsheet management (create, get, batch update), sheet management (copy, add, delete, update properties), values management (get, update, append, clear, batch get/update), and developer metadata (get, create, update, delete).

What resources does the server expose?

Resources follow the pattern `sheets://spreadsheet/{spreadsheetId}`, `sheets://spreadsheet/{spreadsheetId}/sheet/{sheetName}`, `sheets://spreadsheet/{spreadsheetId}/values/{range}`, and `sheets://spreadsheet/{spreadsheetId}/metadata`.

What license is this server distributed under?

MIT.

Comments

More Developer Tools MCP servers

Perfex CRM

themesic

Turn Perfex CRM into an AI-ready workspace. This MCP server exposes your full REST API to Claude, ChatGPT and any AI agent, so leads, invoices and tasks are one prompt away.

offprompt

MCP server that lets Claude Code, Cursor or Codex ask you for API keys on a local page and write them to .env. The agent only ever sees key names.

Termany

thinkany-ai

Agent-Native Terminal

174

FARPY

mangomunchr

Verified distributed compute for humans, applications, and agents. Submit Blender, Octane, and video workloads, route them across qualified GPUs, track asynchronous execution, download finished artifacts, and verify FARP

Yocoolab

MCP server for AI Agents — exposes Yocoolab feedback threads and design selections as tools