Automate Jira Summaries with OpenAI & Email via Gmail/Sendy

Streamline Jira Summaries with OpenAI and Effortless Email Dispatch

Transform your Jira project management process by automating the generation and distribution of summaries. This powerful n8n workflow leverages OpenAI to create concise HTML summaries from Jira issues and distributes them via Gmail and Sendy simultaneously. Optimize productivity by effortlessly transitioning completed tasks and keeping your teams in the loop.

What This Workflow Does

• Fetch and Aggregate: Manually trigger the workflow to pull all "Completed" issues from Jira using the specified JQL query, consolidating them into a single list for efficient processing.
• Generate Summaries: Send the aggregated list of Jira tickets to OpenAI, which produces a clean, comprehensive HTML table summarizing each issue’s key details such as summary, description, and last updated date.
• Email Dispatch: The generated HTML summaries are sent via Gmail and kicked off as a Sendy email campaign, ensuring smooth parallel dissemination to your chosen recipients.
• Status Update: Once emails are successfully dispatched, each Jira ticket is transitioned from "Completed" to "Completed Updated Sent Out" status, reflecting accurate task evolution.

Use Cases

• Project Management Efficiency: Ideal for project managers who need to keep teams updated with the latest task completions without manual tracking or report creation.
• Automated Reporting: Perfect for SaaS operators and automation engineers looking to automate their reporting workflows and ensure data consistency across platforms.
• Streamlined Communication: Useful for teams utilizing both Gmail and Sendy, this workflow ensures cohesive communication strategies, reaching your intended audience effectively through preferred channels.

Technical Details

• Nodes Utilized: Jira, OpenAI, Gmail, Sendy
• Requirements: Jira Software Cloud credential, OpenAI credential (e.g., using the 'gpt-5-mini' model), Gmail OAuth2 credential, and Sendy API details.
• Components: Incorporates code nodes for processing and aggregation nodes to manage data transitions seamlessly.