GOG Google Services CLI
Paste the following prompt into your AI chat to install this skill:
Install @user_dd2eef27/1t20260420021957 into your AI assistant according to https://skillhub.cn/install/skillhub.md.
About this skill
Problem
Gmail, Calendar, Drive, Contacts, Sheets, and Docs are scattered across web interfaces. Scripting lookups, organizing data, exporting documents, and light editing often require separate handling of OAuth, API parameters, and account context. Engineers need a unified command-line entry point that turns common operations into reproducible commands.
How It Works
gog starts with one-time OAuth setup: import client_secret.json, bind a Gmail account to gmail, calendar, drive, contacts, sheets, and docs, then verify credentials with gog auth list. After that, common tasks can be run from the shell: gog gmail search for mail queries, gog gmail send for sending mail; gog calendar events for events in a date range; gog drive search for Drive files; gog contacts list for contacts; gog sheets get, gog sheets update, gog sheets append, and gog sheets clear for spreadsheet ranges; and gog docs export or gog docs cat for reading or exporting documents.
Boundaries
This tool is best for scripted lookups, data extraction, document export, and light spreadsheet operations. In scripts, prefer --json with --no-input, and set GOG_ACCOUNT to avoid repeating account flags. Confirm intent before sending mail or creating events. In-place Docs editing is outside the current scope and requires a separate Docs API client.
Use Cases
- When triaging user feedback, use `gog gmail search newer_than:7d` to pull recent mail and extract ticket details.
- Before project meetings, use `gog calendar events` to check the next week's calendar for client and review conflicts.
- During monthly expense reviews, append detail rows with `gog sheets append`, then verify a range using `gog sheets get`.
- Before document review, export a Docs file to text with `gog docs export --format txt` for annotation and diffing.
Best For
- Ops engineers who need Gmail, Drive, and Sheets data in scripts
- Team assistants who verify Calendar events and prepare meeting materials before sessions
- Documentation engineers who export Docs to text via CLI for review
- Data operators who batch-append, clear, and validate Sheets ranges
Related Skills
Runs rule and semantic checks on Word files, adds comments, and applies GB/T 9704-2012 party/government formatting.
Generate professional .pptx presentations from a topic or outline, with themes, common layouts, speaker notes, and 16:9/4:3 support.
Generates a fixed-structure A-share tech daily across five tracks, screening 24-hour news and selecting leader and growth stocks.
Convert teaching schedules from talent development plan PDFs into structured Excel files, with cross-page tables, merged cells, multi-semester course splitting, major metadata extraction, and batch output.