All notable changes to this project will be documented in this file.
The format is based on Keep a Changelog, and this project adheres to Semantic Versioning.
- Initial release of gsheet-cli
- Full Google Sheets API support:
- Read and write cells and ranges with A1 notation
- Append rows to sheets
- Pattern-based cell search with regex support
- Batch update operations
- Sheet management:
- Create, delete, rename, and duplicate sheets
- Freeze/unfreeze panes
- Column/row resizing and hiding
- Tab coloring and protection
- Comprehensive cell formatting:
- Text formatting (bold, italic, underline, strikethrough)
- Background and text colors
- Borders with custom styles
- Alignment and text wrapping
- Number formatting patterns
- Cell merging/unmerging
- Chart support (14 types):
- Basic: Line, bar, column, area, scatter, pie, combo
- Advanced: Bubble, candlestick, histogram, treemap, scorecard, waterfall, org charts
- Pivot table management:
- Create, update, refresh, and delete pivot tables
- Column/row grouping with aggregation functions
- Google Apps Script integration:
- Project creation and management
- Function execution with JSON arguments
- Version control and deployment management
- Metrics and process monitoring
- DuckDB-powered local caching:
- Bi-directional sync (pull/push)
- TTL-based cache invalidation
- Status monitoring
- Authentication:
- OAuth 2.0 interactive flow
- Service account JSON key support
- Credential caching
- MCP (Model Context Protocol) server:
- Stdio transport for AI assistant integration
- HTTP and SSE transport options
- Configuration:
- TOML-based configuration
- Named spreadsheet profiles
- XDG-compliant config paths
- Shell completions for bash, zsh, fish, and PowerShell
- Multiple output formats: table, JSON, CSV