n8n Workflow: Capacity Monitoring and Alerting

This n8n workflow provides a framework for monitoring team capacity, potentially from a data source like Google Sheets, and then taking action based on conditions. While the provided JSON is a starting point, it demonstrates the core components for reading data, applying conditional logic, and interacting with external systems like Jira and Gmail.

What it does

This workflow outlines the following steps:

1. Manual Trigger: The workflow is initiated manually, allowing for on-demand execution.
2. Read Data from Google Sheets: It is set up to read data from a Google Sheet, which could contain team capacity information or other relevant metrics.
3. Conditional Logic: An "If" node is included to apply conditional logic to the data retrieved from Google Sheets. This would typically be used to check for specific conditions, such as team over-allocation or capacity thresholds.
4. Jira Interaction (Placeholder): A Jira Software node is present, indicating the intention to interact with Jira. This could involve creating issues, updating tickets, or querying project data based on the conditional logic.
5. Gmail Notification (Placeholder): A Gmail node is included, suggesting the capability to send email notifications. This would likely be used to alert relevant stakeholders (e.g., team leads, project managers) when certain conditions are met (e.g., over-allocation detected).
6. Code Execution (Placeholder): A "Code" node is available for executing custom JavaScript logic, allowing for advanced data manipulation or integration not directly supported by other nodes.
7. Sticky Note: A sticky note is included for documentation purposes within the workflow itself.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: An active n8n instance to import and run the workflow.
• Google Sheets Account: Configured credentials for Google Sheets to read data.
• Jira Software Account: Configured credentials for Jira Software to interact with your Jira instance.
• Gmail Account: Configured credentials for Gmail to send email notifications.

Setup/Usage

1. Import the Workflow: Download the provided JSON and import it into your n8n instance.
2. Configure Credentials:
   • Set up your Google Sheets credentials (OAuth 2.0 recommended) to allow n8n to access your spreadsheets.
   • Configure your Jira Software credentials (e.g., API token or OAuth) to connect to your Jira instance.
   • Set up your Gmail credentials (OAuth 2.0 recommended) to enable sending emails.
3. Customize Nodes:
   • Google Sheets: Configure the "Google Sheets" node to specify the spreadsheet ID, sheet name, and range from which to read your capacity data.
   • If: Update the "If" node with the specific conditions you want to evaluate (e.g., comparing current capacity to a threshold).
   • Jira Software: Customize the "Jira Software" node to perform the desired action (e.g., create an issue, add a comment) based on the "If" node's output.
   • Gmail: Configure the "Gmail" node to specify recipients, subject, and email body for alerts. Use expressions to dynamically include data from previous nodes.
   • Code: If custom logic is required, add your JavaScript code to the "Code" node.
4. Activate the Workflow: Once configured, activate the workflow. You can manually execute it by clicking the "Execute workflow" button in the n8n editor.

Note: The provided JSON is a foundational structure. You will need to fill in the specific details for your Google Sheet, Jira actions, and Gmail notifications based on your monitoring requirements.