Skip to content

feat: Add Google Sheets Tables support#77

Merged
a-bonus merged 1 commit intoa-bonus:mainfrom
Pedrohgv:feature/tables-support
Mar 8, 2026
Merged

feat: Add Google Sheets Tables support#77
a-bonus merged 1 commit intoa-bonus:mainfrom
Pedrohgv:feature/tables-support

Conversation

@Pedrohgv
Copy link
Copy Markdown
Contributor

@Pedrohgv Pedrohgv commented Mar 8, 2026

Summary

  • Add 6 new tools for working with Google Sheets Tables API
  • Support creating, listing, and managing named tables with typed columns
  • Add table-aware row appending that respects headers and footers
  • Update documentation (README.md, claude.md)

New Tools

Tool Description
createTable Create named tables with column types (TEXT, NUMBER, DATE, DROPDOWN, CHECKBOX, PERCENT, CURRENCY)
listTables List all tables in a spreadsheet or specific sheet
getTable Get detailed table metadata including columns, range, and properties
deleteTable Delete tables (optionally clear data)
updateTableRange Modify table dimensions by updating the range
appendTableRows Append rows to tables with table-aware insertion (respects footers)

Features

  • Tables provide structured data with typed columns
  • Automatic formatting and data validation
  • Support for dropdown columns with custom values
  • Table metadata management (name, ID, range, columns)
  • Helper functions for table operations in googleSheetsApiHelpers.ts

Implementation based on Google Sheets Tables API

Test plan

  • All existing tests pass (124/124)
  • Code formatted with Prettier
  • Tools follow project conventions (camelCase, verb-first, Zod schemas)
  • Error handling with UserError
  • JSON.stringify output for structured data

🤖 Generated with Claude Code

Add 6 new tools for working with Google Sheets Tables:
- createTable: Create named tables with typed columns
- listTables: List all tables in a spreadsheet
- getTable: Get detailed table metadata
- deleteTable: Delete tables (optionally clear data)
- updateTableRange: Modify table dimensions
- appendTableRows: Append rows with table-aware insertion

Tables provide structured data with column types, automatic
formatting, and features like dropdown validation.

🤖 Generated with [Claude Code](https://claude.com/claude-code)

Co-Authored-By: Claude <noreply@anthropic.com>
@a-bonus a-bonus merged commit 9fed9d7 into a-bonus:main Mar 8, 2026
@Pedrohgv Pedrohgv deleted the feature/tables-support branch March 8, 2026 21:56
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

2 participants