Today's Agent Skill: Auto-Generate Your Weekly Status Report
What It Does
Writing Friday's status report burns 20–40 minutes most people don't have — and it usually starts with scrolling back through a week of emails and calendar entries just to remember what happened. Most of that reconstruction work is mechanical, not analytical. An agent can do the mechanical part so you show up to writing with the outline already done.
How It Works
The skill queries your calendar for the past 7 days, scans sent emails and completed tasks for accomplishments, and clusters the results by project tag or meeting topic. It outputs a structured draft — this week's wins, blockers encountered, and a next-week preview — ready to paste into whatever reporting format your org uses.
How to Deploy It
Drop the SKILL.md into your agent's skills directory and trigger it each Friday by typing 'generate status report', or wire it to a cron that fires at 4 PM every Friday. The skill works with any calendar MCP and email integration already in your stack.
SKILL.md — Ready to Deploy
## Description
Generates a structured weekly status report by aggregating calendar events, sent emails, and completed tasks from the prior 7 days. Clusters activity by project, surfaces blockers, and drafts a next-week preview — eliminating manual reconstruction time.
## Trigger
User types: `generate status report`, `weekly update`, `friday report`, or `status update`
## Input
- Date range: today minus 7 days to today (auto-computed)
- Optional: list of project names or team tags for clustering
- Optional: report format preference (bullet list, paragraph, Confluence template)
## Steps
1. Query calendar MCP for all events in the past 7 days. Filter out declined and personal events.
2. Extract meeting titles, attendees, and any attached notes or action items.
3. Scan sent email folder for messages sent in the same window. Pull subject lines and recipient domains.
4. Retrieve completed tasks from task manager (if connected) or infer from email threads marked resolved.
5. Cluster results by project tag or recurring meeting series.
6. Identify blockers: meetings rescheduled 2+ times, unresolved threads, tasks flagged as stuck.
7. Draft next-week preview from calendar events already sCopy the full SKILL.md and drop it into your agent's skills directory to activate this skill.