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

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.