Skip to content
Skillpedia
PT
PDF, Word & slides32k · #6283

gws-sheets-append

Allows the agent to add a new row to a Google Sheets spreadsheet. Useful for quickly recording data.

What it does

This tool adds a new row of data to a Google Sheet. You just need to provide the sheet's ID and the data you want to add.

When to use it

  • ✓When you need to manually add a new entry to a list.
  • ✓To quickly log information into a table.
  • ✓When updating a spreadsheet with new results or data.

Example of what to ask your AI

“Add the row 'Jane,25,New York' to my spreadsheet with ID '123abcXYZ'.”

Want more? Open the sections below.

How to use

The easiest way: copy the message below and paste it into Claude, ChatGPT, Cursor or any AI. It reads the skill and follows the instructions.

Skill link

https://github.com/googleworkspace/cli/blob/main/skills/gws-sheets-append/SKILL.md

Ready-to-paste message

Use this skill to help me: https://github.com/googleworkspace/cli/blob/main/skills/gws-sheets-append/SKILL.md Read the SKILL.md file at that link and follow its instructions for my task.
View on GitHub ↗Raw file
How it works

The tool finds the spreadsheet using the ID you provide. Then, it adds the data you specified to the end of the sheet, as a new row.

Installation

Easiest way: copy the skill link and paste it into Claude, ChatGPT or Cursor asking it to follow the instructions.

In the terminal (Claude Code, Codex, Cursor), in your project folder:

npx skills add googleworkspace/cli --skill gws-sheets-append

Or download just the file:

curl -L https://raw.githubusercontent.com/googleworkspace/cli/main/skills/gws-sheets-append/SKILL.md -o SKILL.md
Technical content (original SKILL.md)

Original text by the author, straight from GitHub.

sheets +append

PREREQUISITE: Read ../gws-shared/SKILL.md for auth, global flags, and security rules. If missing, run gws generate-skills to 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"]]'
--range — A1 Target range in A1 notation (e.g. 'Sheet2!A1') to select a specific tab

Examples

gws sheets +append --spreadsheet ID --values 'Alice,100,true'
gws sheets +append --spreadsheet ID --json-values '[["a","b"],["c","d"]]'
gws sheets +append --spreadsheet ID --range "Sheet2!A1" --values 'Alice,100'

Tips

  • 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).

[!CAUTION] This is a write command — confirm with the user before executing.

See Also

FAQ

How do I find my spreadsheet ID?

The ID is a long string of letters and numbers in your Google Sheet's URL. It's usually found between '/d/' and '/edit'.

Can I add multiple rows at once?

Yes, you can use the JSON format to add multiple rows at once, which is useful for large amounts of data.

Can I add data to a specific sheet tab?

Yes, you can use the '--range' option to specify the tab and cell where you want to start adding data.

Details

Original description by the author

Google Sheets: Append a row to a spreadsheet.

repo: googleworkspace/cli

Popularity

GitHub stars
32k
Ranking position
#6283
License
Apache-2.0
Updated
10/6/2026

Is this skill useful?

0

Sign in to vote.

Comments

  • …

More skills from this repository

Analysis & spreadsheets32k

gws-admin-reports

Helps your agent get activity reports from Google Workspace. It collects audit and usage data.

googleworkspace/cli

Email & messaging32k

gws-calendar-agenda

Helps your agent see upcoming events across all calendars. It's useful for organizing your schedule and knowing what's coming up.

googleworkspace/cli

Email & messaging32k

gws-calendar-insert

Lets your agent create new events in Google Calendar. It's useful for scheduling appointments and meetings.

googleworkspace/cli

Email & messaging32k

gws-calendar

Allows your agent to manage calendars and events. It's useful for organizing your life and work.

googleworkspace/cli

Similar skills

PDF, Word & slides280k

google-workspace-ops

Operates with Google Workspace documents (Drive, Docs, Sheets, Slides) as a unified workflow. It makes it easy to find, summarize, and edit your files without leaving the tool.

affaan-m/ECC

PDF, Word & slides77k

Dynamics 365 Automation

Helps your agent manage customer information in Dynamics 365. It can handle contacts, sales, and cases, making work more organized.

ComposioHQ/awesome-claude-skills

PDF, Word & slides77k

Excel Automation

Helps your agent work with spreadsheets in Excel and Google Sheets. It can create, edit, and format files.

ComposioHQ/awesome-claude-skills