maton google-sheets values get
Read values from a range
maton google-sheets values get <spreadsheet-id> [flags]
Options
-
--connection <string> - Connection ID to route through (Maton-Connection header)
-
--date-time-render-option <string> - SERIAL_NUMBER (default for UNFORMATTED_VALUE) or FORMATTED_STRING
-
--dry-run - Print the request that would be sent without executing it
-
--format <string> - Output format: 'json' (default) or 'text' on supported commands
-q,--jq <expression>- Filter JSON output using a jq expression
-
--major-dimension <string> - ROWS (default) or COLUMNS — major dimension of the response
-
--paginate - Follow next_cursor and concatenate all pages (list commands only)
-r,--range <string>- Range in A1 notation, e.g. 'Sheet1!A1:B2' (required)
-
--template <string> - Format JSON output using a Go template; see "maton help formatting"
-
--value-render-option <string> - FORMATTED_VALUE (default), UNFORMATTED_VALUE, or FORMULA
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 get ABC --range 'Sheet1!A1:D10'
$ maton google-sheets values get ABC --range Sheet1 --format text
$ maton google-sheets values get ABC --range A1:B2 --value-render-option UNFORMATTED_VALUE