google-docs-sheets
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.
When & Why to Use This Skill
This Claude skill enables the seamless export of Google Docs and Google Sheets into Markdown format or stdout. It is designed to streamline the process of fetching, downloading, and ingesting cloud-based document content for AI-powered summarization, data analysis, and context-rich interactions, utilizing secure Google API integrations with flexible authentication options.
Use Cases
- Content Summarization: Quickly ingest lengthy Google Docs to generate concise summaries, extract key action items, or identify main themes without manual copy-pasting.
- Data Analysis: Export specific Google Sheet tabs as Markdown tables to perform complex data reasoning, trend analysis, or financial auditing within the AI conversation.
- Context Loading for Development: Feed technical documentation or project requirements stored in Google Drive directly into the AI's context to improve the accuracy of code generation and architectural advice.
- Documentation Workflow: Convert collaborative Google Doc drafts into clean Markdown files ready for version control in GitHub repositories or deployment via static site generators.
| 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)
gcloud auth application-default login --scopes=https://www.googleapis.com/auth/drive.readonly,https://www.googleapis.com/auth/spreadsheets.readonly
Google Docs
# 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
.mdextension.
Google Sheets
# 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--tabis used).