Google Sheets MCP Server

Pricing

Rating

Developer

Actor stats

Categories

Share

MCP server enabling AI assistants to read, write, and manage Google Sheets. 14 tools with full CRUD operations, batch processing, and formula support. Uses Google Sheets API v4.

Features

• Read/Write cells and ranges — single cells, ranges, or batch operations
• Append rows — add data after existing content
• Sheet management — create, delete, and list sheet tabs
• Formula support — get and set formulas in cells
• JSON export — export sheet data with automatic header detection
• Batch operations — read/write multiple ranges in one API call
• Flexible auth — service account (full access) or API key (read-only)
• URL parsing — accepts spreadsheet URL or ID

Input

{
"credentialsJson":"{ ... service account JSON ... }",
"spreadsheetId":"1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgVE2upms",
"toolCall":{
"name":"sheets_read_range",
"arguments":{
"range":"Sheet1!A1:D10",
"include_headers":true
}
}
}

Authentication Options

Spreadsheet Selection

Provide either:

• spreadsheetId: The spreadsheet ID (from the URL)
• spreadsheetUrl: Full Google Sheets URL (ID extracted automatically)

Tools (14)

Setup

1. Create a Google Cloud project
2. Enable the Google Sheets API
3. Create a service account and download the JSON key
4. Share your spreadsheet with the service account email
5. Pass the JSON key as credentialsJson in the actor input

Output

Each tool call returns a result with success: true/false and relevant data.