Omitting the sheet range can append data to an unintended tab
Source references: 5`--range` is optional and defaults to `A1`, which the documentation says selects the first sheet. A correct spreadsheet ID may therefore still target the wrong tab in a multi-tab spreadsheet.
If executed without an explicit range, one or many rows can be persistently appended to the first tab, potentially contaminating business data and requiring manual cleanup.
The source supports this risk: `--range` is optional, defaults to `A1`, and the documentation says this means the first sheet. In a multi-tab spreadsheet, omitting the range could therefore append data to an unintended tab. The skill also requires user confirmation before writing, which reduces but does not remove ambiguity about the target. The user can require the spreadsheet ID, tab, and range to be shown and confirmed before every write.
| `--values` | — | — | Comma-separated values (simple strings) || `--json-values` | — | — | JSON array of rows, e.g. '[["a","b"],["c","d"]]' || `--range` | — | `A1` | Target range in A1 notation (e.g. 'Sheet2!A1') to select a specific tab |Show 4 other places
- Use --values for simple single-row appends.- Use --json-values for bulk multi-row inserts.- Use --range to append to a specific sheet tab (default: A1, i.e. first sheet).| `--json-values` | — | — | JSON array of rows, e.g. '[["a","b"],["c","d"]]' || `--range` | — | `A1` | Target range in A1 notation (e.g. 'Sheet2!A1') to select a specific tab |- Use --json-values for bulk multi-row inserts.- Use --range to append to a specific sheet tab (default: A1, i.e. first sheet).> [!CAUTION]> This is a **write** command — confirm with the user before executing.