gum logofield manual
ServicesSheetsGoogle APIs for agents and terminals

Sheets

Sheets has 9 operations in gum's generated catalog. Start with search when you know the task, use describe to inspect request fields and scopes, then dispatch through the command that matches the operation risk class.

Count Value
Family Workspace documents
Operations 9
Risk classes 3 read, 6 write
Auth strategies 9 byo_oauth

Start here

bash
gum search "sheets values"
gum describe sheets.spreadsheets.get
gum read sheets.spreadsheets.get --args '{"spreadsheetId":"<spreadsheetId>"}' --output json

For write-class operations, gum requires the write command and an explicit write gate:

bash
gum describe sheets.spreadsheets.batchUpdate
gum write sheets.spreadsheets.batchUpdate --allow-write --args '{"spreadsheetId":"<spreadsheetId>","requests":[]}'

Operations

Operation Risk Auth Summary
sheets.spreadsheets.batchUpdate write byo_oauth Apply structural/formatting edits to a spreadsheet (add sheets, format cells, charts, conditional formatting).
sheets.spreadsheets.create write byo_oauth Create a new Google Spreadsheet.
sheets.spreadsheets.get read byo_oauth Fetch a spreadsheet's metadata, sheets, and (optionally) cell data.
sheets.spreadsheets.values.append write byo_oauth Append rows of values after a table in a spreadsheet range.
sheets.spreadsheets.values.batchGet read byo_oauth Read values from several ranges of a spreadsheet in one call.
sheets.spreadsheets.values.batchUpdate write byo_oauth Write values to several ranges of a spreadsheet in one call.
sheets.spreadsheets.values.clear write byo_oauth Clear the values from a spreadsheet range (keeps formatting).
sheets.spreadsheets.values.get read byo_oauth Read values from a Google Sheets range. Backs the sheets_read convenience tool.
sheets.spreadsheets.values.update write byo_oauth Write values to a Google Sheets range. Backs the sheets_write convenience tool.

Next