maton google-sheets values batch-update
maton google-sheets values batch-update <spreadsheet-id> [flags]
Send a JSON array of ValueRange objects, each with “range” and “values”. See https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/batchUpdate.
Options
-
--connection <string> - Connection ID to route through (Maton-Connection header)
-
--data <string> - JSON array of ValueRange objects (required)
-
--dry-run - Print the request that would be sent without executing it
-
--format <string> - Output format: 'json' (default) or 'text' on supported commands
-
--include-values-in-response - Echo the written values back in the response
-
--input-option <string> (default "USER_ENTERED") - valueInputOption: USER_ENTERED or RAW
-q,--jq <expression>- Filter JSON output using a jq expression
-
--paginate - Follow next_cursor and concatenate all pages (list commands only)
-
--response-value-render-option <string> - FORMATTED_VALUE (default), UNFORMATTED_VALUE, or FORMULA
-
--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 values batch-update ABC --data '[{"range":"Sheet1!A1","values":[["x"]]},{"range":"Sheet2!A1","values":[["y"]]}]'