gog sheets
Generated from
gog schema --json. Do not edit this page by hand; runmake docs-commands.
Google Sheets
#Usage
gog sheets (sheet) <command> [flags]#Parent
#Subcommands
- gog sheets add-tab - Add a new tab/sheet to a spreadsheet
- gog sheets append - Append values to a range
- gog sheets banding - Manage alternating color banding
- gog sheets chart - Manage spreadsheet charts
- gog sheets clear - Clear values in a range
- gog sheets conditional-format - Manage conditional formatting rules
- gog sheets copy - Copy a Google Sheet
- gog sheets create - Create a new spreadsheet
- gog sheets delete-tab - Delete a tab/sheet from a spreadsheet (use --force to skip confirmation)
- gog sheets export - Export a Google Sheet (pdf|xlsx|csv) via Drive
- gog sheets find-replace - Find and replace text across a spreadsheet
- gog sheets format - Apply cell formatting to a range
- gog sheets freeze - Freeze rows and columns on a sheet
- gog sheets get - Get values from a range
- gog sheets insert - Insert empty rows or columns into a sheet
- gog sheets links - Get cell hyperlinks from a range
- gog sheets merge - Merge cells in a range
- gog sheets metadata - Get spreadsheet metadata
- gog sheets named-ranges - Manage named ranges
- gog sheets notes - Get cell notes from a range
- gog sheets number-format - Apply number format to a range
- gog sheets raw - Dump raw Google Sheets API response as JSON (Spreadsheets.Get; lossless; for scripting and LLM consumption)
- gog sheets read-format - Read cell formatting from a range
- gog sheets rename-tab - Rename a tab/sheet in a spreadsheet
- gog sheets resize-columns - Resize sheet columns
- gog sheets resize-rows - Resize sheet rows
- gog sheets table - Manage Google Sheets tables
- gog sheets unmerge - Unmerge cells in a range
- gog sheets update - Update values in a range
- gog sheets update-note - Set or clear a cell note
#Flags
| Flag | Type | Default | Help |
|---|---|---|---|
--access-token | string | Use provided access token directly (bypasses stored refresh tokens; token expires in ~1h) | |
-a--account--acct | string | Account email for API commands (gmail/calendar/chat/classroom/drive/docs/slides/contacts/tasks/people/sheets/forms/appscript/ads) | |
--client | string | OAuth client name (selects stored credentials + token bucket) | |
--color | string | auto | Color output: auto|always|never |
--disable-commands | string | Comma-separated list of disabled commands; dot paths allowed | |
-n--dry-run--dryrun--noop--preview | bool | Do not make changes; print intended actions and exit successfully | |
--enable-commands | string | Comma-separated list of enabled commands; dot paths allowed (restricts CLI) | |
-y--force--assume-yes--yes | bool | Skip confirmations for destructive commands | |
--gmail-no-send | bool | false | Block Gmail send operations (agent safety) |
-h--help | kong.helpFlag | Show context-sensitive help. | |
-j--json--machine | bool | false | Output JSON to stdout (best for scripting) |
--no-input--non-interactive--noninteractive | bool | Never prompt; fail instead (useful for CI) | |
-p--plain--tsv | bool | false | Output stable, parseable text to stdout (TSV; no colors) |
--results-only | bool | In JSON mode, emit only the primary result (drops envelope fields like nextPageToken) | |
--select--pick--project | string | In JSON mode, select comma-separated fields (best-effort; supports dot paths). Desire path: use --fields for most commands. | |
-v--verbose | bool | Enable verbose logging | |
--version | kong.VersionFlag | Print version and exit |