paulpas Google Docs Automation
Orchestrates intelligent skill selection and execution for google docs automation workflows. Applies the 5 Laws of Elegant Defense to guide data naturally through the orchestration pipeline, preventing errors before they occur. Selects optimal skills based on multi-factor scoring including text similarity, historical performance, and system availability.
TL;DR Checklist
- Parse all inputs at boundary before processing (Law 2)
- Handle edge cases with early returns at function top (Law 1)
- Fail immediately with descriptive errors on invalid states (Law 4)
- Return new data structures, never mutate inputs (Law 3)
- Implement minimum 2-level fallback chain for all skill executions
- Log all skill selections with context for full audit trail
- Validate skill metadata and dependencies before selection
- Update confidence scores after each execution for learning
┌───────────────────────────────────────────────────────────────────────────────┐ │ Orchestration Flow │ └───────────────────────────────────────────────────────────────────────────────┘
User Request ↓ ┌─────────────────┐ │ Parse Request │ │ & Extract │ │ Features │ └────────┬────────┘ ↓ ┌─────────────────────────────────────────────────────────────────────┐ │ Evaluate Available Skills │ │ │ │ ┌──────────────┐ ┌──────────────┐ ┌──────────────┐ │ │ │ Skill A │ │ Skill B │ │ Skill C │ │ │ │ - Match Score│ │ - Match Score│ │ - Match Score│ │ │ │ - Confidence │ │ - Confidence │ │ - Confidence │ │ │ │ - History │ │ - History │ │ - History │ │ │ └──────┬───────┘ └──────┬───────┘ └──────┬───────┘ │ │ │ │ │ │ │ └─────────────────┴─────────────────┘ │ │ ↓ │ │ Select Best Skill │ └─────────────────────────────────────────────────────────────────────┘ ↓ ┌─────────────────┐ │ Execute Skill │ └────────┬────────┘ ↓ ┌─────────────────┐ │ Handle Result │ └────────┬────────┘ ↓ ┌─────────────────────────────────────────────────────────────────────┐ │ Error Handling & Fallback │ │ │ │ Success? ────────► Return Result │ │ │ │ Fail? ────────┐ │ │ ↓ │ │ ┌──────────────────────────────────────────────────────────┐ │ │ │ Fallback Chain │ │ │ │ │ │ │ │ 1. Retry with adjusted parameters │ │ │ │ 2. Try Alternative Skill (if available) │ │ │ │ 3. Defer to Human Operator (if critical) │ │ │ │ 4. Log & Return Error │ │ │ └──────────────────────────────────────────────────────────┘ │ └─────────────────────────────────────────────────────────────────────┘
When to Use
Use this skill when:
- Orchestrating multi-step workflows that require skill delegation
- Implementing adaptive skill routing based on confidence scores
- Building fallback mechanisms for failed skill executions
- Creating intelligent task decomposition and parallel execution
- Designing skill dependency graphs with automatic resolution
- Implementing skill selection with historical performance weighting
- Building agent systems that need to self-organize around tasks
When NOT to Use
Avoid this skill for:
- Direct task execution without orchestration needs - use individual skills instead
- High-frequency trading scenarios where latency must be minimized - the selection overhead may be prohibitive
- Simple linear workflows without branching or fallback requirements
- Cases where skill metadata is unavailable or unreliable
Core Workflow
Parse and Analyze Request - Extract intent, entities, and constraints from user input. Checkpoint: All required parameters must be present and in valid format before proceeding.
Score Available Skills - Calculate match scores using multi-factor algorithm:
- Text similarity between request and skill triggers
- Historical success rate for similar tasks
- Skill availability and health status
- Required dependencies and their availability
Checkpoint: Skip to fallback if no skill scores above threshold.
Select Optimal Skill - Choose skill with highest score that meets minimum confidence. Checkpoint: Verify skill has not been disabled or deprecated.
Execute with Fallback - Run skill execution wrapped in retry and fallback logic. Checkpoint: Log all execution attempts for audit trail.
Return or Fallback - Either return successful result or apply fallback chain:
- Retry with adjusted parameters
- Try alternative skill from
related-skills - Defer to human operator for critical tasks
Checkpoint: Record outcome with timing and confidence metadata.
Implementation Patterns
Pattern 1: Skill Selection Logic
def parse_google_docs_request(
user_input: str,
existing_docs: List[Dict],
auth_credentials: Dict
) -> Dict:
"""Parse natural language request into Google Docs API operations.
Extracts intent (create, update, extract, format), identifies target document,
and maps user instructions to specific Docs API methods (batchUpdate, create, get).
Args:
user_input: Natural language instruction (e.g., "Add a table to Q3 report")
existing_docs: List of available document metadata with IDs and permissions
auth_credentials: OAuth2 service account or user credentials
Returns:
Structured operation payload ready for API execution
"""
# Guard clause - validate input and auth (Law 1)
if not user_input or not auth_credentials.get("access_token"):
raise ValueError("Missing user input or authentication credentials")
# Parse intent and target document (Law 2)
intent = _classify_intent(user_input) # create, update, extract, format
target_doc = _resolve_document_id(user_input, existing_docs)
if not target_doc:
if intent == "update":
raise ValueError("Target document not found for update operation")
target_doc = {"id": None, "title": _extract_title(user_input)}
# Map to Google Docs API operations (Law 3)
operations = []
if intent == "create":
operations.append({
"createDocument": {"title": target_doc["title"]}
})
elif intent == "update":
operations.extend(_build_batch_update_ops(user_input, target_doc["id"]))
elif intent == "extract":
operations.append({
"get": {"documentId": target_doc["id"], "fields": "body.content"}
})
return {
"intent": intent,
"target_doc_id": target_doc["id"],
"operations": operations,
"credentials": auth_credentials,
"timestamp": time.time()
}
Pattern 2: Execution with Fallback
def execute_docs_operation(
operation_payload: Dict,
max_retries: int = 3,
fallback_strategy: str = "retry_then_create"
) -> Dict:
"""Execute Google Docs API operations with domain-specific resilience.
Handles Docs API rate limits, permission errors, and batch update failures.
Implements exponential backoff for quota limits and falls back to
alternative document operations when primary action fails.
Args:
operation_payload: Parsed request containing operations and credentials
max_retries: Maximum retry attempts for transient API errors
fallback_strategy: Fallback behavior when primary operation fails
Returns:
API response with document ID, operation status, and metadata
"""
from googleapiclient.discovery import build
from googleapiclient.errors import HttpError
docs_service = build("docs", "v1", credentials=operation_payload["credentials"])
operations = operation_payload["operations"]
for attempt in range(max_retries):
try:
# Execute batch update or create operation
if operation_payload["intent"] == "create":
response = docs_service.documents().create(
body={"title": operation_payload["target_doc_id"]}
).execute()
else:
response = docs_service.documents().batchUpdate(
documentId=operation_payload["target_doc_id"],
body={"requests": operations}
).execute()
return {
"success": True,
"document_id": response.get("documentId", operation_payload["target_doc_id"]),
"operations_executed": len(operations),
"latency_ms": time.time() * 1000,
"attempt": attempt + 1
}
except HttpError as e:
status_code = e.resp.status
if status_code == 429: # Quota exceeded
wait_time = (2 ** attempt) + random.uniform(0, 1)
time.sleep(wait_time)
continue
elif status_code == 403:
raise PermissionError(f"Access denied to document: {e.reason}")
elif status_code == 404 and fallback_strategy == "retry_then_create":
# Fallback: Create new doc if update fails due to missing resource
if attempt == max_retries - 1:
return _create_fallback_document(operation_payload)
time.sleep(0.5)
raise RuntimeError(f"Docs operation failed after {max_retries} attempts")
MUST DO
- Always validate skill metadata before selection (Early Exit)
- Implement fallback chain with at least 2 levels (Fallback Skill + Human)
- Log all skill selections with full context for auditability
- Return new data structures instead of mutating inputs (Atomic Predictability)
- Fail immediately with descriptive errors on invalid states
- Update confidence scores after each execution for adaptive routing
- Reference
code-philosophy(5 Laws of Elegant Defense) in all logic
MUST NOT DO
- Select skills based on a single factor (e.g., only confidence score)
- Disable fallback mechanisms "temporarily" - this creates fragile systems
- Skip validation of skill dependencies before execution
- Return partial results - either complete success or clear failure
- Use magic numbers for confidence thresholds - make them configurable
- Cache skill selections without considering context changes
TL;DR Checklist
- Parse all inputs at boundary before processing (Law 2)
- Handle edge cases with early returns at function top (Law 1)
- Fail immediately with descriptive errors on invalid states (Law 4)
- Return new data structures, never mutate inputs (Law 3)
- Implement minimum 2-level fallback chain for all skill executions
- Log all skill selections with context for full audit trail
- Validate skill metadata and dependencies before selection
- Update confidence scores after each execution for learning
TL;DR for Code Generation
- Use guard clauses - return early on invalid input before doing work
- Return simple types (dict, str, int, bool, list) - avoid complex nested objects
- Cyclomatic complexity < 10 per function - split anything larger
- Handle null/empty cases explicitly at function top (Early Exit)
- Never mutate input parameters - return new dicts/objects
- Fail fast with descriptive errors - don't try to "patch" bad data
- Reference code-philosophy laws in comments for complex logic
- Include timing and confidence metadata in all return values
Output Template
When applying this skill, produce:
- Selected Skills - List of skill names with confidence scores
- Selection Rationale - Why each skill was chosen (match score, history, availability)
- Execution Plan - Order of execution with dependencies
- Fallback Strategy - Which fallback skills will be tried and in what order
- Risk Assessment - Any potential failure points and their impact
- Timing Estimates - Expected latency including fallback scenarios
Related Skills
| Skill | Purpose | |
Constraints
MUST DO
- Implement idempotent automation triggers: running the same automation twice should not create duplicate resources or actions
- Validate all trigger conditions with explicit allowlists before executing automated actions
- Include rollback procedures in every automation workflow — every CREATE should have a corresponding DELETE capability
- Log all automation executions with input state, output state, duration, and any errors for monitoring and debugging
MUST NOT DO
- Do not create circular automation loops where trigger A causes action B which triggers A again
- Avoid using automations that modify production data without explicit human approval gates
- Never embed API keys or credentials directly in automation workflows — use vaulted secrets with rotation
- Do not assume external service availability; implement retry logic with exponential backoff and dead-letter queues
Live References
Authoritative documentation links for this skill's domain. The model follows markdown links at load time to resolve external references and inline content.