maton google-sheets values append
maton google-sheets values append <spreadsheet-id> [flags]
Append one or more rows after the last row of data in a range. Use –values for a simple comma-separated single row, or –json-values for richer payloads (single row or multi-row).
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-values-in-response - Echo the appended values back in the response
-
--input-option <string> (default "USER_ENTERED") - valueInputOption: USER_ENTERED or RAW
-
--insert-data-option <string> - insertDataOption: OVERWRITE (default) or INSERT_ROWS
-q,--jq <expression>- Filter JSON output using a jq expression
-
--json-values <string> - JSON array (one row) or array-of-arrays (multi-row) (one of --values/--json-values)
-
--paginate - Follow next_cursor and concatenate all pages (list commands only)
-r,--range <string>- Target range in A1 notation (required)
-
--response-value-render-option <string> - FORMATTED_VALUE (default), UNFORMATTED_VALUE, or FORMULA — applies when --include-values-in-response is set
-
--template <string> - Format JSON output using a Go template; see "maton help formatting"
-
--values <string> - Comma-separated cells for a single row (one of --values/--json-values)
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 append ABC --range A1 --values 'Alice,100,true'
$ maton google-sheets values append ABC --range Sheet2 --json-values '[["a","b"],["c","d"]]'
$ maton google-sheets values append ABC --range A1 --values 'x,y' --input-option RAW