MCP Servers / productivity / Google Sheets

Google Sheets

JSON →

noneproductivity

A server for comprehensive Google Sheets integration, requiring Google OAuth credentials.

github ↗

Install

How to run this server

[ { "cmd": "npx @modelcontextprotocol/inspector", "imports": [] } ]

server path: google-sheets-2

Tools

What this server exposes

create-spreadsheet

Creates a new Google Sheets spreadsheet. Input: title (required), sheet_names (optional array). Returns: Spreadsheet ID, URL, and created sheet names.

read-range

Reads data from a specific range. Input: spreadsheet_id, range_name (e.g., 'Sheet1!A1:C10'). Returns: 2D array of cell values.

write-range

Writes data to a specific range (overwrites existing data). Input: spreadsheet_id, range_name, values (2D array). Returns: Update statistics.

append-rows

Appends rows to the end of a range. Input: spreadsheet_id, range_name, values (2D array). Returns: Update statistics.

clear-range

Clears all data from a specified range. Input: spreadsheet_id, range_name. Returns: Confirmation of cleared range.

get-spreadsheet-info

Gets metadata about a spreadsheet. Input: spreadsheet_id. Returns: Title, URL, sheet information, dimensions.

batch-update

Performs multiple range updates in a single request. Input: spreadsheet_id, updates (array of range/values pairs). Returns: Total update statistics.

Configuration

Environment & auth

authnone

Resources

githubhttps://github.com/Prajapdh/sheets-mcp-server ↗