skills.rest
oresttokovenko
oresttokovenkoCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

gws-sheets-append

Appends rows of values to a Google Sheets spreadsheet via the gws CLI.

Updated Nov 9, 2023
Search Tags:#productivity#cli#spreadsheet#google sheets#append#gws#row insert
One-click install
npx skills add https://github.com/oresttokovenko/dot-files --skill gws-sheets-append-oresttokovenko
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: gws-sheets-append
Source: https://github.com/oresttokovenko/dot-files/tree/main/chezmoi/dot_agents/skills/gws-sheets-append
Command: npx skills add https://github.com/oresttokovenko/dot-files --skill gws-sheets-append-oresttokovenko

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Adding new rows to a Google Sheets spreadsheet normally requires opening the web UI or writing API integration code. This Skill lets you append one or many rows directly from the command line using the gws CLI, making it easy to log data, record entries, or feed spreadsheets from scripts and AI workflows. ## Core Features & Use Cases - Single-row append: Pass comma-separated values with --values for quick one-line inserts. - Bulk multi-row insert: Pass a JSON array of rows with --json-values to append multiple records in one call. - Targeted tab selection: Use --range in A1 notation (e.g. 'Sheet2!A1') to append to a specific sheet tab instead of the default first sheet. - Use Case: After processing daily sales data, append each day's totals as a new row in a tracking spreadsheet with gws sheets +append --spreadsheet ID --values '2024-06-01,1520.50,42'. ## Quick Start Ask the AI to append a row of values to your Google Sheets spreadsheet by providing the spreadsheet ID and the comma-separated values to add.

Frequently Asked Questions about gws-sheets-append

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I append a row to a Google Sheets spreadsheet from the command line?▼

Run gws sheets +append with the --spreadsheet flag set to your spreadsheet ID and --values containing comma-separated values, for example 'Alice,100,true'. The row is added to the first sheet by default.

How do I append multiple rows to Google Sheets at once?▼

Use the --json-values flag with a JSON array of rows, such as '[["a","b"],["c","d"]]'. This inserts all rows in a single command instead of making separate append calls per row.

Can I append data to a specific sheet tab in Google Sheets?▼

Yes, use the --range flag with A1 notation including the tab name, such as --range 'Sheet2!A1'. Without it, the append targets the default A1 range of the first sheet.

What is the difference between --values and --json-values in gws sheets append?▼

--values accepts a simple comma-separated string for a single row, while --json-values accepts a JSON array of arrays for bulk multi-row inserts. Use --values for quick single entries and --json-values for batch data.

Does appending rows to Google Sheets require confirmation?▼

Yes, this is a write command that modifies spreadsheet data, so the skill instructs confirming with the user before executing. It also requires the gws binary and prior authentication setup described in the gws-shared skill.

Related Skills

Explore More Software Engineering Skills→
73ai73ai
4

gws-sheets-append

Append single or multiple rows to Google Sheets spreadsheets.

Official
Intermediate
cellarwoodcellarwood

recipe-log-deal-update

Append deal status updates to a Google Sheets Sales Pipeline spreadsheet.

Official
Basic
googleworkspacegoogleworkspace
30.3k

gws-sheets-append

Append single or multiple rows to a Google Sheet using the gws CLI.

Official
Basic
beam-ai-teambeam-ai-team

google-sheets

Read, write, and manage Google Sheets spreadsheets via the Sheets API.

Official
Intermediate