gws-sheets-append
Append a row of data to the end of a Google Sheets spreadsheet for bulk data entry.
npx skills add googleworkspace/cli --skill gws-sheets-appendBefore / After Comparison
1 组In the past, batch entering data into Google Sheets required manually opening the spreadsheet and copying and pasting row by row, which was inefficient and prone to errors, especially with large volumes of data, making it time-consuming and laborious.
Now, with this feature, data can be automatically appended to the end of a Google Sheet with just one command, achieving efficient batch entry, significantly saving manual operation time and ensuring data accuracy.
sheets +append
PREREQUISITE: Read
../gws-shared/SKILL.mdfor auth, global flags, and security rules. If missing, rungws generate-skillsto create it.
Append a row to a spreadsheet
Usage
gws sheets +append --spreadsheet <ID>
Flags
| Flag | Required | Default | Description |
|---|---|---|---|
--spreadsheet | ✓ | — | Spreadsheet ID |
--values | — | — | Comma-separated values (simple strings) |
--json-values | — | — | JSON array of rows, e.g. '[["a","b"],["c","d"]]' |
Examples
gws sheets +append --spreadsheet ID --values 'Alice,100,true'
gws sheets +append --spreadsheet ID --json-values '[["a","b"],["c","d"]]'
Tips
- Use --values for simple single-row appends.
- Use --json-values for bulk multi-row inserts.
[!CAUTION] This is a write command — confirm with the user before executing.
See Also
- gws-shared — Global flags and auth
- gws-sheets — All read and write spreadsheets commands
User Reviews (0)
Write a Review
No reviews yet
Statistics
User Rating
Rate this Skill