Automated Sprint Reports from Jira to Stakeholders via Gmail — n8n Workflow

Medium complexity⏰ Scheduled7 nodes🏷️ Project Management👁 289 viewsby Yassin Zehar

Overview

Description

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.

Context

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 Frida

Nodes used

Jira SoftwareGmailCode

Workflow Preview

Required
• Jira Cloud project (API email + API token)
• Gmail credential
1) Trigger and Normalize
Trigger: Scheduled run (e.g., every Friday at 17:00)
Data Processing:
- Fetch issues from Jira with JQL: project = <KEY> AND
- Select relevant fi
2) Calculate Metrics
Action: Aggregate data into KPIs
Key Metrics:
- Issues by status (To Do / In Progress / Done)
- Story points: completed vs total
- Blockers count (priority = High / label = b
3) Generate Report & Send Notification
Action: Build an HTML report
Contents:
- Sprint name + dates
- Metrics overview (done vs total issues, SP, blockers)
- Table of all issues (key, summary, st
Email notification
Get many issues
⚡
W
Weekly trigger
J
Jira & email configuration
Validation & error handl…
Metrics calculation
HTML report generation
7 nodes6 edges

How it Works

  1. 1

    Trigger

    The workflow starts with a scheduled trigger, running on a defined schedule.

  2. 2

    Process

    Data flows through 7 nodes, connecting code, gmail, jira.

  3. 3

    Output

    The workflow completes its automation and delivers the result to the configured destination.

Node Details (7)

JI

Jira Software

jira

#1
GM

Gmail

gmail

#2
CO

Code

code

#3

How to Import This Workflow

  1. 1Click Download JSON button on the right to save the workflow file.
  2. 2Open your n8n instance. Go to Workflows → New → Import from file.
  3. 3Select the downloaded automated-sprint-reports-from-jira-to-stakeholders-via-gmail file and click Import.
  4. 4Set up credentials for each service node (API keys, OAuth, etc.).
  5. 5Click Test Workflow to verify everything works, then activate it.

Or paste directly in n8n → Import from JSON:

{ "name": "Automated Sprint Reports from Jira to Stakeholders via Gmail", "nodes": [...], ...}

Integrations

codegmailjirascheduletriggerset

Get This Workflow

Download and import in one click

Download JSONView on n8n.io
Nodes7
Complexitymedium
Triggerscheduled
Views289
CategoryProject Management

Created by

Yassin Zehar

Yassin Zehar

@yassinzehar

Tags

codegmailjirascheduletriggerset
⚡

New to n8n?

n8n is a free, open-source workflow automation tool. Self-host it or use the cloud version.

Get n8n Free →