google-integration（Google 集成）

Google Integration

Complete Google Workspace integration with unified OAuth authentication. One login grants access to Gmail, Google Docs, Google Sheets, Google Calendar, Google Drive, Google Tasks, and Google Slides.

Purpose

Provides a unified interface to Google Workspace services with:

• Single authentication - Login once, use all services
• Shared credentials - One OAuth setup for everything
• Consistent patterns - Same error handling across all services

Included Services

First-Time Setup

New users: Say "connect google" to run the interactive setup wizard.

The wizard guides you through:

1. Creating a Google Cloud project
2. Enabling required APIs
3. Creating OAuth credentials
4. Authenticating with your Google account

Pre-Flight Check (ALWAYS RUN FIRST)

python3 00-system/skills/google/google-master/scripts/check_google_config.py --json

Exit codes:

• 0: Ready - all services available
• 1: Need login - run the login command below
• 2: Missing credentials or dependencies

To authenticate (grants access to ALL services):

python3 00-system/skills/google/google-master/scripts/google_auth.py --login

Quick Start by Service

Gmail

# List recent emails
python3 00-system/skills/google/gmail/scripts/gmail_operations.py list --max 10

# Send email (creates draft first, asks for confirmation)
python3 00-system/skills/google/gmail/scripts/gmail_operations.py send --to "user@example.com" --subject "Hello" --body "Message"

Google Docs

# Read document
python3 00-system/skills/google/google-docs/scripts/docs_operations.py read <document_id>

# Create document
python3 00-system/skills/google/google-docs/scripts/docs_operations.py create "My Document" --content "Initial content"

Google Sheets

# Read data
python3 00-system/skills/google/google-sheets/scripts/sheets_operations.py read <spreadsheet_id> "Sheet1!A1:D10"

# Append rows
python3 00-system/skills/google/google-sheets/scripts/sheets_operations.py append <spreadsheet_id> "Sheet1!A:D" --values '[["New", "Row", "Data"]]'

Google Calendar

# List upcoming events
python3 00-system/skills/google/google-calendar/scripts/calendar_operations.py list --max 10

# Find available slots
python3 00-system/skills/google/google-calendar/scripts/calendar_operations.py find-slots --duration 30 --from "2025-12-16" --to "2025-12-20"

Google Drive

# List files in root
python3 00-system/skills/google/google-drive/scripts/drive_operations.py list

# Upload file
python3 00-system/skills/google/google-drive/scripts/drive_operations.py upload ./local_file.pdf

# Download file
python3 00-system/skills/google/google-drive/scripts/drive_operations.py download <file_id> --output ./downloaded.pdf

Google Tasks

# List tasks
python3 00-system/skills/google/google-tasks/scripts/tasks_operations.py tasks

# Create task
python3 00-system/skills/google/google-tasks/scripts/tasks_operations.py create "Call John" --due 2025-12-20

# Complete task
python3 00-system/skills/google/google-tasks/scripts/tasks_operations.py complete <task_id>

Google Slides

# List presentations
python3 00-system/skills/google/google-slides/scripts/slides_operations.py list

# Create presentation
python3 00-system/skills/google/google-slides/scripts/slides_operations.py create "Q4 Report"

# Export to PDF
python3 00-system/skills/google/google-slides/scripts/slides_operations.py export <presentation_id> ./report.pdf

Structure

google/
├── SKILL.md                          # This file (bundle overview)
├── google-connect/                   # Setup wizard (say "connect google")
│   └── SKILL.md                      # Interactive setup workflow
├── google-master/                    # Shared resources (DO NOT load directly)
│   ├── SKILL.md                      # Documentation for shared resources
│   ├── scripts/
│   │   ├── google_auth.py            # Unified OAuth for all services
│   │   └── check_google_config.py    # Pre-flight validation
│   └── references/
│       ├── setup-guide.md            # Complete setup instructions
│       └── error-handling.md         # Common errors and solutions
├── gmail/
│   ├── SKILL.md                      # Gmail-specific docs
│   └── scripts/gmail_operations.py
├── google-docs/
│   ├── SKILL.md                      # Docs-specific docs
│   └── scripts/docs_operations.py
├── google-sheets/
│   ├── SKILL.md                      # Sheets-specific docs
│   └── scripts/sheets_operations.py
├── google-calendar/
│   ├── SKILL.md                      # Calendar-specific docs
│   └── scripts/calendar_operations.py
├── google-drive/
│   ├── SKILL.md                      # Drive-specific docs
│   └── scripts/drive_operations.py
├── google-tasks/
│   ├── SKILL.md                      # Tasks-specific docs
│   └── scripts/tasks_operations.py
└── google-slides/
    ├── SKILL.md                      # Slides-specific docs
    └── scripts/slides_operations.py

Setup

Prerequisites

pip install google-auth google-auth-oauthlib google-api-python-client

1. Create Google Cloud Project

1. Go to Google Cloud Console
2. Create or select a project
3. Enable APIs: Gmail, Docs, Sheets, Calendar, Drive, Tasks, Slides

2. Create OAuth Credentials

1. Go to APIs & Services > Credentials
2. Create OAuth 2.0 Client ID (Desktop app)
3. Copy the Client ID and Client Secret
4. Add to .env file (at Nexus root): GOOGLE_CLIENT_ID=your-client-id.apps.googleusercontent.com GOOGLE_CLIENT_SECRET=your-client-secret GOOGLE_PROJECT_ID=your-project-id

3. Authenticate

python3 00-system/skills/google/google-master/scripts/google_auth.py --login

This opens a browser to grant permissions for all services at once.

For detailed setup: google-master/references/setup-guide.md

Error Handling

See google-master/references/error-handling.md for:

• Authentication errors (401, 403)
• Rate limiting (429)
• Permission issues
• Token refresh problems

File Locations

Both .env and token file are in .gitignore and will not be committed.

Security Notes

• Credentials (.env file) - in .gitignore, never committed
• Token file (google-token.json) - in .gitignore, never committed
• Each user authenticates with their own Google account