Gog Google Workspace CLI
Paste the following prompt into your AI chat to install this skill:
Please follow https://skillhub.cn/install/skillhub.md to install @user_dd2eef27/1t20260420021952.
About this skill
Problem
When automating Gmail, Calendar, Drive, Sheets, and Docs, scripts often have to handle OAuth tokens, API endpoints, and parameter shapes separately. Manually copying message bodies, spreadsheet ranges, or event details is error-prone and hard to wire into workflows.
How It Works
- Auth: complete a one-time OAuth setup, then access Google Workspace by account and service.
- Lookup:
gmail searchcan retrieve mail with filters such asnewer_than:7d;calendar eventslists schedules;drive searchfinds files;contacts listreads contacts. - Read/write:
sheets get,sheets update,sheets append,sheets clear, andsheets metadatawork with spreadsheet ranges;docs exportanddocs catread document content.
For scripting, prefer --json and --no-input, and use GOG_ACCOUNT to avoid repeating the account. For Sheets writes, pass structured values with --values-json rather than concatenating inline text.
Boundaries
It is well suited for lookup, export, and lightweight updates, not complex in-place Docs editing; document editing requires a separate Docs API client. Add confirmation logic in the business layer before sending mail or creating events.
Use Cases
- Triage customer complaints by searching recent Gmail mail and checking the matching Sheets ticket status.
- Prepare meeting confirmations by reading today's Calendar events and the corresponding Contacts owners.
- Compile weekly reports by reading a Sheets A1:D10 range and appending one summary row.
- Feed downstream scripts by exporting a Google Doc to txt for parsing instead of editing it in place.
Best For
- Support operations staff who reconcile Gmail complaint mail with Sheets ticket status.
- Project managers who coordinate schedules and need Calendar events matched to Contacts owners.
- Automation engineers who need reliable Sheets range reads and Docs text exports.
- Data analysts who locate Drive files and export Docs to txt for archival pipelines.
Related Skills
A one-shot coding agent built on Claude Code CLI that runs non-interactively, supports a specified workdir, and can be monitored in the foreground or background.
Preview and confirm file sorting by extension, with recursive cleanup, ignore rules, and transactional rollback.
An engineering assistant for static HTML/CSS/JS pages, design-token extraction, IE8-compatible review, and structured delivery.
An engineering workflow for requirement analysis, scenario modeling, risk planning, quality gates, testing, and knowledge capture, with lightweight, standard, and full modes.