gws-sheets-append

The `gws-sheets-append` skill is designed to simplify the process of adding data to Google Sheets by appending rows directly to a spreadsheet. This skill addresses the common challenge of programmatically updating spreadsheets without manually opening Google Sheets or performing repetitive copy-paste operations. By providing a command-line interface, users can efficiently insert new rows into their spreadsheets, streamlining workflows that involve regular data updates or automated reporting.

The skill offers several features to accommodate different data entry needs. Users can append a single row using simple comma-separated values with the `--values` flag or insert multiple rows at once using a JSON array with the `--json-values` flag. It also supports specifying the target range in A1 notation, allowing precise control over which sheet tab and starting cell the data is appended to. This flexibility ensures that both small updates and bulk inserts can be handled seamlessly. Additionally, the skill includes safety guidance, emphasizing user confirmation before executing write operations, which is crucial for preventing accidental data overwrites.

Typical use cases for `gws-sheets-append` include automated reporting, logging events or transactions into a spreadsheet, syncing data from external sources, and batch data entry tasks. It is ideal for productivity-focused users, data analysts, developers, or anyone managing structured data in Google Sheets who wants to reduce manual effort and ensure consistent, error-free updates. Its command-line approach is particularly beneficial for users integrating spreadsheet updates into scripts or automation pipelines.