Today's Agent Skill: Automated Project Status Rollup
What It Does
Every Friday, someone on your team spends 45 minutes hunting through Jira, Slack, and email to write a status update nobody asked for but everyone needs. This skill delegates that entire process to an agent — it pulls from your task manager, recent messages, and calendar to generate a ready-to-send update in under 60 seconds. No more copy-pasting task titles into a doc while wondering what you forgot.
How It Works
The agent queries your connected task management tool for items updated in the past week, scans recent Slack threads or emails tagged to the project, and identifies upcoming milestones from your calendar. It synthesizes these signals into a structured status update segmented by RAG status (Red/Amber/Green), blockers, and next week's priorities — without requiring any manual input beyond the project name.
How to Deploy It
Drop the SKILL.md into your agent's skills directory and trigger it with 'status rollup for [Project Name]' or bind it to a Friday 4pm cron job with the project name as an argument. The agent requires read access to your task manager (Jira, Linear, or Asana), a message source (Slack or email), and a calendar API — all three are optional but improve output fidelity.
SKILL.md — Ready to Deploy
## Description
Automatically generates a project status report by aggregating data from task managers, communication channels, and calendars. Produces a stakeholder-ready update segmented by RAG status, blockers, and upcoming milestones.
## Trigger
- User says: "status rollup for [project]", "weekly update on [project]", or "generate status report"
- Scheduled cron: Friday 4:00 PM local time with project name passed as argument
## Input
- `project_name` (required): Name or ID of the project to report on
- `lookback_days` (optional, default: 7): Number of days to look back for activity
- `format` (optional): "slack" | "email" | "doc" — controls output structure
- `recipients` (optional): Comma-separated list for email format delivery
## Steps
1. Query task manager API for all items in `project_name` updated within `lookback_days`
2. Categorize tasks by status: completed, in-progress, blocked, not-started
3. Identify items flagged as blockers or marked overdue
4. Pull calendar events tagged to `project_name` in the next 14 days to surface upcoming milestones
5. Optionally scan the last 50 Slack messages or emails in the project channel for context not captured in tasks
6. Assign oCopy the full SKILL.md and drop it into your agent's skills directory to activate this skill.