maton google-sheets spreadsheet batch-update
maton google-sheets spreadsheet batch-update <spreadsheet-id> [flags]
Send a list of Sheets batchUpdate Request objects (e.g. addSheet, deleteSheet, updateCells). The Sheets API documents the request shapes at https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/request.
Options
-
--connection <string> - Connection ID to route through (Maton-Connection header)
-
--dry-run - Print the request that would be sent without executing it
-
--format <string> - Output format: 'json' (default) or 'text' on supported commands
-
--include-spreadsheet-in-response - Return the updated spreadsheet in the response
-q,--jq <expression>- Filter JSON output using a jq expression
-
--paginate - Follow next_cursor and concatenate all pages (list commands only)
-
--requests <string> - JSON array of Sheets Request objects (required)
-
--response-include-grid-data - Include cell-level grid data in the response spreadsheet
-
--response-range <strings> - Limit the response spreadsheet to these A1 ranges (repeatable)
-
--template <string> - Format JSON output using a Go template; see "maton help formatting"
Options inherited from parent commands
-p,--profile <string>- Profile to use for this invocation (overrides the active profile; also reads MATON_PROFILE)
Examples
$ maton google-sheets spreadsheet batch-update ABC --requests '[{"addSheet":{"properties":{"title":"Notes"}}}]'
$ maton google-sheets spreadsheet batch-update ABC --requests "$(cat reqs.json)"