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 PROJECT_KEY, EMAIL_TO, and JIRA_BASE_URL
• 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.