MCP Servers

google-sheets-mcp

MCP server to read and edit Google Sheets. It provides tools for managing spreadsheet data, formatting, and sheet operations, making it suitable for editorial calendars and task trackers.

README

google-sheets-mcp

MCP server to read and edit Google Sheets. Built for editorial calendars, task trackers and any agency-style spreadsheet workflow.

Tools (22)

Tool	What it does
`get_spreadsheet_info`	Title, tabs and dimensions of the spreadsheet
`get_sheet_data`	All data of a tab as an array of rows
`read_range`	Read a specific A1 range
`read_multiple_ranges`	Read several ranges in a single API call — more efficient than calling `read_range` repeatedly
`write_range`	Write data into a range (overwrites)
`update_cell`	Update a single cell
`batch_update_cells`	Update multiple individual cells in a single API call
`append_rows`	Append rows at the end of a tab
`find_replace`	Find and replace text across the whole spreadsheet
`clear_range`	Clear a range
`insert_rows`	Insert N blank rows starting at a given row
`delete_rows`	Delete a range of rows
`add_sheet`	Create a new tab
`rename_sheet`	Rename a tab
`copy_sheet`	Duplicate a tab within the same spreadsheet
`format_range`	Apply formatting (background color, bold, font size, alignment)
`freeze_rows`	Freeze the top N rows
`create_spreadsheet`	Create a new empty spreadsheet
`get_hyperlinks`	Extract hyperlink URLs from cells in a range — useful when a cell displays text that links elsewhere
`sort_range`	Sort a range by a column (ascending or descending)
`auto_resize_columns`	Auto-fit column widths to content
`duplicate_spreadsheet`	Clone an entire spreadsheet (all tabs and data)

Semantic colors for `format_range`

Name	Use
`hecho`	Light green — task done
`in_progress`	Light yellow — in progress
`por_hacer`	Light grey — pending
`alta`	Light red — high priority
`media`	Light yellow — medium priority
`baja`	Light blue — low priority
`header`	Steel blue — table header
`white`, `red`, `green`, `blue`, `yellow`, `orange`, `purple`, `grey`	Basic colors
`#RRGGBB`	Direct hex

Setup

Create a Google Cloud project (or reuse one) and enable the Google Sheets API, Google Docs API and Google Drive API (the token scopes cover all three, so you can reuse it with the sibling google-docs-mcp server if you want).
Create an OAuth 2.0 Client ID of type "Desktop app" and download it as client_secret.json.
If the app is in "Testing" mode, add your Google account as a test user.

Install dependencies:

python3 -m venv .venv
source .venv/bin/activate
pip install -r requirements.txt

Run the OAuth flow once:

CLIENT_SECRET_PATH=~/.config/google-sheets-mcp/client_secret.json \
  python3 setup_auth.py

This opens a browser — log in and grant access.

MCP client configuration

{
  "mcpServers": {
    "google-sheets": {
      "command": "/path/to/.venv/bin/python3",
      "args": ["/path/to/google-sheets-mcp/server.py"],
      "env": {
        "GOOGLE_WORKSPACE_TOKEN_PATH": "~/.config/google-workspace-mcp/token.json"
      }
    }
  }
}

Env var	Default	Purpose
`GOOGLE_WORKSPACE_TOKEN_PATH`	`~/.config/google-workspace-mcp/token.json`	Path to the OAuth token

Suggested task-sheet structure

Suggested status values: TODO, IN PROGRESS, DONE Suggested priorities: HIGH, MEDIUM, LOW

License

MIT — see LICENSE.

Recommended Servers

playwright-mcp

A Model Context Protocol server that enables LLMs to interact with web pages through structured accessibility snapshots without requiring vision models or screenshots.

Official

Featured

TypeScript

Magic Component Platform (MCP)

An AI-powered tool that generates modern UI components from natural language descriptions, integrating with popular IDEs to streamline UI development workflow.

Audiense Insights MCP Server

Enables interaction with Audiense Insights accounts via the Model Context Protocol, facilitating the extraction and analysis of marketing insights and audience data including demographics, behavior, and influencer engagement.

VeyraX MCP

Single MCP tool to connect all your favorite tools: Gmail, Calendar and 40 more.

Official

Featured

Local

graphlit-mcp-server

The Model Context Protocol (MCP) Server enables integration between MCP clients and the Graphlit service. Ingest anything from Slack to Gmail to podcast feeds, in addition to web crawling, into a Graphlit project - and then retrieve relevant contents from the MCP client.

Official

Featured

TypeScript

Kagi MCP Server

An MCP server that integrates Kagi search capabilities with Claude AI, enabling Claude to perform real-time web searches when answering questions that require up-to-date information.

Official

Featured

Python

E2B

Using MCP to run code via e2b.

Official

Featured

Neon Database

MCP server for interacting with Neon Management API and databases

Official

Featured

Exa Search

A Model Context Protocol (MCP) server lets AI assistants like Claude use the Exa AI Search API for web searches. This setup allows AI models to get real-time web information in a safe and controlled way.

Official

Featured