How to send ClickUp due date reminders to Slack with Pipedream

Workflows > New > Select a Trigger > Cron Scheduler

Create new workflow in Pipedream

Head to pipedream.com and click Workflows in the left sidebar. Hit the New button in the top right corner. You'll see a blank workflow canvas. Click on Select a Trigger at the top of the workflow builder. Choose Cron Scheduler from the trigger list and set it to run daily at your preferred time (9 AM works well for most teams).

1. 1Click Workflows in the left sidebar
2. 2Click the New button in top right
3. 3Click Select a Trigger
4. 4Choose Cron Scheduler from the list
5. 5Set schedule to 0 9 * * * for 9 AM daily

Add Step > Apps > ClickUp > Get Tasks

Connect your ClickUp account

Click the + button below your trigger to add a new step. Search for ClickUp and select it from the apps list. Choose the Get Tasks action from the dropdown. You'll be prompted to connect your ClickUp account - click Connect Account and authorize Pipedream access. Make sure the account you connect has access to all spaces where you want to monitor tasks.

1. 1Click the + button below the trigger
2. 2Search for ClickUp in the apps list
3. 3Select Get Tasks action
4. 4Click Connect Account button
5. 5Authorize Pipedream in the ClickUp popup

ClickUp Step > Configuration

Configure task filtering parameters

In the Get Tasks step, you need to set up the date filtering. Set the Team dropdown to your ClickUp team. Leave List and Folder empty to search across all spaces. In the Due Date section, set due_date_gt to today's date and due_date_lt to tomorrow's date. This creates a 24-hour window of tasks due soon. Set the Statuses field to exclude completed tasks by selecting only active status types.

1. 1Select your team from Team dropdown
2. 2Leave List and Folder fields empty
3. 3Set due_date_gt to current date
4. 4Set due_date_lt to next day date
5. 5Uncheck completed/closed statuses

Add Step > Code

Add code step for date calculation

Click the + button to add another step, then select Code from the step types. This step will dynamically calculate tomorrow's date for the due date filter instead of hardcoding it. In the code editor, you'll write JavaScript that gets today's date, adds 24 hours, and formats it properly for ClickUp's API. This ensures your workflow always checks the correct date range even when running daily.

1. 1Click + button below ClickUp step
2. 2Select Code from step types
3. 3Choose Node.js runtime
4. 4Clear the default code template
5. 5Write date calculation logic

This code goes in the user mapping step to handle email mismatches and prevent failed DM sends. Paste it into the Node.js code step between ClickUp data processing and Slack messaging.

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

export default defineComponent({
  async run({ steps, $ }) {
    const tasks = steps.clickup.return_value.tasks || [];
    const slackUsers = [];
    
    // Manual email mapping for mismatched accounts
    const emailMap = {
      '[email protected]': '[email protected]',
      '[email protected]': '[email protected]'
    };
    
    for (const task of tasks) {
      if (!task.assignees || task.assignees.length === 0) continue;
      
      for (const assignee of task.assignees) {
        const emailToLookup = emailMap[assignee.email] || assignee.email;
        
        try {
          const slackUser = await $.send({
            method: 'GET',
            url: `https://slack.com/api/users.lookupByEmail`,
            headers: {
              'Authorization': `Bearer ${auths.slack.oauth_access_token}`
            },
            params: { email: emailToLookup }
          });
          
          if (slackUser.ok) {
            slackUsers.push({
              slack_id: slackUser.user.id,
              task_name: task.name,
              due_date: new Date(parseInt(task.due_date)).toLocaleDateString(),
              task_url: task.url,
              priority: task.priority?.priority || 'normal'
            });
          } else {
            console.log(`No Slack user found for ${assignee.email}`);
          }
        } catch (error) {
          console.error(`Error looking up ${assignee.email}:`, error.message);
        }
      }
    }
    
    return { users_to_notify: slackUsers };
  }
});

Add Step > Code

Process task assignees and due dates

Add another code step to loop through the tasks returned from ClickUp and extract assignee information. You'll iterate over each task, check if it has assignees, and prepare the data for Slack messaging. The code should handle cases where tasks have multiple assignees and format the due date in a human-readable way. Store each assignee-task pair in an array for the next step.

1. 1Click + button to add new code step
2. 2Reference the ClickUp step data using steps.clickup
3. 3Loop through tasks array
4. 4Extract assignee IDs and usernames
5. 5Format due dates for display

Add Step > Apps > Slack > Send Direct Message

Connect Slack account

Add a new step and select Slack from the apps list. Choose the Send Direct Message action. Click Connect Account and authorize Pipedream to access your Slack workspace. Make sure you grant the chat:write scope so Pipedream can send DMs. You'll also need users:read scope to look up users by their ClickUp email addresses if they don't match exactly.

1. 1Click + button to add Slack step
2. 2Select Send Direct Message action
3. 3Click Connect Account
4. 4Authorize with chat:write permissions
5. 5Verify connection shows green status

Add Step > Code

Map ClickUp users to Slack users

Before sending messages, add a code step to match ClickUp assignees with their Slack user IDs. Use the Slack Web API to search for users by email address since ClickUp provides email but Slack needs user IDs for DMs. Handle cases where emails don't match by logging warnings. This step prevents failed message sends due to user mapping issues.

1. 1Add code step before Slack messaging
2. 2Use Slack users.lookupByEmail API
3. 3Match ClickUp assignee emails to Slack IDs
4. 4Handle mismatched users gracefully
5. 5Return mapped user data

Slack Step > Message Configuration

Configure Slack message content

In the Slack step, set the User field to the mapped Slack user ID from your code step. Write a clear message template that includes the task name, due date, and a link back to ClickUp. Use Slack's markdown formatting to make due dates bold and include emojis for urgency. The message should be concise but contain all the info the assignee needs to take action.

1. 1Set User to the mapped Slack user ID
2. 2Write message template with task details
3. 3Include ClickUp task URL for easy access
4. 4Add due date with bold formatting
5. 5Test message format in preview

Add Step > Code

Add error handling and logging

Wrap your workflow in try-catch blocks to handle API failures gracefully. Add a final code step that logs successful notifications and any errors to Pipedream's built-in logging. This helps debug issues like tasks not being found, users not matching between platforms, or Slack delivery failures. Include the number of reminders sent in your log output.

1. 1Add code step at the end
2. 2Wrap previous steps in error handling
3. 3Log successful message counts
4. 4Log any user mapping failures
5. 5Use console.log for debugging info

Workflow > Test > Deploy

Test and deploy workflow

Click the Test button to run your workflow manually with current data. Check that it finds due tasks correctly and sends test DMs to the right people. Review the logs to make sure date filtering works and user mapping succeeds. Once testing passes, your workflow will automatically run on the schedule you set. Monitor the first few scheduled runs to catch any edge cases.

1. 1Click Test button in top toolbar
2. 2Verify tasks are found correctly
3. 3Check Slack DMs are delivered
4. 4Review execution logs for errors
5. 5Monitor first scheduled runs