Skip to main content
Glama

Google Sheets MCP

A local MCP server for creating, reading, and updating Google Sheets.

Tools

  • sheets_create_spreadsheet - create a new Google spreadsheet

  • sheets_get_values - read a range from a sheet

  • sheets_update_values - overwrite a range

  • sheets_append_values - append rows

  • sheets_clear_values - clear a range

  • sheets_add_sheet - add a new tab

  • sheets_paste_markdown_report - paste a markdown report as one line per row

Related MCP server: google-sheets-mcp

Setup

  1. Enable the Google Sheets API for the Google Cloud project.

  2. Enable the Google Drive API if you want to create new spreadsheets.

  3. Fill .env with your OAuth client values.

  4. Generate a Sheets-scoped refresh token:

npm run auth

Open the printed Google URL, approve access, then copy the printed SHEETS_REFRESH_TOKEN into .env.

  1. Install and build:

npm install
npm run build

Codex config

[mcp_servers.google-sheets]
command = "node"
args = ["/Users/sandeshsonabakhilari/Desktop/my-mcp/google-sheets-mcp/dist/index.js"]

The MCP reads credentials from /Users/sandeshsonabakhilari/Desktop/my-mcp/google-sheets-mcp/.env.

Example

Create a spreadsheet:

{
  "title": "Gmail Reports",
  "sheetTitle": "Read Mail Priority"
}

Paste a report:

{
  "spreadsheetId": "...",
  "range": "Read Mail Priority!A1",
  "markdown": "# Report...",
  "clearFirst": true
}

Available Tools

7 tools
sheets_add_sheetC

Add a new tab/sheet to a spreadsheet.

Inputs: title (required), spreadsheetId (required).

sheets_append_valuesC

Append rows to a Google Sheet range.

Inputs: range (required), values (required), spreadsheetId (required), valueInputOption.

sheets_clear_valuesC

Clear values from a Google Sheet range.

Inputs: range (required), spreadsheetId (required).

sheets_create_spreadsheetB

Create a new Google spreadsheet.

Inputs: title (required), sheetTitle.

sheets_get_valuesC

Read values from a Google Sheet range.

Inputs: range (required), spreadsheetId (required).

sheets_paste_markdown_reportB

Paste a markdown report into a sheet as one line per row.

Inputs: range (required), markdown (required), spreadsheetId (required), clearFirst.

sheets_update_valuesC

Overwrite values in a Google Sheet range.

Inputs: range (required), values (required), spreadsheetId (required), valueInputOption.

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    TDQS

    B3.3/5.0

    Scored across 7 tools

    Disambiguation5/5

    Each tool targets a distinct action (add sheet, append, clear, create, get, paste markdown, update) with no overlap in purpose, ensuring an agent can easily distinguish them.

    Naming Consistency5/5

    All tools follow a consistent 'sheets_verb_noun' pattern (e.g., sheets_add_sheet, sheets_get_values), with only 'sheets_paste_markdown_report' slightly deviating in verb form but still predictable.

    Tool Count5/5

    Seven tools is well-scoped for a Google Sheets server, covering creation, reading, writing, appending, clearing, tab management, and a specialized markdown paste function without being overwhelming.

    Completeness4/5

    The tool set covers core operations (create, read, update, append, clear) and adds tab management and markdown support, though missing explicit delete operations (e.g., delete sheet or row) which are minor gaps.

    Related MCP Connectors

    Related MCP Servers