AlekSystem Workflow Detail

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

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...

Rank 60 Verified workflow

Workflow overview

Why this workflow matters

Useful for software delivery and engineering operations. Relevant for managed services and support workflows.

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 AlekSystem 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 AlekSystem.

Best fit

Categories

AI/MLCommunicationDevOpsDocument Ops

Services

PostgresJira SoftwareGmail

Use cases

engineering workflow automationdocument intelligenceemail workflow automation