Project 01
Jira Weekly Reporting Automation
ImplementedSee the automation in action.
The animation could not be loaded. Please try again.
Problem to solve
Preparing weekly team updates required manually reviewing Jira tickets and compiling progress across projects, operational tasks, and change requests. This tool automates that collection and produces a consistent report.
Thought process — how I approached it
The approach was to turn Jira activity into a report that follows how the team discusses its work. The tool retrieves tickets for configured team members, captures ongoing work and items closed within the previous seven days, and groups them into completed changes, changes in progress, projects, and business-as-usual tasks. It includes owners, statuses, descriptions, and selected latest comments, then exports a dated text report. Packaging it as a Windows executable makes it easier to run without a separate Python installation.
Applications used
- Python
- Jira Cloud REST API
- JQL
- Requests
- JSON configuration
- PyInstaller
Earlier versions also included HTML reports and Gmail/email experiments.
AI used — tools and how they helped
No AI integration or documented AI development assistance was found in the code. Any use of ChatGPT, Copilot, or another assistant during development has not been confirmed.