How to Send ClickUp Due Date Reminders to Slack with Power Automate

My flows > + New flow > Scheduled cloud flow

Create a Scheduled Cloud Flow

Navigate to make.powerautomate.com and sign in with your Microsoft account. Click 'My flows' in the left sidebar, then the blue '+ New flow' button. Select 'Scheduled cloud flow' from the dropdown menu. Name it 'ClickUp Due Date Reminders' and set it to run daily at your preferred time.

1. 1Click 'My flows' in the left navigation
2. 2Click the blue '+ New flow' button
3. 3Select 'Scheduled cloud flow'
4. 4Enter flow name: 'ClickUp Due Date Reminders'
5. 5Set recurrence to 'Day' with interval of 1

Flow designer > + New step > HTTP

Add ClickUp Connection

Click '+ New step' below the recurrence trigger. Search for 'HTTP' in the connector search box and select 'HTTP' action. ClickUp doesn't have a native Power Automate connector, so we'll use their REST API. Set the method to GET and enter the ClickUp API base URL.

1. 1Click '+ New step' under the recurrence trigger
2. 2Type 'HTTP' in the search box
3. 3Select the 'HTTP' action
4. 4Set Method dropdown to 'GET'
5. 5Keep URI field empty for now

HTTP action > Show advanced options > Headers

Configure ClickUp API Authentication

In the HTTP action, click 'Show advanced options'. Add a new header by clicking 'Add new parameter' and selecting 'Headers'. Create a header with key 'Authorization' and value 'Bearer YOUR_API_TOKEN'. Replace YOUR_API_TOKEN with your actual ClickUp API token from ClickUp Settings > Apps > API Token.

1. 1Click 'Show advanced options' in the HTTP card
2. 2Click 'Add new parameter'
3. 3Check the 'Headers' checkbox
4. 4In the Headers field, enter key: Authorization
5. 5Enter value: Bearer YOUR_CLICKUP_API_TOKEN

HTTP action > URI field

Set Up ClickUp Tasks Query

In the URI field of the HTTP action, enter the ClickUp API endpoint to get tasks. Use this URL format: https://api.clickup.com/api/v2/team/TEAM_ID/task with query parameters for due dates. Add another header 'Content-Type' with value 'application/json' to ensure proper API communication.

1. 1Click in the URI field
2. 2Enter: https://api.clickup.com/api/v2/team/YOUR_TEAM_ID/task
3. 3Add query parameter: ?due_date_gt=TODAY
4. 4Add query parameter: &due_date_lt=TOMORROW
5. 5Add Content-Type header with value: application/json

Flow designer > + New step > Data Operations > Compose

Add Date Calculations for Due Date Filter

We need to replace TODAY and TOMORROW with actual timestamps. Click '+ New step' and add a 'Compose' action from Data Operations. In the Inputs field, click the expression tab and enter utcnow() to get today's date. Add another Compose action for tomorrow using addDays(utcnow(),1). These will generate the Unix timestamps ClickUp expects.

1. 1Click '+ New step' before the HTTP action
2. 2Search for 'Compose' and select it
3. 3Click in Inputs field, then Expression tab
4. 4Enter: formatDateTime(utcnow(),'yyyy-MM-dd')
5. 5Add second Compose action for tomorrow's date

HTTP action > + New step > Data Operations > Parse JSON

Configure Parse JSON for ClickUp Response

Add a 'Parse JSON' action after the HTTP call to structure ClickUp's response. In the Content field, select 'body' from the HTTP action output. For the Schema, you'll need ClickUp's task object structure. Click 'Use sample payload to generate schema' and paste a sample JSON response from ClickUp's API documentation.

1. 1Click '+ New step' after the HTTP action
2. 2Select 'Parse JSON' from Data Operations
3. 3Set Content to 'body' from HTTP action
4. 4Click 'Use sample payload to generate schema'
5. 5Paste ClickUp task JSON sample from their API docs

Parse JSON > + New step > Control > Apply to each

Add Apply to Each for Task Processing

Since ClickUp returns multiple tasks, add an 'Apply to each' control to process each task individually. In the 'Select an output from previous steps' field, choose 'tasks' from the Parse JSON output. This creates a loop that will process every task with an upcoming due date.

1. 1Click '+ New step' after Parse JSON
2. 2Search for 'Apply to each' in Control actions
3. 3Select 'Apply to each'
4. 4Click the input field
5. 5Select 'tasks' from Parse JSON dynamic content

Apply to each > + Add an action > Control > Apply to each

Extract Task Assignee Information

Inside the Apply to each loop, add another 'Apply to each' for assignees since ClickUp tasks can have multiple assignees. Select 'assignees' from the current task item. This nested loop ensures every assigned person gets notified for each task they're responsible for.

1. 1Click '+ Add an action' inside the first Apply to each
2. 2Select 'Apply to each' again
3. 3Set the input to 'assignees' from current item
4. 4This creates a nested loop for multiple assignees

Inner Apply to each > + Add an action > HTTP

Add Slack User Lookup

Before sending DMs, we need to find Slack user IDs from ClickUp usernames. Add an HTTP action to call Slack's users.lookupByEmail API. Set the method to POST, use https://slack.com/api/users.lookupByEmail as the URI, and add Authorization header with 'Bearer YOUR_SLACK_BOT_TOKEN'.

1. 1Click '+ Add an action' in the assignee loop
2. 2Select HTTP action
3. 3Set Method to POST
4. 4URI: https://slack.com/api/users.lookupByEmail
5. 5Add Authorization header with Slack bot token

User lookup HTTP > + Add an action > HTTP

Send Slack Direct Message

Add another HTTP action to send the DM using Slack's chat.postMessage API. Set method to POST, URI to https://slack.com/api/chat.postMessage. In the body, include the channel (user ID from previous step), and a formatted message with task name and due date. Use JSON format with proper Content-Type header.

1. 1Add another HTTP action
2. 2Set Method to POST
3. 3URI: https://slack.com/api/chat.postMessage
4. 4Set Content-Type header to application/json
5. 5Build JSON body with channel, text, and task details

Add this expression in a Compose action to format ClickUp's Unix timestamp into a readable date for your Slack messages. Place it after parsing the ClickUp response and reference it in your message text.

formatDateTime(
  addToTime(
    '1970-01-01T00:00:00.000Z',

formatDateTime(
  addToTime(
    '1970-01-01T00:00:00.000Z',
    int(items('Apply_to_each')?['due_date']),
    'Second'
  ),
  'MMM dd, yyyy'
)