Today's Agent Skill: Automated Weekly Status Report

What It Does

Every Friday, knowledge workers lose 30–60 minutes writing status updates that no one fully reads — yet skipping them creates visibility gaps that tank trust. The problem isn't the report itself; it's the manual archaeology of combing through Slack threads, Jira tickets, and calendar events to reconstruct what actually happened. This skill turns that archaeology into a background task.

How It Works

The skill pulls from three sources — a task list or project tracker, a calendar for the reporting period, and optionally a Slack/Teams channel export — then synthesizes them into a structured weekly status report in your org's preferred format. It buckets work into Completed, In Progress, and Blocked, flags anything overdue, and surfaces risks the writer might have normalized into invisibility.

How to Deploy It

Add this skill to any SKILL.md-compatible agent by dropping the SKILL.md content below into your agent's skills directory and triggering it with the phrase 'draft my status report' or on a Friday afternoon cron. Wire it to your task manager export (CSV or API) and optionally point it at a Slack export or calendar ICS for richer context.

SKILL.md — Ready to Deploy

## Description
Generates a structured weekly status report from task data, calendar events, and optional async thread exports. Reduces report-writing time from 30–60 minutes to under 5 minutes of review-and-send.

## Trigger
- User says: "draft my status report", "write my weekly update", "status report for this week"
- Cron: Friday 3:00 PM local time
- Manual: `/weekly-status-report`

## Input
- **Required:** Task list export (CSV, JSON, or plain text) covering the current week — completed, in-progress, and blocked items
- **Optional:** Calendar events for Mon–Fri of the current week (ICS or plain text list)
- **Optional:** Slack/Teams channel export or summary of key threads
- **Optional:** Target audience tone (executive, team-level, or technical)

## Steps
1. Parse the task list. Bucket each item: Completed (done this week), In Progress (started, not done), Blocked (waiting on someone or something), Upcoming (planned for next week).
2. If calendar data is present, extract meetings that represent decisions made, demos given, or stakeholder touchpoints — these become narrative color in the Highlights section.
3. If async thread data is present, scan for decisions, action items as

Copy the full SKILL.md and drop it into your agent's skills directory to activate this skill.

← Back to All Posts | Home — NY AI Tools