Google workspace ops

Google Workspace Ops

This skill is for operating shared docs, spreadsheets, and decks as working systems, not just editing one file in isolation.

When to Use

• User needs to find a doc, sheet, or deck and update it in place
• Consolidating plans, trackers, notes, or customer lists stored in Google Drive
• Cleaning or restructuring a shared spreadsheet
• Importing, repairing, or reformatting a Google Slides deck
• Producing summaries from Docs, Sheets, or Slides for decision-making

Preferred Tool Surface

Use Google Drive as the entry point, then switch to the right specialist:

• Google Docs for text-heavy docs
• Google Sheets for tabular work, formulas, and charts
• Google Slides for decks, imports, template migration, and cleanup

Do not guess structure from filenames alone. Inspect first.

Workflow

1. Find the asset

Start with the Drive search surface to locate:

• the exact file
• sibling assets
• likely duplicates
• recently modified versions

If several documents look similar, confirm by title, owner, modified time, or folder.

2. Inspect before editing

Before making changes:

• summarize current structure
• identify tabs, headings, or slide count
• detect whether the task is local cleanup or structural surgery

Pick the smallest tool that can safely perform the work.

3. Edit with precision

• For Docs: use index-aware edits, not vague rewrites
• For Sheets: operate on explicit tabs and ranges
• For Slides: distinguish content edits from visual cleanup or template migration

If the requested work is visual or layout-sensitive, iterate with inspection and verification instead of one giant blind update.

4. Keep the working system clean

When the file is part of a larger workflow, also surface:

• duplicate trackers
• outdated decks
• stale docs vs canonical docs
• whether the asset should be archived, merged, or renamed

Output Format

Use:

ASSET
- file name
- type
- why this is the right file

CURRENT STATE
- structure summary
- key problems or blockers

ACTION
- edits made or recommended

FOLLOW-UPS
- archive / merge / duplicate cleanup / next file to update

Good Use Cases

• "Find the active planning doc and condense it"
• "Clean up this customer spreadsheet and show me the churn-risk rows"
• "Import this deck into Slides and make it presentable"
• "Find the current tracker, not the stale duplicate"

---

Google Workspace CLI (GWS)

GWS Ops

Overview

Standardize GWS usage: verify auth, resolve IDs from URLs, default to read-only checks, then run the minimum command needed.

Quick start

• Confirm GWS is available: gog --version
• List accounts and pick one explicitly if more than one: gog auth list
• Resolve URL to ID with python3 scripts/gog_parse_url.py "<url-or-id>"
• Run a read-only metadata command first (Drive/Sheets/Docs/Slides)

Workflow decision tree

1. Identify target type: sheet | doc | slide | file | folder | id | unknown via scripts/gog_parse_url.py.
2. Choose the smallest read-only command to confirm access:
   • Sheets: gog sheets metadata <spreadsheetId>
   • Docs: gog docs info <docId>
   • Slides: gog slides info <presentationId>
   • Drive file/folder: gog drive get <fileId> or gog drive permissions <fileId>
3. Only proceed to write operations (update/append/move/share/delete) after explicit user confirmation.

Core tasks

Auth and account selection

• Show stored accounts: gog auth list
• Show auth configuration: gog auth status
• Add/authorize account: gog auth add <email>
• Always use --account <email> when multiple accounts exist.

Resolve IDs from URLs

• Parse a URL or ID:
  • python3 scripts/gog_parse_url.py "<url-or-id>"
• If output type is unknown, ask for a direct ID or a different URL.

Drive (files/folders)

• List root or a folder: gog drive ls
• Search by query: gog drive search "<query>"
• Get metadata: gog drive get <fileId>
• Download/export: gog drive download <fileId>
• Permissions check: gog drive permissions <fileId>

Sheets

• Metadata: gog sheets metadata <spreadsheetId>
• Read values: gog sheets get <spreadsheetId> <range>
• Export: gog sheets export <spreadsheetId>
• Write operations (update/append/clear/format): require explicit confirmation and exact range.

Docs

• Metadata: gog docs info <docId>
• Read text: gog docs cat <docId>
• Export: gog docs export <docId>

Slides

• Metadata: gog slides info <presentationId>
• Export: gog slides export <presentationId>

Output modes

• Use --plain for stable TSV output.
• Use --json when a caller wants structured output.
• Use --no-input in non-interactive flows to avoid hanging.

Error handling

• 403/404: verify account (gog auth list), check permissions (gog drive permissions <fileId>), and confirm the ID.
• If access fails, request the user to share the file with the selected account or provide the correct account.

Resources

• See ${CLAUDE_SKILL_DIR}/references/GWS-cheatsheet.md for a compact command list.
• Use scripts/gog_parse_url.py to normalize URLs into IDs before running commands.