AI Agent Hub
Back to skills
Gog Google Workspace CLI icon

Gog Google Workspace CLI

Development Updated 2026.08.30

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 search can retrieve mail with filters such as newer_than:7d; calendar events lists schedules; drive search finds files; contacts list reads contacts.
  • Read/write: sheets get, sheets update, sheets append, sheets clear, and sheets metadata work with spreadsheet ranges; docs export and docs cat read 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.