Summary
Chart CRUD is missing from gog sheets. Currently managing charts requires manually exchanging tokens and crafting batchUpdate JSON payloads via curl.
Proposed subcommands
| Command |
API |
Description |
sheets chart list <id> |
spreadsheets.get (fields=sheets.charts) |
List charts (ID, title, type, sheet) |
sheets chart delete <id> <chartId> |
batchUpdate → deleteEmbeddedObject |
Delete a chart |
sheets chart create <id> --spec-json '{...}' |
batchUpdate → addChart |
Create chart from raw spec JSON |
sheets chart update <id> <chartId> --spec-json '{...}' |
batchUpdate → updateChartSpec |
Update chart spec |
A --spec-json passthrough for the EmbeddedChartSpec keeps the initial scope small while covering all chart types. Ergonomic flags (--type, --series, --reversed, etc.) could come later.
Additional flags for create: --sheet (resolved to sheetId via metadata), --anchor (e.g. A72), --width, --height
Summary
Chart CRUD is missing from
gog sheets. Currently managing charts requires manually exchanging tokens and craftingbatchUpdateJSON payloads via curl.Proposed subcommands
sheets chart list <id>spreadsheets.get(fields=sheets.charts)sheets chart delete <id> <chartId>batchUpdate→deleteEmbeddedObjectsheets chart create <id> --spec-json '{...}'batchUpdate→addChartsheets chart update <id> <chartId> --spec-json '{...}'batchUpdate→updateChartSpecA
--spec-jsonpassthrough for the EmbeddedChartSpec keeps the initial scope small while covering all chart types. Ergonomic flags (--type, --series, --reversed, etc.) could come later.Additional flags for
create:--sheet(resolved to sheetId via metadata),--anchor(e.g. A72),--width,--height