freema/mcp-gsheets releases

What's Changed

• feat: publish to MCP Registry on release (v1.8.1) by @freema in https://github.com/freema/mcp-gsheets/pull/127

Full Changelog: https://github.com/freema/mcp-gsheets/compare/1.8.0...v1.8.1

Highlights

Two major community contributions plus a locale fix.

✨ New tools

Formatting analysis (by @marcin-uliasz in #125)

• sheets_get_border_map — compact 2D map of horizontal/vertical border lines. Resolves the "right border of N vs left border of N+1" ambiguity that makes per-cell border JSON hard to reason about.
• sheets_compare_ranges — position-by-position formatting diff between two equally-sized ranges. Great for verifying repeated patterns ("do rows 6–85 all match the template?").

Structural editing (by @master-nevi in #126)

• sheets_delete_columns — delete columns via full-column A1 range (e.g. Sheet1!B:D).
• sheets_delete_rows — delete rows via full-row A1 range (e.g. Sheet1!2:4).

🌍 Locale fix

Conditional formatting formulas are now normalized to English locale by default (semicolons → commas), which fixes a real pain point for non-English Sheets users (notably Polish). Original formulas are preserved under _formulaLocaleRaw and normalization can be disabled with normalizeFormulas: false.

New options:

• normalizeFormulas on sheets_get_conditional_formatting and sheets_get_full_sheet_snapshot (default: true)
• includeConditionalFormatting on sheets_get_full_sheet_snapshot (default: true)

🧪 Test coverage

Big coverage bump: google-auth, validation-helpers, response-helpers, formula-locale, json-parser, error-messages, plus edge cases across existing tools. 485/485 passing.

🧹 Cleanup

• Removed unused mode parameter from sheets_compare_ranges schema (was documented but never read).
• Simplified axis title assignment in create-chart.

🙏 Thanks

• @marcin-uliasz — border-map + compare-ranges + locale fix + massive test coverage
• @master-nevi — delete-columns + delete-rows

Full changelog: https://github.com/freema/mcp-gsheets/blob/main/CHANGELOG.md

Full Changelog: https://github.com/freema/mcp-gsheets/compare/1.7.0...1.7.1

What's Changed

• fix: only load dotenv in explicit development mode by @translunar in https://github.com/freema/mcp-gsheets/pull/121
• change: new sheet read tools, ESLint refactor, and schema fixes by @marcin-uliasz in https://github.com/freema/mcp-gsheets/pull/124

New Contributors

• @translunar made their first contribution in https://github.com/freema/mcp-gsheets/pull/121
• @marcin-uliasz made their first contribution in https://github.com/freema/mcp-gsheets/pull/124

Full Changelog: https://github.com/freema/mcp-gsheets/compare/1.6.0...1.7.0

What's Changed

• feat: Add Claude Code plugin by @freema in https://github.com/freema/mcp-gsheets/pull/114
• Bump version to 1.6.0 and add resource handling for Google Sheets API by @freema in https://github.com/freema/mcp-gsheets/pull/108

Full Changelog: https://github.com/freema/mcp-gsheets/compare/1.5.4...1.6.0

What's Changed

• Update README with personal website link by @freema in https://github.com/freema/mcp-gsheets/pull/106
• Minor update readme on How to Get GCP service account JSON Credentials by @rifqimfahmi in https://github.com/freema/mcp-gsheets/pull/105
• deps: bump @types/node from 24.2.1 to 24.9.1 by @dependabot[bot] in https://github.com/freema/mcp-gsheets/pull/102
• deps: bump googleapis from 140.0.1 to 164.1.0 by @dependabot[bot] in https://github.com/freema/mcp-gsheets/pull/101
• deps: bump typescript from 5.9.2 to 5.9.3 by @dependabot[bot] in https://github.com/freema/mcp-gsheets/pull/97
• Update library version by @freema in https://github.com/freema/mcp-gsheets/pull/107

New Contributors

• @rifqimfahmi made their first contribution in https://github.com/freema/mcp-gsheets/pull/105

Full Changelog: https://github.com/freema/mcp-gsheets/compare/1.5.3...1.5.4

What's Changed

• Add private key authentication method by @freema in https://github.com/freema/mcp-gsheets/pull/103
• chore: bump version to 1.5.3 by @freema in https://github.com/freema/mcp-gsheets/pull/104

Full Changelog: https://github.com/freema/mcp-gsheets/compare/1.5.2...1.5.3

What's Changed

• feat: bump version to 1.5.2 by @freema in https://github.com/freema/mcp-gsheets/pull/92

Full Changelog: https://github.com/freema/mcp-gsheets/compare/1.5.1...1.5.2

What's Changed

• feat: update README for improved clarity on MCP client configuration … by @freema in https://github.com/freema/mcp-gsheets/pull/91

Full Changelog: https://github.com/freema/mcp-gsheets/compare/1.5.0...1.5.1

What's Changed

• feat: add sheets_insert_rows tool for inserting rows with optional da… by @freema in https://github.com/freema/mcp-gsheets/pull/80

Full Changelog: https://github.com/freema/mcp-gsheets/compare/1.4.3...1.5.0

Full Changelog: https://github.com/freema/mcp-gsheets/compare/1.4.2...1.4.3

Full Changelog: https://github.com/freema/mcp-gsheets/compare/1.4.1...1.4.2

Full Changelog: https://github.com/freema/mcp-gsheets/compare/1.4...1.4.1

What's Changed

• deps: bump @modelcontextprotocol/sdk from 0.5.0 to 1.17.1 by @dependabot[bot] in https://github.com/freema/mcp-gsheets/pull/54
• deps: bump @types/node from 20.17.57 to 24.1.0 by @dependabot[bot] in https://github.com/freema/mcp-gsheets/pull/53
• deps: bump dotenv from 16.5.0 to 17.2.1 by @dependabot[bot] in https://github.com/freema/mcp-gsheets/pull/52

New Contributors

• @dependabot[bot] made their first contribution in https://github.com/freema/mcp-gsheets/pull/54

Full Changelog: https://github.com/freema/mcp-gsheets/compare/1.3.1...1.4

What's Changed

• feat: enhance authentication options by adding JSON string support an… by @freema in https://github.com/freema/mcp-gsheets/pull/39
• feat: add support for service account credentials as JSON string and … by @freema in https://github.com/freema/mcp-gsheets/pull/40

Full Changelog: https://github.com/freema/mcp-gsheets/compare/1.3...1.3.1

What's Changed

• chore: Remove test-serialization.js file and its associated error han… by @freema in https://github.com/freema/mcp-gsheets/pull/10
• Refactoring add new by @freema in https://github.com/freema/mcp-gsheets/pull/26

Full Changelog: https://github.com/freema/mcp-gsheets/compare/1.2...1.3

What's Changed

• docs: Update cloning instructions in README to include HTTPS and SSH … by @freema in https://github.com/freema/mcp-gsheets/pull/2
• Ref imports by @freema in https://github.com/freema/mcp-gsheets/pull/8
• feat: Update README and package.json with author and repository details by @freema in https://github.com/freema/mcp-gsheets/pull/9

Full Changelog: https://github.com/freema/mcp-gsheets/compare/1.1...1.2

What's Changed

• refactor: Consolidate tool imports and enhance input validation with … by @freema in https://github.com/freema/mcp-gsheets/pull/1

New Contributors

• @freema made their first contribution in https://github.com/freema/mcp-gsheets/pull/1

Full Changelog: https://github.com/freema/mcp-gsheets/compare/1.0...1.1

Full Changelog: https://github.com/freema/mcp-gsheets/commits/1.0