AI Scrum Master Assistant for Project Reporting - n8n Workflow

• Project Managers and Scrum Masters seeking objective, automated daily reports.


• Teams using Asana for task management and Slack for communication.


• Organizations looking to deploy sophisticated AI automation workflows to improve agile practices.


• Technical users interested in utilizing the LangChain Agent n8n node for complex data synthesis.

This sophisticated n8n workflow dramatically streamlines the daily scrum process. Instead of manually compiling status updates, this n8n automation template automatically gathers comprehensive project data—including modified tasks in Asana, current project sections, and recent Slack channel discussions. Critically, it uses an interactive Slack form to solicit direct, structured feedback from team members regarding their sprint progress and blockers. All this diverse data is consolidated and fed into a custom-configured AI agent, powered by the LangChain n8n node, which acts as a Virtual Scrum Master. This agent analyzes the data for bottlenecks, overdue tasks, and risks, generating a professional report with proposed solutions, which is then published back to Slack. This specific n8n workflow ensures efficient, data-driven project oversight every workday.

The n8n workflow is initiated daily at 9:00 AM using the 'Every Workday Trigger', or manually via the 'Manual Trigger' n8n node for testing.

1. Data Initialization: The workflow starts by defining the target slackchannelid and asanaprojectid in a dedicated Set n8n node.


2. Asana Data Collection: It queries Asana for the project sections and retrieves details for all tasks modified since the previous day.


3. Slack Communication Retrieval: It fetches the historical messages from the designated Slack channel for the last 24 hours.


4. Interactive Scrum Collection: The n8n workflow identifies all users in the channel. It uses the 'Loop Over Channel Users' n8n node to iterate, sending a custom form via a direct message (using the Slack Send & Wait n8n node) to each user asking about their sprint status and blockers. The responses are collected.


5. Data Preparation: All collected data streams (Asana sections, modified tasks, channel history, and developer answers) are cleaned and transformed into HTML tables using HTML n8n nodes for optimal input quality for the AI.


6. Data Consolidation: The 'Merge All Sources of Information' n8n node combines the four streams of prepared data into a single payload.


7. AI Analysis: This payload is sent to the 'Virtual Scrum Master' LangChain Agent n8n node, configured with a detailed prompt instructing it to analyze project health, identify issues (blockers, bottlenecks, overdue tasks), and propose solutions. This n8n node utilizes the connected OpenAI model ('o4-mini').


8. Reporting: The final AI-generated summary report is sent back to the team via the Slack n8n node in the designated channel.

To install this n8n workflow, follow these steps:

1. Import the JSON: Copy the provided n8n workflow JSON and import it into your n8n instance.


2. Credential Setup: You must configure credentials for the following services:

1. Configuration Node: Edit the 'Asana Project and Slack Channel' Set n8n node and replace the placeholder values with your actual Slack channel ID and Asana integer project ID.


2. Activate: Ensure the n8n trigger ('Every Workday Trigger') is active and save the n8n workflow. Test it once using the 'When clicking ‘Test workflow’' n8n trigger to verify all connections.

Every Workday Trigger (n8n trigger): Initiates the entire n8n workflow every Monday through Friday at 9:00 AM.
Asana Project and Slack Channel (Set n8n node): Stores configuration variables like slackchannelid and asanaprojectid used throughout the n8n workflow.
Tasks Modified Since Yesterday (Asana n8n node): Retrieves a list of tasks in the specified project that have been modified within the last 24 hours, focusing the analysis on recent activity.
Get Scrum Master Answers (Slack n8n node): An interactive step that uses the Slack sendAndWait operation with a custom form to gather structured feedback (status, blockers) from individual team members.
HTML n8n nodes (e.g., HTML Tasks Modified): Converts the JSON output from source systems (Asana, Slack) into formatted HTML tables, preparing complex data inputs for the AI model's prompt.
Merge All Sources of Information (Merge n8n node): Combines the four separate, prepared data tables (Asana status, Slack history, and developer answers) into one input item for the final AI analysis stage.
Virtual Scrum Master (LangChain Agent n8n node): The core intelligence of this n8n workflow. It uses a specific system prompt to analyze the merged data, identify development bottlenecks and risks, and generate a comprehensive professional report.
Suggested Model: o4-mini (LangChain LM Chat OpenAI n8n node): Provides the necessary large language model connectivity to execute the AI agent's analysis.

• Send Summary to Slack (Slack n8n node): The final action, posting the detailed, AI-generated project status report back to the team channel.