Automated Sprint Reports from Jira to Stakeholders via Gmail

This n8n workflow automates the process of generating and distributing sprint reports from Jira to relevant stakeholders via email. It's designed to streamline communication, ensuring that everyone is kept up-to-date on project progress without manual intervention.

What it does

This workflow, as defined by its JSON, currently includes the following components:

1. Schedule Trigger: Initiates the workflow at predefined intervals. This is the starting point for the automated process.
2. Jira Software: Connects to Jira, likely to fetch sprint data, issue statuses, or other relevant project information.
3. Edit Fields (Set): A utility node for manipulating or transforming data. This could be used to format Jira data into a digestible report structure.
4. Code: A custom code execution node, likely used for advanced data processing, report generation logic, or dynamic content creation based on the Jira data.
5. Gmail: Sends emails, which would be used to distribute the generated sprint reports to stakeholders.
6. Sticky Note: A documentation node for adding notes or explanations within the workflow itself.

While the connections between these nodes are not explicitly defined in the provided JSON, the presence of these nodes strongly suggests a flow where:

• The workflow is triggered on a schedule.
• It retrieves data from Jira.
• The Jira data is processed and formatted (potentially using the "Edit Fields" and "Code" nodes).
• A report is generated and then sent out via Gmail.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance (self-hosted or cloud).
• Jira Account: Access to a Jira instance with appropriate permissions to read project and sprint data. You will need to configure a Jira credential in n8n.
• Gmail Account: A Gmail account or Google Workspace account configured as a credential in n8n, with permissions to send emails.

Setup/Usage

1. Import the Workflow:
   • Download the provided JSON file.
   • In your n8n instance, go to "Workflows" and click "New".
   • Click the "Import from JSON" button and paste the workflow JSON or upload the file.
2. Configure Credentials:
   • Locate the "Jira Software" node and configure your Jira credentials. This typically involves providing your Jira URL, username, and an API token.
   • Locate the "Gmail" node and configure your Google OAuth2 credentials. This will allow n8n to send emails on your behalf.
3. Customize Nodes:
   • Schedule Trigger: Adjust the schedule to your desired frequency (e.g., weekly, bi-weekly) for sending sprint reports.
   • Jira Software: Configure this node to fetch the specific sprint data, issues, or project information you need for your reports. You'll likely specify the project, board, and sprint ID.
   • Edit Fields (Set): Customize this node to transform the raw Jira data into a structured format suitable for your report.
   • Code: If present, review and modify the JavaScript code to implement your specific report generation logic, data aggregation, or dynamic content.
   • Gmail: Configure the recipient email addresses, subject line, and email body. You will likely use expressions to dynamically insert data from previous nodes into the email content.
4. Activate the Workflow: Once configured, activate the workflow to enable it to run automatically on its defined schedule.