Templates / Send weekly Jira sprint reports via Gmail, PDF, Markdown and PostgreSQL

Send weekly Jira sprint reports via Gmail, PDF, Markdown and PostgreSQL

Unknown

by Anas Chahid Ksabi ✓ · 61 views · created 2026-04-06 · Project Management

Unknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.

Community nodes

These come from third-party npm packages. In n8n 3.0 unverified community packages are off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).

Nodes used (11)

PostgresJira SoftwareGmail

What it does

How it works This workflow runs every Monday at 8 AM and automatically monitors your Jira project, measures progress against the active sprint, and delivers a structured report to stakeholders — with zero manual effort. - Fetches updated, created, completed, and due-soon issues from Jira for the past 7 days - Aggregates KPIs: velocity, blocked issues, epic progress, team workload per assignee... - Builds a styled HTML email + a PDF report attachment - Build a Markdown file - Sends everything via Gmail to your configured recipients - Stores all metrics in PostgreSQL for historical tracking and data visualization Set up steps Setup takes around 10–15 minutes. - Connect your Jira, Gmail, and PostgreSQL credentials in n8n - Open the CONFIGURATION NODE node and set your PROJECTKEY, EMAILTO, and JIRABASEURL - On first run, execute the CREATE TABLES node once to initialize the database schema - Activate the workflow — it will trigger automatically every Monday at 8AM - For PDF generation, you need to install a community node PDFMunk, it's a verified node by n8n.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.