v1.9.0

What's Changed

• Add Google Sheets native Tables MCP tools by @aldoborrero in #128

New Contributors

• @aldoborrero made their first contribution in #128

Full Changelog: v1.8.1...v1.9.0

v1.8.1

What's Changed

• feat: publish to MCP Registry on release (v1.8.1) by @freema in #127

Full Changelog: 1.8.0...v1.8.1

1.8.0

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

1.7.1

Full Changelog: 1.7.0...1.7.1

1.7.0

What's Changed

• fix: only load dotenv in explicit development mode by @translunar in #121
• change: new sheet read tools, ESLint refactor, and schema fixes by @marcin-uliasz in #124

New Contributors

• @translunar made their first contribution in #121
• @marcin-uliasz made their first contribution in #124

Full Changelog: 1.6.0...1.7.0

1.6.0

What's Changed

• feat: Add Claude Code plugin by @freema in #114
• Bump version to 1.6.0 and add resource handling for Google Sheets API by @freema in #108

Full Changelog: 1.5.4...1.6.0

1.5.4

What's Changed

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

New Contributors

• @rifqimfahmi made their first contribution in #105

Full Changelog: 1.5.3...1.5.4

1.5.3

What's Changed

• Add private key authentication method by @freema in #103
• chore: bump version to 1.5.3 by @freema in #104

Full Changelog: 1.5.2...1.5.3

1.5.2

What's Changed

• feat: bump version to 1.5.2 by @freema in #92

Full Changelog: 1.5.1...1.5.2

1.5.1

What's Changed

• feat: update README for improved clarity on MCP client configuration … by @freema in #91

Full Changelog: 1.5.0...1.5.1