Today's Agent Skill: Automated Weekly Status Report Rollup
What It Does
Office workers spend hours every week manually stitching together updates from email, Slack, and project trackers into a status report nobody enjoys writing. This agent skill automates that rollup, turning scattered signals into a ready-to-send report in minutes instead of an afternoon.
How It Works
The skill pulls raw activity from each connected source over a set date range, deduplicates overlapping mentions of the same task or decision, and sorts everything into Completed, In Progress, Blocked, and Upcoming buckets. It then drafts a formatted report with a one-line headline summary up top, prioritizing anything tied to a deadline, dollar amount, or explicit ask from a stakeholder.
How to Deploy It
Drop the SKILL.md file into any agent's skills directory (for example, ~/.claude/skills/status-report-rollup/SKILL.md), giving the agent read access to whichever source tools you want it to query. Trigger it manually with a phrase like 'pull my status report,' or wire it to a weekly scheduled task so the finished report lands before your next check-in.
SKILL.md — Ready to Deploy
## Description
Consolidates scattered updates from email threads, project trackers, and chat channels into a single weekly status report ready for a manager or client — no manual copy-pasting across five different tools.
## Trigger
Run on a weekly schedule (e.g., Friday afternoon), or on-demand when the user says "pull my status report," "compile this week's update," or "draft my weekly rollup."
## Input
- Date range (defaults to the last 7 days)
- List of source channels/tools to pull from (email inbox, project tracker export, Slack/Teams export, calendar)
- Optional: target audience (manager, client, exec) to adjust tone and level of detail
## Steps
1. Gather raw updates from each connected source within the date range.
2. Deduplicate items that reference the same task, decision, or thread across multiple sources.
3. Classify each item into one of four buckets: Completed, In Progress, Blocked, Upcoming.
4. Flag any item mentioning a deadline, dollar amount, or explicit stakeholder ask — these get priority placement near the top of their section.
5. Draft the report using the standard output format below, matching tone and density to the target audience.
6. Write a one-line "heCopy the full SKILL.md and drop it into your agent's skills directory to activate this skill.