Skip to content

Release Notes v0.3.0

Google Sheets support with 5 new tools for reading spreadsheets, cell values, and metadata.

Highlights

  • Google Sheets Support: 5 new tools for reading Google Sheets spreadsheets
  • Flexible Value Formats: Get cell values as formatted strings, typed objects, or raw values
  • URL Support: Accept spreadsheet URLs or IDs, with automatic GID and range extraction
  • Batch Operations: Retrieve multiple ranges in a single request

New Features

Google Sheets Tools

Tool Description
get_spreadsheet_metadata Get spreadsheet metadata (title, sheet count, locale, time zone)
list_sheets List all sheets with properties (rows, columns, frozen rows/cols)
get_sheet_values Get cell values from a specific range
get_sheet_data Get all data from a specific sheet
get_multiple_ranges Batch get values from multiple ranges

Value Formats

Three output formats for cell values:

Format Description
formatted Display values as strings (default)
typed Values with type information (string, number, bool, date)
raw Underlying values as strings

Example with typed output:

{
  "values": [
    [
      {"type": "string", "formatted_value": "Name"},
      {"type": "number", "formatted_value": "1234.56", "number_value": 1234.56}
    ]
  ]
}

URL Parsing

All Sheets tools accept either the spreadsheet ID or full URL:

# Using ID
mcp-google get-spreadsheet-metadata 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms

# Using URL
mcp-google get-spreadsheet-metadata "https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit#gid=0"

CLI Commands

New CLI commands for Sheets:

mcp-google get-spreadsheet-metadata <id-or-url>
mcp-google list-sheets <id-or-url>
mcp-google get-sheet-values <id-or-url> <range> [--sheet-name "Sheet1"]
mcp-google get-sheet-data <id-or-url> [--sheet-name "Sheet1"] [--include-metadata]

Composable Sheets Skill

Import the Sheets skill into custom MCP servers:

import "github.com/plexusone/mcp-google/skills/sheets"

sheetsSkill := sheets.New(httpClient)
sheetsSkill.Init(ctx)
rt.RegisterSkill(sheetsSkill)

OAuth Scopes

The server now requests an additional scope:

  • https://www.googleapis.com/auth/spreadsheets.readonly

Update your service account or OAuth configuration to include this scope.

Dependencies

Dependency Version Change
github.com/grokify/gogoogle v0.11.0 Updated from v0.10.0
google.golang.org/api v0.282.0 Updated from v0.280.0

Tool Count

Service Tools Total
Google Docs 4
Google Sheets 5
Google Slides 5
Total 14