feat: add readCellFormat, copyFormatting, and batchWrite tools#70
Merged
a-bonus merged 1 commit intoa-bonus:mainfrom Feb 23, 2026
Merged
feat: add readCellFormat, copyFormatting, and batchWrite tools#70a-bonus merged 1 commit intoa-bonus:mainfrom
a-bonus merged 1 commit intoa-bonus:mainfrom
Conversation
Three new tools for advanced spreadsheet operations: - readCellFormat: reads cell formatting (bold, colors, fonts, alignment) from a range using spreadsheets.get with includeGridData - copyFormatting: copies formatting (not values) between ranges using CopyPasteRequest with PASTE_FORMAT - batchWrite: writes data to multiple ranges in a single API call via values.batchUpdate Also exports four previously private helper functions from googleSheetsApiHelpers.ts (parseRange, resolveSheetId, colLettersToIndex, parseA1ToGridRange) needed by copyFormatting and readCellFormat.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
2 participants
Add this suggestion to a batch that can be applied as a single commit.This suggestion is invalid because no changes were made to the code.Suggestions cannot be applied while the pull request is closed.Suggestions cannot be applied while viewing a subset of changes.Only one suggestion per line can be applied in a batch.Add this suggestion to a batch that can be applied as a single commit.Applying suggestions on deleted lines is not supported.You must change the existing code in this line in order to create a valid suggestion.Outdated suggestions cannot be applied.This suggestion has been applied or marked resolved.Suggestions cannot be applied from pending reviews.Suggestions cannot be applied on multi-line comments.Suggestions cannot be applied while the pull request is queued to merge.Suggestion cannot be applied right now. Please check back later.
Summary
Three new tools for advanced spreadsheet operations:
spreadsheets.getwithincludeGridDataCopyPasteRequestwithPASTE_FORMATvalues.batchUpdateCloses #69
Changes
src/tools/sheets/readCellFormat.tssrc/tools/sheets/copyFormatting.tssrc/tools/sheets/batchWrite.tssrc/tools/sheets/index.ts— Added imports and registrationssrc/googleSheetsApiHelpers.ts— Exported 4 previously private helpers (parseRange,resolveSheetId,colLettersToIndex,parseA1ToGridRange) with no signature changesTesting
All three tools tested against a live Google Sheets spreadsheet:
readCellFormat: correctly returns bold, colors, font info for formatted cellscopyFormatting: copies header styles across sheetsbatchWrite: writes multiple ranges in one call, verified with readbacktscwith zero errors)