How to Send Sprint Completion Summaries with Pipedream

Workflows > New

Create new workflow in Pipedream

Go to pipedream.com and click Workflows in the left sidebar. Click the green New button to create a workflow. Name it 'ClickUp Sprint Summary to Slack' and click Create. You'll land on the workflow builder with an empty trigger step ready.

1. 1Click Workflows in the left sidebar
2. 2Click the green New button
3. 3Enter 'ClickUp Sprint Summary to Slack' as the name
4. 4Click Create to open the builder

Step 1 > Select App > ClickUp

Add ClickUp webhook trigger

Click on Step 1 to configure the trigger. Search for 'ClickUp' in the app list and select it. Choose 'New Webhook Event' as your trigger type. This creates an instant webhook that ClickUp will ping when events happen in your workspace.

1. 1Click on Step 1 to open the trigger configuration
2. 2Type 'ClickUp' in the app search box
3. 3Select ClickUp from the results
4. 4Choose 'New Webhook Event' as the trigger

Step 1 > Connect Account

Connect your ClickUp account

Click 'Connect Account' and sign into ClickUp when prompted. Grant Pipedream access to your workspace. Select the specific workspace where your sprints live from the dropdown. The webhook will only receive events from this workspace.

1. 1Click the Connect Account button
2. 2Sign into ClickUp in the popup window
3. 3Click Allow to grant permissions
4. 4Select your target workspace from the dropdown

ClickUp Settings > Integrations > Webhooks

Configure webhook events in ClickUp

Copy the webhook URL from Pipedream. In ClickUp, go to your workspace settings and find Integrations. Click Webhooks and paste the Pipedream URL. Check 'Task Status Updated' and 'List Updated' events to catch sprint completion triggers.

1. 1Copy the webhook URL from the Pipedream step
2. 2Open ClickUp and go to Settings > Integrations
3. 3Click Webhooks and then Add Webhook
4. 4Paste the URL and select Task Status Updated and List Updated events

Step 1 > + > Node.js Code

Add sprint completion filter step

Click the + button below Step 1 to add a new step. Choose 'Run Node.js Code' from the options. This code step will filter incoming webhooks to only process sprint completion events. You'll check if the webhook contains sprint-related data before proceeding.

1. 1Click the + button below the ClickUp trigger
2. 2Select 'Run Node.js Code' from the step options
3. 3Name this step 'Filter Sprint Completion'
4. 4Click Continue to open the code editor

Step 2 > Code Editor

Write sprint detection logic

Replace the template code with logic to detect sprint completion. Check if the webhook event relates to a list or folder marked as a sprint, and if tasks have been moved to 'complete' status. Use steps.trigger.event to access webhook data from ClickUp.

1. 1Clear the existing template code
2. 2Add logic to check webhook event type
3. 3Filter for sprint-related list changes
4. 4Add conditions for completion detection

Step 2 > + > ClickUp > Get Tasks in List

Add ClickUp API step to fetch tasks

Add another step by clicking the + button. Search for ClickUp again and select 'Get Tasks in List' action. This will pull all tasks from the completed sprint so you can count completed vs incomplete items for your summary.

1. 1Click + below the filter step
2. 2Search for and select ClickUp
3. 3Choose 'Get Tasks in List' action
4. 4Use the same Connected Account from Step 1

Step 3 > Configuration

Configure task retrieval parameters

Set the List ID using data from your webhook trigger - reference steps.trigger.event.list_id. Configure filters to include all task statuses so you get both complete and incomplete tasks. Set include_closed to true to capture everything in the sprint.

1. 1Set List ID to steps.trigger.event.list_id
2. 2Enable include_closed parameter
3. 3Leave status filters empty to get all tasks
4. 4Set page limit to 100 for complete results

Step 3 > + > Node.js Code

Add summary calculation step

Add another Node.js code step to process the task data. Loop through all returned tasks and count how many are in 'complete' vs 'incomplete' status. Calculate percentages and build the summary message text that will go to Slack.

1. 1Click + to add another code step
2. 2Name it 'Calculate Sprint Summary'
3. 3Reference steps.get_tasks_in_list.tasks for task data
4. 4Add logic to count completed vs total tasks

Step 4 > + > Slack > Send Message to Channel

Add Slack message step

Click + to add a final step and search for Slack. Select 'Send Message to Channel' action. Connect your Slack workspace when prompted. Choose the channel where sprint summaries should appear - typically a dev or project updates channel.

1. 1Click + below the calculation step
2. 2Search for and select Slack
3. 3Choose 'Send Message to Channel'
4. 4Connect your Slack workspace account

Step 5 > Message Configuration

Configure Slack message format

Set the channel to your sprint updates channel. Reference the summary data from Step 4 to build your message. Include sprint name, completion percentage, and task counts. Use Slack formatting like *bold* for emphasis and bullet points for readability.

1. 1Select your target channel from the dropdown
2. 2Reference steps.calculate_sprint_summary for message text
3. 3Add sprint name from webhook data
4. 4Format with Slack markdown for better visibility

This Node.js code goes in Step 4 (Calculate Sprint Summary) to build a formatted Slack message with task breakdown and team mentions.

export default defineComponent({
  async run({ steps, $ }) {
    const tasks = steps.get_tasks_in_list.tasks || [];

export default defineComponent({
  async run({ steps, $ }) {
    const tasks = steps.get_tasks_in_list.tasks || [];
    
    // Count task statuses
    const completed = tasks.filter(task => 
      task.status?.status === 'complete' || 
      task.status?.status === 'closed'
    ).length;
    
    const total = tasks.length;
    const incomplete = total - completed;
    const percentage = total > 0 ? Math.round((completed / total) * 100) : 0;
    
    // Extract sprint info
    const sprintName = steps.trigger.event.list?.name || 'Sprint';
    const teamMembers = [...new Set(
      tasks.map(task => task.assignees?.[0]?.username).filter(Boolean)
    )];
    
    // Build Slack message
    const message = `*${sprintName} Complete!* 🎉\n\n` +
      `✅ Completed: ${completed} tasks (${percentage}%)\n` +
      `❌ Incomplete: ${incomplete} tasks (${100-percentage}%)\n` +
      `👥 Team: ${teamMembers.map(u => `@${u}`).join(', ')}\n\n` +
      `${percentage >= 80 ? 'Outstanding work! 🚀' : 'Good progress made! 💪'}`;
    
    return {
      message,
      completed,
      total,
      percentage,
      sprint_name: sprintName
    };
  }
});