Which integrations are available for this server?

Provides tools for reading, writing, formatting, and managing Google Sheets spreadsheets, including sheet management, data operations, and advanced features like charts and batch updates.

How do I use @node2flow/google-sheets-mcp?

1. Click on "Deploy Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@@node2flow/google-sheets-mcp Create a new spreadsheet called 'Project Plan' with columns Task, Owner, Status" That's it! The server will respond to your query, and you can continue using it as needed. Here is a step-by-step guide with screenshots.

@node2flow/google-sheets-mcp

npm version License: MIT

MCP server for Google Sheets — read, write, format, and manage spreadsheets through 23 tools via the Model Context Protocol.

Quick Start

Claude Desktop / Cursor

Add to your MCP config:

{
  "mcpServers": {
    "google-sheets": {
      "command": "npx",
      "args": ["-y", "@node2flow/google-sheets-mcp"],
      "env": {
        "GOOGLE_CLIENT_ID": "your-client-id",
        "GOOGLE_CLIENT_SECRET": "your-client-secret",
        "GOOGLE_REFRESH_TOKEN": "your-refresh-token"
      }
    }
  }
}

HTTP Mode

GOOGLE_CLIENT_ID=xxx GOOGLE_CLIENT_SECRET=xxx GOOGLE_REFRESH_TOKEN=xxx npx @node2flow/google-sheets-mcp --http

MCP endpoint: http://localhost:3000/mcp

Cloudflare Worker

Available at: https://google-sheets-mcp-community.node2flow.net/mcp

POST https://google-sheets-mcp-community.node2flow.net/mcp?GOOGLE_CLIENT_ID=xxx&GOOGLE_CLIENT_SECRET=xxx&GOOGLE_REFRESH_TOKEN=xxx

Related MCP server: gworkspace-mcp

Tools (23)

Spreadsheet (2)

Tool	Description
`gs_create_spreadsheet`	Create a new spreadsheet with title and optional sheets
`gs_get_spreadsheet`	Get metadata — sheet names, IDs, properties

Values (6)

Tool	Description
`gs_read_values`	Read cell values from an A1 range
`gs_batch_read`	Read multiple ranges at once
`gs_write_values`	Write values to a range (2D array)
`gs_append_values`	Append rows after existing data
`gs_clear_values`	Clear values in a range (keeps formatting)
`gs_batch_write`	Write to multiple ranges at once

Sheet Management (5)

Tool	Description
`gs_add_sheet`	Add a new sheet/tab
`gs_delete_sheet`	Delete a sheet/tab (irreversible)
`gs_rename_sheet`	Rename a sheet/tab
`gs_copy_sheet`	Copy sheet to another spreadsheet
`gs_duplicate_sheet`	Duplicate sheet within same spreadsheet

Formatting (4)

Tool	Description
`gs_format_cells`	Bold, italic, colors, font, alignment, number format
`gs_merge_cells`	Merge cells in a range
`gs_unmerge_cells`	Unmerge cells
`gs_auto_resize`	Auto-fit column widths or row heights

Data Operations (4)

Tool	Description
`gs_sort_range`	Sort range by column
`gs_find_replace`	Find and replace text (supports regex)
`gs_set_basic_filter`	Set or clear auto-filter on a sheet
`gs_add_protected_range`	Protect a range from editing

Advanced (2)

Tool	Description
`gs_add_chart`	Add a chart (bar, line, column, scatter, etc.)
`gs_batch_update`	Raw batchUpdate for any operation

A1 Notation

Ranges use A1 notation for the Values tools:

Sheet1!A1:C10    — specific range in Sheet1
Sheet1           — entire sheet
A:C              — columns A through C (first sheet)
Sheet1!A1:A      — column A, all rows
Sheet1!1:5       — rows 1 through 5

Index Notation

Formatting and batchUpdate tools use 0-based indices:

Row 1    → index 0      Column A → index 0
Row 2    → index 1      Column B → index 1
Row 10   → index 9      Column Z → index 25

Ranges are inclusive start, exclusive end:

startRowIndex: 0, endRowIndex: 5 = rows 1-5
startColumnIndex: 0, endColumnIndex: 3 = columns A-C

Configuration

Parameter	Required	Description
`GOOGLE_CLIENT_ID`	Yes	OAuth 2.0 Client ID from Google Cloud Console
`GOOGLE_CLIENT_SECRET`	Yes	OAuth 2.0 Client Secret
`GOOGLE_REFRESH_TOKEN`	Yes	Refresh token (obtained via OAuth consent flow)

Getting Your Credentials

Go to Google Cloud Console
Create a project → Enable Google Sheets API
Create OAuth 2.0 Client ID (Desktop app type)
Use the OAuth Playground or your app to get a refresh token with scope https://www.googleapis.com/auth/spreadsheets

OAuth Scopes

Scope	Access
`spreadsheets`	Full read/write access
`spreadsheets.readonly`	Read-only access

License

MIT License - see LICENSE

Links

This server cannot be deployed

One endpoint for every MCP toolRayrun runs every MCP server behind one URL and holds the credentials. Each call is decided per client, tool, and argument, then recorded.ray.runAd

Maintenance

ActivityInactive

ResponsivenessNo issues

Resources

Need Help?

Related Servers

Related MCP Connectors

ClawLinkOAuth
dev.claw-link
MCP server connecting AI agents to 100+ apps (Gmail, Slack, Notion, GitHub) via one-click OAuth.
App Automation Workplace & Productivity
24
LemonadoOAuth
io.github.lemonadolabs
MCP server for querying and analyzing data from ad platforms, analytics tools, and spreadsheets
Marketing Research & Data Databases
3
Google Ads + Meta Ads + GA4 MCPOAuth
io.github.irinabuht12-oss
Google Ads, Meta Ads & GA4 MCP server - 250+ tools for campaigns, creatives, audiences & reports.
Marketing Social Media
11,644
climbpast
io.github.archievi
Read and edit GA4, Search Console and Google Tag Manager from any MCP client. 29 tools.
Marketing Search Data Platforms
1

Related MCP Servers

Google Sheets API MCP Server
Workplace & Productivity App Automation
ag2-mcp-servers
F
license
Not graded
quality
D
maintenance
An MCP server that enables interaction with Google Sheets through natural language, allowing users to create, read, update, and manage spreadsheet data via the Google Sheets API v4.
Updated a year ago (2025-07-12 23:28 UTC)
-
gworkspace-mcp
Workplace & Productivity App Automation Developer Tools
LeooNic
A
license
B
quality
D
maintenance
An MCP server for automating Google Workspace applications including Sheets, Apps Script, Drive, Docs, and Gmail. It enables users to manipulate spreadsheets, edit scripts, manage files, and send emails directly from conversational AI interfaces.
Updated 5 months ago (2026-04-14 00:07 UTC)
31
MIT
google-sheets-mcp
Workplace & Productivity Developer Tools
richmcpharlin
A
license
C
quality
C
maintenance
A locally running MCP server that provides cell-level and formatting-level control over Google Sheets via the Sheets API v4, enabling reading, writing, formatting, and managing spreadsheets through natural language.
Updated 2 months ago (2026-07-06 12:19 UTC)
83
MIT
gsheets-mcp
Workplace & Productivity App Automation
henrysouchien
A
license
Not graded
quality
B
maintenance
MCP server for Google Sheets operations, enabling spreadsheet management including reading, writing, appending, creating, and searching sheets via natural language.
Updated 8 days ago (2026-09-08 00:25 UTC)
MIT