Context
The Google Sheets API has 3 core REST methods: get, create, batchUpdate plus a values sub-API. gws sheets already wraps all core operations extensively (23 commands).
Status: Near-parity
Covered
| API Method |
gws commands |
spreadsheets.get |
sheets info, sheets list |
spreadsheets.create |
sheets create |
spreadsheets.batchUpdate |
sheets add-sheet, sheets delete-sheet, sheets rename-sheet, sheets duplicate-sheet, sheets merge, sheets unmerge, sheets sort, sheets find-replace, sheets format, sheets set-column-width, sheets set-row-height, sheets freeze, sheets insert-rows, sheets delete-rows, sheets insert-cols, sheets delete-cols |
values.get |
sheets read |
values.update |
sheets write |
values.append |
sheets append |
values.clear |
sheets clear |
Missing — 3 methods
| Command |
API Method |
Args/Flags |
sheets copy-to <sheet-id> |
sheets.copyTo |
--source, --destination (copy sheet to another spreadsheet) |
sheets batch-read |
values.batchGet |
--ranges (read multiple ranges at once) |
sheets batch-write |
values.batchUpdate |
--file (write multiple ranges at once) |
Skipped
| Method |
Reason |
values.batchClear |
sheets clear handles single ranges, batch rarely needed |
*ByDataFilter variants |
Advanced filtering, niche |
developerMetadata.* |
Internal metadata, niche |
spreadsheets.getByDataFilter |
Niche variant of get |
Acceptance criteria
