How to Generate Daily Standup Issue Summaries with Pipedream

Workflows > New

Create New Pipedream Workflow

Go to pipedream.com and click Workflows in the left sidebar. Click the green New button in the top right corner. You'll see the workflow builder with an empty trigger step. This creates your automation foundation.

1. 1Click Workflows in the left navigation
2. 2Click the green New button
3. 3Select 'Build a workflow' from the dropdown
4. 4Name it 'Daily Standup Jira Summary'

Trigger Step > Built-in > Schedule

Add Schedule Trigger

Click the trigger step and select 'Schedule' from the built-in triggers list. Set it to run daily at your preferred time before standup. Choose timezone carefully since your team needs this before the meeting starts.

1. 1Click 'Select a trigger' in the workflow
2. 2Choose 'Built-in' from the tabs
3. 3Select 'Schedule' from the trigger list
4. 4Set frequency to 'Daily' and time to 30 minutes before standup

Add Step > Apps > Jira > Search Issues

Connect Jira Account

Click the + button below the trigger to add a new step. Search for 'Jira' and select it. Choose 'Search Issues' as your action since you need to query multiple tickets. Pipedream will prompt you to connect your Jira instance.

1. 1Click the + button below the schedule trigger
2. 2Type 'Jira' in the search box
3. 3Select 'Jira Software Cloud' from results
4. 4Choose 'Search Issues' action
5. 5Click 'Connect Account' and enter your Jira credentials

Jira Step > Configuration

Configure Jira Query for Active Issues

In the JQL field, write a query to find all active issues assigned to your team members. Use assignee filters and status exclusions to get current work items. Include story points and due dates in the fields parameter for better summaries.

1. 1In the JQL Query field, enter: project = YOUR_PROJECT AND assignee is not EMPTY AND status != Done
2. 2Set Max Results to 100
3. 3In Fields, add: assignee,summary,status,duedate,customfield_10016
4. 4Enable 'Expand' and add 'changelog' to track recent changes

Add Step > Code > Run Node.js

Add Code Step to Process Issues

Add a Node.js code step to transform the Jira response into readable summaries grouped by team member. This step handles date parsing, priority sorting, and formatting for Slack display. You'll group issues by assignee and identify urgent items.

1. 1Click + below the Jira step
2. 2Select 'Code' from the options
3. 3Choose 'Run Node.js' action
4. 4Replace the default code with issue processing logic
5. 5Test the step to verify grouping works

Add this Node.js code in your processing step to identify newly assigned issues from the past 24 hours and flag them in the summary. Paste this after the basic issue grouping logic.

// Check for recently assigned issues using changelog
const recentlyAssigned = [];
const yesterday = new Date(Date.now() - 24 * 60 * 60 * 1000);

// Check for recently assigned issues using changelog
const recentlyAssigned = [];
const yesterday = new Date(Date.now() - 24 * 60 * 60 * 1000);

for (const issue of steps.jira.issues) {
  if (issue.changelog && issue.changelog.histories) {
    for (const history of issue.changelog.histories) {
      const changeDate = new Date(history.created);
      if (changeDate > yesterday) {
        const assigneeChanges = history.items.filter(item => 
          item.field === 'assignee' && item.toString
        );
        if (assigneeChanges.length > 0) {
          recentlyAssigned.push({
            key: issue.key,
            summary: issue.fields.summary,
            newAssignee: issue.fields.assignee.displayName,
            changeDate: changeDate
          });
        }
      }
    }
  }
}

// Add 🆕 emoji to newly assigned items in summary
for (const groupedIssue of groupedByAssignee) {
  const newAssignment = recentlyAssigned.find(ra => 
    ra.key === groupedIssue.key
  );
  if (newAssignment) {
    groupedIssue.summary = `🆕 ${groupedIssue.summary}`;
  }
}

Add Step > Apps > Slack > Send Message to Channel

Connect Slack Account

Add another step and select Slack. Choose 'Send Message to Channel' since you want the summary in your standup channel. Connect your Slack workspace and grant the necessary permissions for posting messages.

1. 1Click + below the code step
2. 2Search for 'Slack' and select it
3. 3Choose 'Send Message to Channel' action
4. 4Click 'Connect Account' and authorize Pipedream
5. 5Select your standup channel from the dropdown

Slack Step > Message Configuration

Format Slack Message Content

In the message field, reference the processed data from your code step. Use Slack's block formatting for better readability. Include team member names as headers and list their issues with priority indicators and due dates.

1. 1In the Message field, click 'Use data from previous step'
2. 2Select the formatted summary from your code step output
3. 3Choose 'mrkdwn' for the message format
4. 4Add a header like 'Daily Standup Issues - {{new Date().toDateString()}}'
5. 5Preview the message formatting

Workflow Actions > Test

Test the Complete Workflow

Click the Test button to run your entire workflow manually. Check that Jira returns the expected issues, your code processes them correctly, and Slack receives a well-formatted summary. Fix any field mapping or formatting issues before going live.

1. 1Click the 'Test' button in the top right of the workflow
2. 2Watch each step execute and check for green checkmarks
3. 3Verify the Slack message appears in your channel
4. 4Check that all team members with active issues are included
5. 5Confirm due dates and priorities display correctly

Workflow Actions > Deploy

Deploy the Workflow

Once testing passes, click Deploy to activate the schedule. Pipedream will run this automatically at your configured time each day. The workflow shows as 'Active' with the next scheduled execution time displayed.

1. 1Click the 'Deploy' button after successful testing
2. 2Confirm the deployment in the popup dialog
3. 3Verify the status changes to 'Active'
4. 4Note the next scheduled run time
5. 5Bookmark the workflow URL for easy access