Agent Skills

---
name: weekly-sales-summary
description: Generate a weekly sales performance summary from Google Sheets data.
icon: chart-line
color: Green
related_server_ids: [gsheets, slack]
---

---
name: weekly-sales-summary
description: Generate a weekly sales summary from the team spreadsheet.
  Use when the user asks for sales numbers, weekly summary, or
  team performance update.
related_server_ids: [gsheets, slack]
---

## Steps
1. Run: python3 scripts/generate_summary.py
2. Review the printed output
3. Post the summary to the #sales Slack channel (or present to the user)

import json, os
from gumcp_client import Client

def get_client():
    return Client(
        user_id=os.getenv("GUMCP_USER_ID"),
        gumcp_api_key=os.getenv("GUMCP_API_KEY"),
        base_url=os.getenv("GUMCP_BASE_URL"),
    )

with get_client() as client:
    # Read the raw data from your team spreadsheet
    raw = client.call_tool(
        "gsheets__read_spreadsheet",
        dict(spreadsheet_id="1ABC...", range="Sales!A1:F100")
    )
    data = json.loads(raw[0])
    rows = data.get("values", [])

    # Process with Python — exact math, no guessing
    total_revenue = sum(float(r[3]) for r in rows[1:])
    top_rep = max(rows[1:], key=lambda r: float(r[3]))

    print("Total revenue: $" + format(total_revenue, ",.2f"))
    print("Top performer: " + top_rep[0] + " ($" + format(float(top_rep[3]), ",.2f") + ")")

import json, os
from gumcp_client import Client

def get_client():
    return Client(
        user_id=os.getenv("GUMCP_USER_ID"),
        gumcp_api_key=os.getenv("GUMCP_API_KEY"),
        base_url=os.getenv("GUMCP_BASE_URL"),
    )

with get_client() as client:
    raw = client.call_tool(
        "gdocs__read_document",
        dict(document_id="1XYZ...")
    )
    content = json.loads(raw[0])

    # Parse the document text with Python
    lines = content.get("text", "").split("\n")
    action_items = [l for l in lines if l.strip().startswith("- [ ]")]

    for item in action_items:
        print(item)