gws-sheets

Read, write, and batch-update Google Sheets with direct API access. PREREQUISITE: Read ../gws-shared/SKILL.md for auth, global flags, and security rules. If missing, run gws generate-skills to create it. Before calling any API method, inspect it: Use gws schema output to build your --params and --json flags. - Supports three helper commands: +read for retrieving values, +append for adding rows, and batchUpdate for applying multiple validated changes atomically - Access spreadsheets resource with methods to create, retrieve, and modify sheets, including grid data filtering and developer metadata operations - Requires Google Workspace authentication via the shared gws prerequisite; use gws schema to inspect method parameters before building requests - Batch operations validate all requests before applying; if any request fails, the entire batch is rejected with no partial changes - batchUpdate — Applies one or more updates to the spreadsheet. Each request is validated before being applied. If any request is not valid then the entire request will fail and nothing will be applied. Some requests have replies to give you some information about how they are applied.