google-docs-collaboration

Files (5)

• CHANGELOG.md
• LICENSE
• README.md
• SKILL.md
• authenticate.py · scripts/

SKILL.md (first lines)

# Google Docs Collaboration

Comprehensive Google Workspace document integration enabling programmatic creation, editing, and management of Docs, Sheets, and Slides through their respective APIs.

## Quick Start

When asked to work with Google Docs, Sheets, or Slides:

1. **Authenticate**: Set up OAuth2 credentials (one-time setup)
2. **Create documents**: Generate Docs, Sheets, or Slides
3. **Read content**: Extract text, data, or presentation content
4. **Edit documents**: Update content programmatically
5. **Format**: Apply styling and formatting
6. **Collaborate**: Manage sharing and comments

## Prerequisites

### One-Time Setup

**1. Enable APIs:**
```bash
# Visit Google Cloud Console
# https://console.cloud.google.com/

# Enable these APIs:
# - Google Docs API
# - Google Sheets API
# - Google Slides API
# - Google Drive API (for file operations)
```

**2. Create OAuth2 Credentials:**
```bash
# In Google Cloud Console:
# APIs & Services > Credentials > Create Credentials > OAuth client ID
# Application type: Desktop app
# Download credentials as credentials.json
```

**3. Install Dependencies:**
```bash
pip install google-auth google-auth-oauthlib google-auth-httplib2 google-api-python-client --break-system-packages
```

**4. Initial Authentication:**
```bash
python scripts/authenticate.py
# Opens browser for Google sign-in
# Saves token.json for future use
```

See [reference/setup-guide.md](reference/setup-guide.md) for detailed setup.

## Google Docs Operations

### Create Documents

**Create blank Doc:**
```bash
# New document
python scripts/create_doc.py --title "Project Proposal"

# With initial content
python scripts/create_doc.py \
  --title "Meeting Notes" \
  --content-file template.txt
```

**Create from template:**
```bash
# Copy template and customize
python scripts/create_from_template.py \
  --template-id TEMPLATE_DOC_ID \
  --title "Q4 Report" \
  --replacements "{{date}}:2025-01-20,{{author}}:John Smith"
```

### Read Documents

**Get document content:**
```bash
# Read as text
python scripts/read_doc.py --doc-id DOC_ID

# Get structured content
python scripts/get_doc_structure.py --doc-id DOC_ID --output doc.json

# Export as different format
python scripts/export_doc.py --doc-id DOC_ID --format pdf --output report.pdf
python scripts/export_doc.py --doc-id DOC_ID --format docx --output report.docx
```

**Extract specific elements:**
```bash
# Get headings only
python scripts/extract_headings.py --doc-id DOC_ID

# Get tables
python scripts/extract_tables.py --doc-id DOC_ID

# Get images
python scripts/extract_images.py --doc-id DOC_ID --output ./images/
```

### Edit Documents

**Append content:**
```bash
# Add text to end
python scripts/append_doc.py \
  --doc-id DOC_ID \
  --text "New paragraph content"

# Add formatted content
python scripts/append_doc.py \
  --doc-id DOC_ID \
  --content-file content.json
```

From astoreyai/claude-skills, MIT.

More from astoreyai/claude-skills