Weekly Report Setup

Automates weekly report setup by creating folders, finding emails, and downloading attachments.

1|Updated Jul 30, 2025
One-click install
npx skills add https://github.com/karstegg/MarthaVault --skill weekly-report-setup
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: Weekly Report Setup
Source: https://github.com/karstegg/MarthaVault/tree/main/.claude/skills/weekly-report-setup
Command: npx skills add https://github.com/karstegg/MarthaVault --skill weekly-report-setup

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pywin32, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill streamlines the initial, repetitive steps of weekly report generation, such as creating week-specific folders, finding critical emails from key contacts, and downloading all necessary attachments. It saves significant time (15-20 minutes per week) and ensures consistency in setting up the reporting environment.

Core Features & Use Cases

  • Automated Folder Creation: Automatically calculates the current fiscal week and creates the correct "Week XX" folder structure in your Weekly Reports directory.
  • Targeted Email Search: Finds weekly report emails from key contacts (N2, N3, Gloria, S&W, Epiroc BEV) across all Outlook subfolders using robust sender and subject keyword matching.
  • Attachment Download: Downloads all relevant file attachments (skipping inline images) from identified emails directly into the correct week folder, preserving original filenames.
  • N2 HEAL Prep: Saves the N2 email body as a raw text file, preparing it for subsequent AI parsing into a structured HEAL page.
  • Use Case: At the start of each week, a user can simply say "/weekly-report-setup" to Claude. The AI will then automatically set up the week's report folder, find all necessary emails, download attachments, and prepare the N2 HEAL data, saving valuable time and ensuring a consistent start to the reporting cycle.

Quick Start

Set up the weekly report for the current week.

Frequently Asked Questions about Weekly Report Setup

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate weekly report folder creation and email attachment downloads?

Automate weekly report setup by running this Skill to create fiscal week folders, search Outlook for emails from key contacts, download all attachments, and save the N2 email body for parsing. It eliminates 15-20 minutes of manual weekly prep work.

Can I use Python and Outlook COM API to automate email searches and attachment extraction?

Yes. This Skill uses pywin32 to access Outlook's COM API, search multiple subfolders for emails by sender and subject keywords, extract attachments while skipping inline images, and save them with original filenames to your week folder.

What setup do I need before running automated weekly report preparation?

You need Windows, Outlook installed with COM API access, Python 3.7+, the pywin32 dependency, and a pre-existing Weekly Reports directory. The Skill calculates fiscal weeks starting July 1 and creates Week XX folders automatically.

How does the Skill determine which week folder to create?

The Skill reads your existing Weekly Reports directory structure to calculate the current fiscal week number, with Week 1 starting July 1, 2025. It then creates the correctly numbered Week XX folder for that week.

What happens to emails and attachments after the Skill downloads them?

Attachments are saved to the week folder with original filenames preserved. The N2 email body is saved as a raw text file, preparing it for downstream AI parsing into a structured HEAL page format.

Does this Skill work with email providers other than Outlook?

No. This Skill requires Windows and Outlook with COM API access. It cannot work with web-based email providers or other email clients that don't expose the Outlook COM interface.