Automated workflow that generates a Sprint Report from Jira and delivers it by Gmail.
The flow fetches sprint issues from Jira, validates and normalizes the data, calculates metrics (tickets, story points, blockers, completion rate), generates an HTML report, and sends it by email.
This template helps teams keep stakeholders updated automatically of the current sprint.
Instead of manually compiling Jira data, the report is generated and sent on schedule (e.g., every Friday at 17:00).
It’s production-friendly, reusable, and works across Jira projects.
Scrum Masters and Agile Coaches who need sprint reports for retrospectives.
Product Owners who want a weekly overview of sprint progress.
Project Managers tracking Jira delivery KPIs.
Engineering teams wanting automated status reporting without extra overhead.
Jira Cloud project + API email + API token + permission to read issues.
Gmail credential for notifications.
Trigger – Schedule (e.g., Friday at 17:00).
Edit Fields – Configure Jira base URL, project key, email recipients.
Get Many Issues – Fetch sprint issues with JQL (project = <KEY> AND sprint in openSprints()).
Validation & Normalization – Clean/validate fields (status, assignee, priority, story points, sprint info).
Metrics Calculation – Aggregate KPIs (done, in progress, blockers, story points, completion %).
HTML Report Generation – Build a styled email-friendly HTML summary + detailed table.
Send Gmail – Deliver report to stakeholders.
Automated Sprint Reports: No manual copy-paste.
Metrics overview: Tickets done vs total, blockers, story points.
Detailed table: Issue key, summary, status, assignee, priority, SP.
Email delivery: HTML report with Jira links sent to stakeholders.
Fully customizable: Adjust fields, KPIs, and recipients easily.
📊 HTML Sprint Report with KPIs and issue table.
✅ Email delivered to stakeholders via Gmail.
🔗 Jira links embedded for easy navigation.
⏰ Trigger – Runs on schedule (e.g., every Friday at 17:00).
🧾 Fetch Issues – JQL filters sprint tickets.
📊 Metrics – Done vs total, SP progress, blockers.
💻 Generate HTML – Clean, styled table and summary.
✉️ Notify – Send Gmail with full sprint report to stakeholders.
Watch the Youtube Tutorial video
I'm Yassin, IT Project Manager, Agile & Data specialist. Scaling tech products with data-driven project management.
📬 Feel free to connect with me on Linkedin