About
Overview
The Google Sheets MCP Server enables AI agents to interact with Google Sheets. It provides tools for reading and writing cell values, creating and managing worksheets, formatting cells, and working with formulas. Perfect for data entry, reporting, and spreadsheet-based workflows.
Capabilities
Tools & Capabilities
⚡read_range
Read values from a range of cells
⚡write_range
Write values to a range of cells
⚡list_sheets
List all sheets in a spreadsheet
⚡create_sheet
Create a new sheet in a spreadsheet
⚡append_rows
Append rows to the bottom of a sheet
Setup
Installation
bash
Install
npx -y mcp-server-google-sheetsExamples
Example Usage
javascript
Usage
{
"mcpServers": {
"sheets": {
"command": "npx",
"args": ["-y", "mcp-server-google-sheets"],
"env": {
"GOOGLE_CLIENT_ID": "your-client-id",
"GOOGLE_CLIENT_SECRET": "your-secret"
}
}
}
}Quick Info
Authornicepkg
LanguageTypeScript
StatusStable
Stars★ 130
Last UpdatedFeb 12, 2026