google-sheets
Skill0 starsChanged 3 months agoMITView on GitHub
Use this skill when the artifact is a Google Sheet. Sheets is the one Google type where the local gog CLI is genuinely strong: it supports values read/write, append, clear, cell formatting, and metadata. Two tested-good paths: 1. gog sheets for create + values + formatting. Best when you need cell formatting, formulas, or incremental edits. 2. Drive convert-on-upload of CSV/TSV/XLSX for bulk data load. Best for dumping a large dataset into a fresh native Sheet quickly. - gog CLI…
- Reads credentials
- Installs packages
19 other projects use a version of this.
Adopted by
Most recently taken up by
- AceDataCloud/Skillstheir own version, first seen Nov 8, 2026
- chnlich/charlie-bottheir own version, first seen Nov 1, 2026
- weininghui/skillstheir own version, first seen Oct 30, 2026
- zenf-star/claude-skillstheir own version, first seen Oct 20, 2026
- 0mlkrizzz655335v/claude-skills-zhtheir own version, first seen Oct 15, 2026
- openai/pluginstheir own version, first seen Oct 13, 2026
Used with
Projects with it also use google-gmail, google-chat and 10 more.
Other files people use alongside this one.
Files found in the same public projects as a version of this one, more often than they turn up anywhere else. Each project counts once, large collections count for less, and this file's own repository is left out.
leolionartSkillgoogle-gmail
Operate Gmail via the Google Workspace CLI (gws) — send emails, reply with threading, triage inbox, and stream new messages as NDJSON. Use when users ask to send/forward/reply emails, check inbox summary, or automate email workflows.
Also in 4 projects that use this
antoniolgSkillgoogle-chat
Read Google Chat spaces/threads via the Chat API, create/refresh OAuth tokens, parse Gmail Chat URLs, and list spaces. Use when asked to look up or verify messages in Google Chat or when you need API access to Chat from the CLI.
Also in 3 projects that use this
clearsmogSkillgoogle-tasks
Manage Google Tasks via the `gtasks` CLI. Use when the user asks to view, add, update, complete, or delete tasks. Supports multiple task lists.
Also in 3 projects that use this
younghaiSkillgoogle-calendar
Google Calendar 일정 조회, 검색, 등록. "일정", "스케줄", "캘린더" 등을 언급하면 자동 실행. Daily Note 작성, Weekly Review에 사용.
Also in 9 projects that use this
refly-aiSkillgmail
Integrate with Gmail for email management and automation. Use when you need to: (1) send and compose emails with attachments, (2) read and search emails by criteria, (3) manage drafts and email labels, or (4) reply to email threads and conversations.
Also in 7 projects that use this
refly-aiSkillinstagram
Integrate with Instagram for social media. Use when you need to: (1) post content to Instagram, (2) manage media and insights, or (3) automate Instagram publishing workflows.
Also in 3 projects that use this
- +1 more from refly-ai
Other versions19 projects use a version of this.
Word for word · 0
None found.
Edited · 0
None found.
Wrote their own version · 19
- openai/plugins★ 7.8ksame name
- Lilac-Labs/gini-agent★ 1.9ksame name
- Open-Curiosity/gini-agent★ 1.9ksame name
- gemini-cli-extensions/workspace★ 646same name
- sanjay3290/ai-skills★ 452same name
- refly-ai/refly-skills★ 204same name
- hyperfx-ai/marketing-skills★ 112same name
- alanalvestech/hitank★ 38same name
- AceDataCloud/Skills★ 17same name
- pbc-os/smb-starter-kit★ 10same name
9 more not listed
How matches are found. Word for word: the exact same text. Edited: shares passages with this file (“99% same” means 99% of its five-word phrases also appear here; 10% or more counts). Their own version: similar meaning, or, weakest, the same name. We can’t tell which project had it first. Projects are counted among the 200 most-starred candidates, and mentions are links to the repository we found, up to 50 per site, so both counts are a floor.
In this repository36 other files it gives its agents.
- check-upstream-firstSkill
- data-verificationSkill
- deep-diveSkill
- delegation-handoffSkill
- grok-searchSkill
- is-it-really-brokenSkill
- keep-goingSkill
- learn-from-conversationsSkill
- memory-cleanupSkill
- moa-solveSkill
- mob-checkSkill
- multi-reviewSkill
- project-stewardSkill
- prove-the-setting-worksSkill
- recallSkill
- reportSkill
- robustify-doctorSkill
- skill-librarianSkill
- trust-frameworkSkill
- address-pr-commentsSkill
- diagram-renderingSkill
- find-the-real-bottleneckSkill
- live-database-maintenanceSkill
- mini-appSkill
- pr-review-sweepSkill
- scheduled-job-runnerSkill
- stop-the-noiseSkill
- upgrade-a-live-service-safelySkill
- vendor-switch-checkSkill
- writing-for-non-engineersSkill
- email-stewardSkill
- fieldySkill
- google-docsSkill
- google-slidesSkill
- imessage-bluebubblesSkill
- vapi-callsSkill
The file
We split this skill into the rules it gives an agent
11 rules. 0 are common, 2 are distinctive, and 9 are very specific to this project.
0
Common
Most of the 17 edited versions we read keep these.
2
Distinctive
This author's own choices. Worth a look.
9
Very specific
Tied to their project's names, files or tools. Probably skip.
- Common
- Distinctive
- Very specific
- Very specific: line 26
Use this skill when the artifact is a Google Sheet.
- Very specific: line 67
Do not use this for Docs or Slides.
- Very specific: line 71
Run with gog auth available.
- Very specific: line 108
Use --input RAW only when you want literal text, not evaluated formulas.
- Distinctive: line 167
Ask before overwriting an existing populated range, clearing data, sharing, or deleting.
- Very specific: line 169
Prefer append over update when adding rows to a live sheet to avoid clobbering.
- Very specific: line 174
Do not flatten logical tabs into one sheet with banner rows.
- Very specific: line 182
Write each tab with USER_ENTERED values.
- Distinctive: line 229
Prefer updating one draft rather than creating a new file on every attempt.
- Very specific: line 255
Using the wrong input mode: Keep --input USER_ENTERED explicit for typed values and live formulas.
- Very specific: line 269
Credential lookup fails (
missing_credentials): If the helper can't find gog's token, pass credentials explicitly: export gog's refresh …
“Common” is measured: kept by at least 6 in 10 of the 17 edited versions of this file we could read. “Very specific” is our guess from the words: it names a file, a command, a setting or the project itself.
Files
Google Sheets
Overview
Use this skill when the artifact is a Google Sheet. Sheets is the one Google type
where the local gog CLI is genuinely strong: it supports values read/write, append,
clear, cell formatting, and metadata.
Two tested-good paths:
gog sheetsfor create + values + formatting. Best when you need cell formatting, formulas, or incremental edits.- Drive convert-on-upload of CSV/TSV/XLSX for bulk data load. Best for dumping a large dataset into a fresh native Sheet quickly.
Prerequisites
gogCLI (steipete/gogcli) installed and authorized in the operating-system user's real$HOME. Authentication commands have changed across gog releases: inspectgog auth --help, then configure credentials and add the account using the commands supported by the installed version. The bundledscripts/gworkspace.pyreuses gog's stored OAuth refresh token for Drive import/export helpers.python3onPATH(the helper is stdlib-only — nopip installrequired).- For
gog sheetscommands, rungog sheets --helponce if the local gog version is unknown; the verified flag for 2D matrices is--values-json. - The helper resolves credentials in this order: explicit
--refresh-token-file/--client-secret-file, environment variables, then gog's stored token. If lookup fails it exits with{"error": "missing_credentials"}— see Common Pitfalls.
Run helper commands from the skill directory so
scripts/gworkspace.pyresolves relative to$PWD, or useskills/google-sheets/scripts/gworkspace.pyfrom the repo root.
$HOME shadowing: some agent runtimes rewrite
$HOMEto a sandbox path where gog's auth doesn't exist. If credential lookup fails in that environment, pointHOMEat the real OS user home before invoking gog or the helper.
When to Use
- User asks for a Google Sheet, spreadsheet, tracker, budget, dataset, or table with formulas.
- User has CSV/TSV/XLSX data to turn into a native Google Sheet.
- User wants header styling, conditional formatting, frozen rows, or formulas.
- User asks whether to use
gog, raw API, or browser for Sheets.
Do not use this for Docs or Slides; load google-docs or google-slides.
Path A: gog sheets (formatting + formulas)
Run with gog auth available.
# Create
SID=$(gog sheets create "Q2 Financials" --json --no-input 2>/dev/null | python3 -c "import json,sys;print(json.load(sys.stdin)['spreadsheetId'])")
# Write a 2D matrix — USE --values-json, not positional values
gog sheets update "$SID" "Sheet1!A1:E6" --values-json \
'[["Region","Product","Units","Revenue","Margin"],
["North","Widget A",1200,48000,0.42],
["North","Widget B",800,32000,0.38],
["South","Widget A",1500,60000,0.44],
["South","Widget B",600,24000,0.36],
["West","Widget A",900,36000,0.41]]' \
--input USER_ENTERED --json --no-input --force
# Format the header row
gog sheets format "$SID" "Sheet1!A1:E1" \
--format-json '{"textFormat":{"bold":true},"backgroundColor":{"red":0.2,"green":0.3,"blue":0.5},"horizontalAlignment":"CENTER"}' \
--format-fields 'userEnteredFormat.textFormat.bold,userEnteredFormat.backgroundColor,userEnteredFormat.horizontalAlignment' \
--json --no-input --force
# Append rows later
gog sheets append "$SID" "Sheet1!A:E" --values-json '[["East","Widget C",400,16000,0.30]]' --input USER_ENTERED --json --no-input --force
# Read back to verify
gog sheets get "$SID" "Sheet1!A1:E7" --json --no-inputFormulas
With --input USER_ENTERED, formula strings are evaluated:
gog sheets update "$SID" "Sheet1!F1:F6" --values-json '[["Total"],["=C2*D2"],["=C3*D3"],["=C4*D4"],["=C5*D5"],["=C6*D6"]]' --input USER_ENTERED --json --no-input --forceUse --input RAW only when you want literal text, not evaluated formulas.
Path B: Drive convert-on-upload (bulk data)
Best for loading an existing CSV/TSV/XLSX as a fresh native Sheet:
python3 scripts/gworkspace.py upload data.csv --as sheet --name "Imported Dataset" --parent FOLDER_ID
python3 scripts/gworkspace.py upload data.xlsx --as sheet --name "Imported Workbook"FOLDER_ID is optional; omit --parent to create in My Drive root. To target a folder,
copy the ID from its Drive URL (.../folders/<FOLDER_ID>), list folders with
gog drive ls --json, or create one with
python3 scripts/gworkspace.py mkdir "Reports". To return the created link, parse
.webViewLink from the helper's JSON output.
scripts/gworkspace.py sets the correct source MIME automatically (text/csv,
text/tab-separated-values, xlsx) and target MIME
application/vnd.google-apps.spreadsheet.
The bundled helper uses an in-memory multipart upload path, so keep it to small files
(roughly 5 MB or less). For larger workbooks, prefer a current gog drive upload
conversion flow when supported, or use a resumable Drive upload. After bulk load, switch
to Path A (gog sheets format) for header styling.
When to use raw API or browser
- Raw Sheets API
spreadsheets.batchUpdate: needed for advanced features gog may not expose — conditional formatting rules, frozen panes, data validation, charts, multiple sheets/tabs with specific styling. Mint a token withpython3 scripts/gworkspace.py tokenand POST tohttps://sheets.googleapis.com/v4/spreadsheets/SID:batchUpdate. - Browser: visual QA, chart fine-tuning, or one-off manual cleanup only. Not the primary backend.
Verification
gog sheets get "$SID" "Sheet1!A1:E7" --json --no-input # values correct?
python3 scripts/gworkspace.py meta "$SID" # native Sheet MIME?For financial/legal spreadsheets, verify labels and values together on key rows, not
just totals in isolation. A workbook can have correct numbers but one-row-shifted labels
after template filling or Drive import. Read back representative ranges from the live
Google Sheet (for example Income Statement!A8:F20 and the final total rows) and
confirm the label-value alignment matches the source template. See
references/xlsx-financial-workbook-verification.md for the full checklist and command
snippets.
For formatting, read back via the API with includeGridData=true and confirm
userEnteredFormat on the styled range. A successful format call returns the applied
field mask; that confirms acceptance, but a grid-data read confirms the actual stored
format.
Safety and Approval
- "Create a sheet" is approval to create the new Drive file.
- Ask before overwriting an existing populated range, clearing data, sharing, or deleting.
- Prefer
appendoverupdatewhen adding rows to a live sheet to avoid clobbering. gog sheets clearis destructive; confirm the range first.
Multi-tab workbooks + visual QA
Do not flatten logical tabs into one sheet with banner rows. Feature-detect the
installed CLI with gog sheets --help:
- For a new workbook, prefer
gog sheets create TITLE --sheets "Summary,Data"when supported. - For an existing workbook, prefer
gog sheets add-tabwhen supported. - Otherwise use the Sheets API
spreadsheets.batchUpdatewith anaddSheetrequest.
Write each tab with USER_ENTERED values. Advanced formatting can use
spreadsheets.batchUpdate requests such as repeatCell, updateDimensionProperties,
addConditionalFormatRule, setBasicFilter, and updateSheetProperties.
Choose live formulas or computed values deliberately
For a native interactive Sheet that should recalculate, keep real formulas and let
USER_ENTERED evaluate them. For a portable/static XLSX deliverable, write computed
values and verify the formula count is zero. Never apostrophe-prefix formulas as a
workaround: "'" + formula renders as broken-looking literal formula text.
Mandatory verification before handing over
- Literal-formula and error scan — read every tab with
gog sheets get... --render FORMATTED_VALUEand assert no displayed cell starts with=or'=, and none unexpectedly contain#REF!,#ERROR!,#NAME?,#DIV/0!,#VALUE!,#NUM!, or#N/A. - Formula policy — for a live-formula workbook, read the same range with
gog sheets get... --render FORMULAand confirm required formulas remain present. For an intentionally static workbook, instead confirm formula count is zero and compare critical totals against independently computed expectations. - Visual QA — export each tab to PDF and inspect every page. Use a multipage
rasterizer such as
pdftoppmrather than a first-page-only conversion:
Then inspect the PNG with a vision tool. This catches what APIs cannot: truncated columns, sentences split mid-thought across rows, header text that contradicts the content ("THE THREE BUCKETS" above four items), unreadable CODE_NAME labels. Note: PDF export renderscurl -sL -H "Authorization: Bearer $TOK" \ "https://docs.google.com/spreadsheets/d/$SID/export?format=pdf&gid=$GID&portrait=false&fitw=true&gridlines=false" -o tab.pdf pdftoppm -png -r 150 tab.pdf tab-pageverticalAlignment: MIDDLEas top-aligned — verify alignment viaincludeGridData=true&fields=...effectiveFormatinstead, not the PDF.
Layout rules
- Long prose goes in ONE cell with
wrapStrategy: WRAP+ a wide column, never split across consecutive rows — that reads as a formatting bug. - Set explicit
pixelSizerow heights for wrapped narrative rows so text can breathe. hideGridlines: Trueon summary/report tabs; keep them on data tabs.- Human-readable labels beat unexplained internal codes.
- For financial summaries include a control total proving the parts sum to the source total — reviewers flag its absence immediately.
- Make counts consistent everywhere; if summary and detail counts differ, state why.
Final-artifact hygiene
Prefer updating one draft rather than creating a new file on every attempt. Track the final spreadsheet ID and confirm sharing applies to that ID. Do not delete or trash superseded drafts unless cleanup was explicitly authorized; if it was, verify the final artifact still exists after cleanup.
Common Pitfalls
- XLSX formula cache trap on funder/legal deliverables. Libraries like
openpyxlwrite formulas (=SUM(...)) but do not calculate and store cached results. Excel may recalculate on open, but Quick Look, Numbers previews, Drive conversion, and some Google Sheets imports may show$0, blank, or stale values. For external-facing financial workbooks where values must display correctly everywhere, prefer writing static computed values from Python instead of formulas. If formulas are required, verify after upload by reading the live Google Sheet values withgog sheets get. Also ensure labels do not start with=(e.g.= SOIL NET...) or spreadsheet tools will treat them as formulas. - Positional values instead of
--values-json. Ingog v0.9.0,gog sheets update SID RANGE '[[...]]'treats the JSON string as a single flat column and writes garbage like[["Region". Always pass a 2D matrix via--values-json. - Range smaller than data.
updateerrors with "tried writing to row N" if the A1 range is smaller than the matrix. Size the range to match, or write to a single anchor cell when the API allows. - Using the wrong input mode. Keep
--input USER_ENTEREDexplicit for typed values and live formulas; useRAWonly for literal strings. Do not rely on a release's implicit default. - Mixing wrapper flags with gog flags. Some Google Workspace wrappers use
--valuesfor JSON matrices; thegogCLI flag is--values-json. Don't mix them. - Uploading CSV without conversion.
gog drive upload data.csvkeeps it a CSV file. Use the convert path (target MIME spreadsheet) to get a native Sheet. - Assuming advanced formatting is in gog. Conditional formatting, frozen panes,
validation, and charts may need raw
spreadsheets.batchUpdate. Checkgog sheets --helpfirst. - Credential lookup fails (
missing_credentials). If the helper can't find gog's token, pass credentials explicitly: export gog's refresh token to a 0600 file withgog auth tokens export <account> --output /tmp/tok.json --force(newer releases also accept--out/--overwrite; checkgog auth tokens export --help). Then run the helper with--refresh-token-file /tmp/tok.json --client-secret-file <gog credentials.json>. The helper refuses explicit credential files that are group/world-readable or not owned by you —chmod 600them. These flags work before or after the subcommand. For a gog named client or a non-default gog home, use--gog-client <name>/--gog-home <dir>(or theGOG_CLIENT/GOG_HOMEenv vars). - Sharing is externally consequential. Permissions can be revoked, but
scripts/gworkspace.py share SHEET_ID --email... --role...grants real Drive access. Confirm recipient and role with the user before using it. - Array index vs. A1 row number (off-by-one). Returned values are a 0-indexed array
relative to the requested range. Compute
sheet_row = requested_range_start_row + array_index;index + 1is correct only when the requested range starts at row 1. Read back the changed cell and its stable row label before treating the update as successful.
One-Shot Recipe
SID=$(gog sheets create "New Tracker" --json --no-input 2>/dev/null | python3 -c "import json,sys;print(json.load(sys.stdin)['spreadsheetId'])")
gog sheets update "$SID" "Sheet1!A1:C1" --values-json '[["Name","Status","Owner"]]' --input USER_ENTERED --json --no-input --force
gog sheets format "$SID" "Sheet1!A1:C1" --format-json '{"textFormat":{"bold":true}}' --format-fields 'userEnteredFormat.textFormat.bold' --json --no-input --force
echo "https://docs.google.com/spreadsheets/d/$SID/edit"Does it work?
Reviews from people and from AI agents that ran it: what they used it for, and whether it worked.
No reviews yet
People and AI agents can review whether this works in practice. Say what you used it for, and whether it worked.
- It worked
- Partly
- It didn't
Using an agent? It can post a review for you after it has run the file: the MCP tool registry_write, action report. How to connect one.
Your trail
Files you open will collect here, so you can find them again.
Open two or more, and you can remix the rules you like from each into one list. Kept in this browser only.
Now do this for your own.
Bring your CLAUDE.md, AGENTS.md or skills. agentleFS shows which of your rules are common, which are yours and which only fit one project, and keeps one version your agents read everywhere.

