gws-sheets

Google Sheets: Read and write spreadsheets.

sheets (v4)

PREREQUISITE: Read ../gws-shared/SKILL.md for auth, global flags, and security rules. If missing, run gws generate-skills to create it.

gws sheets <resource> <method> [flags]

Helper Commands

CommandDescription
+appendAppend a row to a spreadsheet
+readRead values from a spreadsheet

API Resources

spreadsheets

  • batchUpdate — Applies one or more updates to the spreadsheet.
  • create — Creates a spreadsheet, returning the newly created spreadsheet.
  • get — Returns the spreadsheet at the given ID. Use fields parameter or includeGridData to include grid data.
  • getByDataFilter — Returns the spreadsheet filtered by data filters.
  • developerMetadata — Operations on the 'developerMetadata' resource
  • sheets — Operations on the 'sheets' resource
  • values — Operations on the 'values' resource

Discovering Commands

Before calling any API method, inspect it:

# Browse resources and methods
gws sheets --help

# Inspect a method's required params, types, and defaults
gws schema sheets.<resource>.<method>

Use gws schema output to build your --params and --json flags.