AgentSkillsCN

google-docs-sheets

支持将 Google 文档和 Google 表格（电子表格）导出为 Markdown 文件或直接输出至标准输出。当用户需要提取、下载或导入 Google 文档/表格内容，以进行摘要提炼、数据分析或上下文加载时，此功能尤为实用。在尝试获取 Google Cloud SDK 访问凭据时，优先使用浏览器 OAuth 回退机制。

SKILL.md
--- frontmatter
name: google-docs-sheets
description: Export Google Docs and Google Sheets (spreadsheets) to Markdown files or stdout. Use when asked to fetch, download, or ingest Google Docs/Sheets content for summarization, analysis, or context loading. Tries gcloud ADC first with browser OAuth fallback.
allowed-tools: Bash(uv run:*)

Google Docs & Sheets

Export Google Docs and Google Sheets content as Markdown. Uses Google APIs with read-only scopes, prefers gcloud ADC, and falls back to browser OAuth when needed.

Quick Start

Auth (preferred: gcloud ADC, run by default)

bash
gcloud auth application-default login --scopes=https://www.googleapis.com/auth/drive.readonly,https://www.googleapis.com/auth/spreadsheets.readonly

Google Docs

bash
# Export to stdout
uv run --directory ${CLAUDE_PLUGIN_ROOT}/skills/google-docs-sheets scripts/cli.py docs export <DOC_ID_OR_URL> --stdout

# Export to files (default ./exports when --stdout is not set)
uv run --directory ${CLAUDE_PLUGIN_ROOT}/skills/google-docs-sheets scripts/cli.py docs export <DOC_ID_OR_URL>

# Write to a specific directory
uv run --directory ${CLAUDE_PLUGIN_ROOT}/skills/google-docs-sheets scripts/cli.py docs export <DOC_ID_OR_URL> --output-dir ./exports

# Write and print
uv run --directory ${CLAUDE_PLUGIN_ROOT}/skills/google-docs-sheets scripts/cli.py docs export <DOC_ID_OR_URL> --output-dir ./exports --stdout

Notes:

  • •Export uses HTML -> Markdown conversion and strips images.
  • •Output filename defaults to the Doc title (sanitized) with .md extension.

Google Sheets

bash
# Export all tabs to stdout
uv run --directory ${CLAUDE_PLUGIN_ROOT}/skills/google-docs-sheets scripts/cli.py sheets export <SHEET_ID_OR_URL> --stdout

# Export all tabs to files (default ./exports when --stdout is not set)
uv run --directory ${CLAUDE_PLUGIN_ROOT}/skills/google-docs-sheets scripts/cli.py sheets export <SHEET_ID_OR_URL>

# Export specific tabs
uv run --directory ${CLAUDE_PLUGIN_ROOT}/skills/google-docs-sheets scripts/cli.py sheets export <SHEET_ID_OR_URL> --tab "Summary" --tab "Data"

# Header control
uv run --directory ${CLAUDE_PLUGIN_ROOT}/skills/google-docs-sheets scripts/cli.py sheets export <SHEET_ID_OR_URL> --header-row 2
uv run --directory ${CLAUDE_PLUGIN_ROOT}/skills/google-docs-sheets scripts/cli.py sheets export <SHEET_ID_OR_URL> --no-header

Notes:

  • •Each tab is exported to its own Markdown table.
  • •Output filenames are Spreadsheet Title - Tab Title.md.
  • •If the URL includes gid=..., that tab is selected automatically (unless --tab is used).