maton google-sheets values batch-get

Read values from multiple ranges in one call

maton google-sheets values batch-get <spreadsheet-id> [flags]

Options

--connection <string>
Connection ID to route through (Maton-Connection header)
--date-time-render-option <string>
SERIAL_NUMBER 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
--paginate
Follow next_cursor and concatenate all pages (list commands only)
-r, --range <strings>
A1 range to read; pass repeatedly for multiple ranges (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 batch-get ABC --range Sheet1!A1:B2 --range Sheet2!A1

See also