{"id":"b33be7a5-c348-46ff-b10f-7e4308c1849e","shortId":"rvLLcQ","kind":"skill","title":"gws-sheets-append","tagline":"Google Sheets: Append a row to a spreadsheet.","description":"# sheets +append\n\n> **PREREQUISITE:** Read `../gws-shared/SKILL.md` for auth, global flags, and security rules. If missing, run `gws generate-skills` to create it.\n\nAppend a row to a spreadsheet\n\n## Usage\n\n```bash\ngws sheets +append --spreadsheet <ID>\n```\n\n## Flags\n\n| Flag | Required | Default | Description |\n|------|----------|---------|-------------|\n| `--spreadsheet` | ✓ | — | Spreadsheet ID |\n| `--values` | — | — | Comma-separated values (simple strings) |\n| `--json-values` | — | — | JSON array of rows, e.g. '[[\"a\",\"b\"],[\"c\",\"d\"]]' |\n| `--range` | — | `A1` | Target range in A1 notation (e.g. 'Sheet2!A1') to select a specific tab |\n\n## Examples\n\n```bash\ngws sheets +append --spreadsheet ID --values 'Alice,100,true'\ngws sheets +append --spreadsheet ID --json-values '[[\"a\",\"b\"],[\"c\",\"d\"]]'\ngws sheets +append --spreadsheet ID --range \"Sheet2!A1\" --values 'Alice,100'\n```\n\n## Tips\n\n- Use --values for simple single-row appends.\n- Use --json-values for bulk multi-row inserts.\n- Use --range to append to a specific sheet tab (default: A1, i.e. first sheet).\n\n> [!CAUTION]\n> This is a **write** command — confirm with the user before executing.\n\n## See Also\n\n- [gws-shared](../gws-shared/SKILL.md) — Global flags and auth\n- [gws-sheets](../gws-sheets/SKILL.md) — All read and write spreadsheets commands","tags":["gws","sheets","append","cli","googleworkspace","agent-skills","ai-agent","automation","discovery-api","gemini-cli-extension","google-admin","google-api"],"capabilities":["skill","source-googleworkspace","skill-gws-sheets-append","topic-agent-skills","topic-ai-agent","topic-automation","topic-cli","topic-discovery-api","topic-gemini-cli-extension","topic-google-admin","topic-google-api","topic-google-calendar","topic-google-chat","topic-google-docs","topic-google-drive"],"categories":["cli"],"synonyms":[],"warnings":[],"endpointUrl":"https://skills.sh/googleworkspace/cli/gws-sheets-append","protocol":"skill","transport":"skills-sh","auth":{"type":"none","details":{"cli":"npx skills add googleworkspace/cli","source_repo":"https://github.com/googleworkspace/cli","install_from":"skills.sh"}},"qualityScore":"0.700","qualityRationale":"deterministic score 0.70 from registry signals: · indexed on github topic:agent-skills · 26371 github stars · SKILL.md body (1,311 chars)","verified":false,"liveness":"unknown","lastLivenessCheck":null,"agentReviews":{"count":0,"score_avg":null,"cost_usd_avg":null,"success_rate":null,"latency_p50_ms":null,"narrative_summary":null,"summary_updated_at":null},"enrichmentModel":"deterministic:skill-github:v1","enrichmentVersion":1,"enrichedAt":"2026-05-18T18:52:31.191Z","embedding":null,"createdAt":"2026-04-18T20:24:29.549Z","updatedAt":"2026-05-18T18:52:31.191Z","lastSeenAt":"2026-05-18T18:52:31.191Z","tsv":"'/gws-shared/skill.md':17,173 '/gws-sheets/skill.md':181 '100':98,122 'a1':75,79,83,119,152 'alic':97,121 'also':169 'append':4,7,14,35,45,93,102,114,131,145 'array':66 'auth':19,177 'b':71,109 'bash':42,90 'bulk':137 'c':72,110 'caution':156 'comma':57 'comma-separ':56 'command':161,187 'confirm':162 'creat':33 'd':73,111 'default':50,151 'descript':51 'e.g':69,81 'exampl':89 'execut':167 'first':154 'flag':21,47,48,175 'generat':30 'generate-skil':29 'global':20,174 'googl':5 'gws':2,28,43,91,100,112,171,179 'gws-share':170 'gws-sheet':178 'gws-sheets-append':1 'i.e':153 'id':54,95,104,116 'insert':141 'json':63,65,106,134 'json-valu':62,105,133 'miss':26 'multi':139 'multi-row':138 'notat':80 'prerequisit':15 'rang':74,77,117,143 'read':16,183 'requir':49 'row':9,37,68,130,140 'rule':24 'run':27 'secur':23 'see':168 'select':85 'separ':58 'share':172 'sheet':3,6,13,44,92,101,113,149,155,180 'sheet2':82,118 'simpl':60,127 'singl':129 'single-row':128 'skill':31 'skill-gws-sheets-append' 'source-googleworkspace' 'specif':87,148 'spreadsheet':12,40,46,52,53,94,103,115,186 'string':61 'tab':88,150 'target':76 'tip':123 'topic-agent-skills' 'topic-ai-agent' 'topic-automation' 'topic-cli' 'topic-discovery-api' 'topic-gemini-cli-extension' 'topic-google-admin' 'topic-google-api' 'topic-google-calendar' 'topic-google-chat' 'topic-google-docs' 'topic-google-drive' 'true':99 'usag':41 'use':124,132,142 'user':165 'valu':55,59,64,96,107,120,125,135 'write':160,185","prices":[{"id":"556a147a-d3d7-47e3-8dde-968f747a08eb","listingId":"b33be7a5-c348-46ff-b10f-7e4308c1849e","amountUsd":"0","unit":"free","nativeCurrency":null,"nativeAmount":null,"chain":null,"payTo":null,"paymentMethod":"skill-free","isPrimary":true,"details":{"org":"googleworkspace","category":"cli","install_from":"skills.sh"},"createdAt":"2026-04-18T20:24:29.549Z"}],"sources":[{"listingId":"b33be7a5-c348-46ff-b10f-7e4308c1849e","source":"github","sourceId":"googleworkspace/cli/gws-sheets-append","sourceUrl":"https://github.com/googleworkspace/cli/tree/main/skills/gws-sheets-append","isPrimary":false,"firstSeenAt":"2026-04-18T21:52:06.076Z","lastSeenAt":"2026-05-18T18:52:31.191Z"},{"listingId":"b33be7a5-c348-46ff-b10f-7e4308c1849e","source":"skills_sh","sourceId":"googleworkspace/cli/gws-sheets-append","sourceUrl":"https://skills.sh/googleworkspace/cli/gws-sheets-append","isPrimary":true,"firstSeenAt":"2026-04-18T20:24:29.549Z","lastSeenAt":"2026-05-07T22:40:14.670Z"}],"details":{"listingId":"b33be7a5-c348-46ff-b10f-7e4308c1849e","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"googleworkspace","slug":"gws-sheets-append","github":{"repo":"googleworkspace/cli","stars":26371,"topics":["agent-skills","ai-agent","automation","cli","discovery-api","gemini-cli-extension","google-admin","google-api","google-calendar","google-chat","google-docs","google-drive","google-sheets","google-workspace","oauth2","rust"],"license":"apache-2.0","html_url":"https://github.com/googleworkspace/cli","pushed_at":"2026-05-12T16:46:11Z","description":"Google Workspace CLI — one command-line tool for Drive, Gmail, Calendar, Sheets, Docs, Chat, Admin, and more. Dynamically built from Google Discovery Service. Includes AI agent skills.","skill_md_sha":"cac70a28cd25e20e53e221479bfa6f4dfd98a7e0","skill_md_path":"skills/gws-sheets-append/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/googleworkspace/cli/tree/main/skills/gws-sheets-append"},"layout":"multi","source":"github","category":"cli","frontmatter":{"name":"gws-sheets-append","description":"Google Sheets: Append a row to a spreadsheet."},"skills_sh_url":"https://skills.sh/googleworkspace/cli/gws-sheets-append"},"updatedAt":"2026-05-18T18:52:31.191Z"}}