Gog

openclaw/openclaw/skills/gog

作者 openclawb0c330d27df4a528f65185cc3e509284d1b218d9無授權條款394K 個星標收錄於 2026年11月20日更新於 2026年11月20日儲存庫今天更新

Google Workspace CLI for Gmail, Calendar, Drive, Contacts, Sheets, and Docs.

AI 產生的概覽

指導使用 gog 命令列工具操作 Gmail、日曆、雲端硬碟、聯絡人、試算表和文件,並包含 OAuth 設定。

功能
提供 gog 谷歌工作區命令列工具的指令範例:搜尋與寄送 Gmail 郵件、建立與更新帶顏色的日曆活動、搜尋雲端硬碟、列出聯絡人、讀寫試算表範圍,以及匯出或檢視文件。也說明一次性 OAuth 設定流程,包括沒有本機瀏覽器的遠端閘道主機、金鑰環設定與診斷方式。並說明純文字與 HTML 郵件內容的寫法,以及腳本化時使用 JSON 與免互動參數的做法。
適用情境
當需要透過 gog 命令列工具讀取或操作用戶的谷歌工作區資料(郵件、日曆、雲端硬碟檔案、聯絡人、試算表或文件)時使用。也適用於驗證失敗、需要在無圖形介面的主機上完成 OAuth 設定或排查問題時。
執行需求
需要 gog 執行檔(可透過 Homebrew 的 gogcli 公式安裝)、Google OAuth 用戶端憑證與已授權帳號、連線至 Google API 的網路,以及金鑰環或檔案式金鑰環(非互動執行需設定 GOG_KEYRING_PASSWORD)。僅為說明文件,不含腳本。

gog

Use gog for Gmail/Calendar/Drive/Contacts/Sheets/Docs. Requires OAuth setup.

Prefer an already-authorized host account: run the requested gog command first. Enter setup only after an authentication error. Never ask for passwords, client secrets, or refresh tokens in chat.

Setup (once)

  • gog auth credentials /path/to/client_secret.json
  • gog auth add [email protected] --services gmail,calendar,drive,contacts,docs,sheets
  • gog auth list

Remote / headless Gateway hosts

When the Gateway host has no local browser display:

  1. Prefer a live callback listener on the Gateway host. From the machine with the browser, forward the exact callback port (ssh -L <port>:127.0.0.1:<port> user@gateway-host), open the authorization URL gog prints, and let the redirect complete on that forwarded port.
  2. When a live listener is unavailable, the operator picks one paste-mode path in a trusted shell on the Gateway host. Callback URLs must never enter chat or agent tool input:
    • --manual: the operator pastes the full redirect URL into gog's interactive prompt.
    • --remote --step 1: prints auth_url (and state_reused) then exits. After browser consent, the operator runs --remote --step 2 --auth-url <callback-url> in the trusted shell. A failed localhost page load after consent is expected.
  3. Keep the same resolved config context across remote steps: GOG_CONFIG_DIR takes precedence over --home, which takes precedence over GOG_HOME. Also preserve --client, services/scopes, redirect URI, and consent options. Matching unexpired manual state may be reused (state_reused=true).
  4. If desktop keyring is unavailable, configure the file backend (gog auth keyring file) and set GOG_KEYRING_PASSWORD in the Gateway environment so non-interactive agent/--no-input runs can read tokens. gog auth doctor reports when the password is missing.
  5. Callback received is not the same as token stored. If token exchange or identity lookup fails behind a proxy, restart from step 1 after the operator approves scoped egress or proxy exceptions for the required Google endpoints. Do not bypass host network policy or reuse failed or expired state.

For diagnostics, inspect every entry reported by gog auth list --check; its exit status does not prove every stored token is valid. Likewise, inspect the status reported by gog auth doctor rather than relying only on its exit code.

Common commands

  • Gmail search: gog gmail search 'newer_than:7d' --max 10
  • Gmail messages search (per email, ignores threading): gog gmail messages search "in:inbox from:ryanair.com" --max 20 --account [email protected]
  • Gmail send (plain): gog gmail send --to [email protected] --subject "Hi" --body "Hello"
  • Gmail send (multi-line): gog gmail send --to [email protected] --subject "Hi" --body-file ./message.txt
  • Gmail send (stdin): gog gmail send --to [email protected] --subject "Hi" --body-file -
  • Gmail send (HTML): gog gmail send --to [email protected] --subject "Hi" --body-html "<p>Hello</p>"
  • Gmail draft: gog gmail drafts create --to [email protected] --subject "Hi" --body-file ./message.txt
  • Gmail send draft: gog gmail drafts send <draftId>
  • Gmail reply: gog gmail send --to [email protected] --subject "Re: Hi" --body "Reply" --reply-to-message-id <msgId>
  • Calendar list events: gog calendar events <calendarId> --from <iso> --to <iso>
  • Calendar create event: gog calendar create <calendarId> --summary "Title" --from <iso> --to <iso>
  • Calendar create with color: gog calendar create <calendarId> --summary "Title" --from <iso> --to <iso> --event-color 7
  • Calendar update event: gog calendar update <calendarId> <eventId> --summary "New Title" --event-color 4
  • Calendar show colors: gog calendar colors
  • Drive search: gog drive search "query" --max 10
  • Contacts: gog contacts list --max 20
  • Sheets get: gog sheets get <sheetId> "Tab!A1:D10" --json
  • Sheets update: gog sheets update <sheetId> "Tab!A1:B2" --values-json '[["A","B"],["1","2"]]' --input USER_ENTERED
  • Sheets append: gog sheets append <sheetId> "Tab!A:C" --values-json '[["x","y","z"]]' --insert INSERT_ROWS
  • Sheets clear: gog sheets clear <sheetId> "Tab!A2:Z"
  • Sheets metadata: gog sheets metadata <sheetId> --json
  • Docs export: gog docs export <docId> --format txt --out /tmp/doc.txt
  • Docs cat: gog docs cat <docId>

Calendar Colors

  • Use gog calendar colors to see all available event colors (IDs 1-11)
  • Add colors to events with --event-color <id> flag
  • Event color IDs (from gog calendar colors output):
    • 1: #a4bdfc
    • 2: #7ae7bf
    • 3: #dbadff
    • 4: #ff887c
    • 5: #fbd75b
    • 6: #ffb878
    • 7: #46d6db
    • 8: #e1e1e1
    • 9: #5484ed
    • 10: #51b749
    • 11: #dc2127

Email Formatting

  • Prefer plain text. Use --body-file for multi-paragraph messages (or --body-file - for stdin).

  • Same --body-file pattern works for drafts and replies.

  • --body does not unescape \n. If you need inline newlines, use a heredoc or $'Line 1\n\nLine 2'.

  • Use --body-html only when you need rich formatting.

  • HTML tags: <p> for paragraphs, <br> for line breaks, <strong> for bold, <em> for italic, <a href="url"> for links, <ul>/<li> for lists.

  • Example (plain text via stdin):

    bash
    gog gmail send --to [email protected] \  --subject "Meeting Follow-up" \  --body-file - <<'EOF'Hi Name,
    Thanks for meeting today. Next steps:- Item one- Item two
    Best regards,Your NameEOF
  • Example (HTML list):

    bash
    gog gmail send --to [email protected] \  --subject "Meeting Follow-up" \  --body-html "<p>Hi Name,</p><p>Thanks for meeting today. Here are the next steps:</p><ul><li>Item one</li><li>Item two</li></ul><p>Best regards,<br>Your Name</p>"

Notes

  • Set [email protected] to avoid repeating --account.
  • For scripting, prefer --json plus --no-input.
  • Sheets values can be passed via --values-json (recommended) or as inline rows.
  • Docs supports export/cat/copy. In-place edits require a Docs API client (not in gog).
  • gog gmail search returns one row per thread; use gog gmail messages search when you need every individual email returned separately.

來源與署名

來源:openclaw/openclaw位於skills/gog提交b0c330d

授權條款: 無授權條款

內容歸原作者所有。SourceWeft 從公開儲存庫中收錄這些內容。

在 README 中新增徽章

向讀者展示該技能已收錄於 SourceWeft,徽章連結到本頁。

「Listed on SourceWeft」徽章預覽
[![Listed on SourceWeft](https://sourceweft.com/badge/skills/gh-openclaw-openclaw-gog-skills-gog-1de9428291128845.svg)](https://sourceweft.com/skills/gh-openclaw-openclaw-gog-skills-gog-1de9428291128845?utm_source=readme&utm_medium=badge)

檢舉或申請下架