ClickUp

Creating the data source

Adding the data source

Based on ClickUp API documentation

Requirements

Make sure to use an user with admin access to the Workspaces to be replicated

Instructions

Currently ClickUp has two versions: ClickUp 2.0 and ClickUp 3.0. Following you can find the instructions to obtain the API Key in both versions.

Instructions to ClickUp 2.0

1) Log in to your ClickUp account, click on your profile icon on the bottom left and then on "My Settings";

2) On the settings page, on the left bar, look for “Apps”;

3) Search for the “API Token” section and copy the value found – this is the time to generate a first API Token if you don’t have one yet;

4) On the Kondado platform, go to the add new sources page and select the ClickUp data source;

5) Name your data source and, in API Token, paste the value obtained in step 3 and click "SAVE".

Instructions to ClickUp 3.0

1) Log in to your ClickUp account, click on your profile icon on the upper-right corner and then on "Settings";

2) Scroll down and click on the “Apps” section in the sidebar;

3) Search for the “API Token” section and click on “Generate” if you don't have an API token yet, or on “Regenerate” if you already have one. Copy the value displayed in the “API Token” section;

4) On the Kondado platform, go to the add new sources page and select the ClickUp data source;

5) Name your data source and, in API Token, paste the value obtained in step 3 and click "SAVE".

Pipelines

Relationship chart

Click to expand

Folders

Replication type: Full

Relationships:

space_id → Spaces > space_id

Main object

Folders used to group lists within each space.

Campo	Tipo
folder_id	text	[en] Unique folder identifier.
space_id	text	[en] Space that owns the folder. Spaces > > space_id
archived	boolean	[en] Indicates whether the folder is archived.
hidden	boolean	[en] Indicates whether the folder is hidden from users.
name	text	[en] Display name of the folder.
orderindex	float	[en] Folder position within ordering.
override_statuses	boolean	[en] Allows the folder to define its own statuses for lists.
permission_level	text	[en] Permission level granted to access the folder.
task_count	float	[en] Total number of tasks recorded in the folder.

clickup_folders__statuses

Statuses configured specifically for lists within the folder.

Campo	Tipo
folder_id	text	[en] Reference to the owning folder.
color	text	[en] Color defined for the status.
status_id	text	[en] Identifier of the associated status.
orderindex	float	[en] Status position within the folder.
status	text	[en] Name of the status available in the folder.
type	text	[en] Category of the status (e.g., open, closed).

List members

Replication type: Full

Relationships:

list_id → Lists > list_id

Members associated with each ClickUp list.

Campo	Tipo
list_id	text	[en] Identifier of the related list. Lists > > list_id
user_id	text	[en] Identifier of the member user.
username	text	[en] Username displayed in ClickUp.
email	text	[en] Member email address.
color	text	[en] Color used to represent the member.
initials	text	[en] Initials displayed for the member.
profilepicture	text	[en] Profile picture URL for the member.

Lists

Replication type: Full

Relationships:

folder_id → Folders > folder_id

Lists that organize tasks within folders or spaces.

Campo	Tipo
list_id	text	[en] Unique list identifier.
folder_id	text	[en] Folder where the list is located. Folders > > folder_id
archived	boolean	[en] Indicates whether the list is archived.
due_date	timestamp	[en] Due date defined for the list.
name	text	[en] Display name of the list.
orderindex	float	[en] List position in ordering.
override_statuses	boolean	[en] Indicates whether the list uses its own statuses.
permission_level	text
priority_color	text	[en] Color associated with the list standard priority.
priority_priority	text	[en] Textual label of the default priority.
start_date	timestamp	[en] Planned start date for the list.
status_color	text	[en] Color applied to the list main status.
status_hide_label	boolean	[en] Indicates whether the main status label should be hidden.
status__status	text	[en] Name of the main status assigned to the list.
task_count	float	[en] Current number of tasks in the list.

Spaces

Replication type: Full

Relationships:

workspace_id → Workspaces > id

Main object

Organizational spaces configured in ClickUp.

Campo	Tipo
space_id	text	[en] Unique space identifier.
workspace_id	text	[en] Workspace that owns the space. Workspaces > > id
archived	boolean	[en] Indicates whether the space is archived.
multiple_assignees	boolean	[en] Shows whether multiple assignees are allowed for tasks.
name	text	[en] Display name of the space.
private	boolean	[en] Indicates whether the space is private.

clickup_spaces__priorities

Priority settings available within each space.

Campo	Tipo
space_id	text	[en] Reference to the owning space.
color	text	[en] Color displayed for the priority.
priority_id	float	[en] Numeric identifier of the priority.
priorities__orderindex	float	[en] Priority position within ordering.
priorities__priority	text	[en] Name or label of the priority.

clickup_spaces__statuses

Default status list defined for each space.

Campo	Tipo
space_id	text	[en] Reference to the owning space.
status_id	text	[en] Identifier of the configured status.
color	text	[en] Color used to represent the status.
orderindex	float	[en] Ordering position of the status.
status	text	[en] Name of the available status.
type	text	[en] Category of the status (e.g., open, closed).

clickup_spaces___features

Enabled features and keys for each space.

Campo	Tipo
space_id	text	[en] Reference to the owning space.
feature	text	[en] Name of the configured feature.
feature_key	text	[en] Technical key of the feature.
feature_val	boolean	[en] Indicates whether the feature is enabled.

Tasks

Replication type: Incremental

Relationships:

workspace_id → Workspaces > id
creator_id → List members > user_id
folder_id → Folders > folder_id
list_id → Lists > list_id
space_id → Spaces > space_id
tag_creator > tags → List members > user_id
dependency_userid > dependencies → List members > user_id
assignee_id > assignees → List members > user_id
userid > linked_tasks → List members > user_id

Main object

Tasks managed in ClickUp with core metadata.

Campo	Tipo
task_id	text	[en] Unique task identifier.
workspace_id	text	[en] Workspace that owns the task. Workspaces > > id
creator_id	text	[en] User who created the task. List members > > user_id
folder_id	text	[en] Folder that groups the task. Folders > > folder_id
list_id	text	[en] List where the task is registered. Lists > > list_id
space_id	text	[en] Space related to the task. Spaces > > space_id
custom_id	text	[en] Custom identifier configured for the task.
date_closed	timestamp	[en] Date when the task was closed.
date_done	timestamp	[en] Date when the task was marked as done.
date_created	timestamp	[en] Date when the task was created.
date_updated	timestamp	[en] Date of the task most recent update.
start_date	timestamp	[en] Planned start date of the task.
description	text	[en] Text description of the task.
due_date	timestamp	[en] Due date assigned to the task.
name	text	[en] Display title of the task.
orderindex	float	[en] Task position within the list ordering.
parent	text	[en] Parent task when the item is a subtask.
permission_level	text	[en] Permission level applied to the task.
points	float	[en] Point value assigned to the task.
archived	boolean	[en] Indicates whether the task has been archived.
priority_color	text	[en] Color configured for the task priority.
priority_id	text	[en] Identifier of the applied priority.
priority_orderindex	float	[en] Position of the priority within team settings.
priority_priority	text	[en] Name of the priority used by the task.
status__color	text	[en] Color displayed for the task current status.
status__orderindex	float	[en] Position of the current status within the workflow.
status__status	text	[en] Name of the task current status.
status__type	text	[en] Category of the current status (e.g., open, closed).
text_content	text	[en] Consolidated textual content of the task.
time_estimate	float	[en] Estimated time to complete the task (milliseconds).
url	text	[en] Direct link to access the task.

clickup_tasks__tags

Tags applied to tasks.

Campo	Tipo
task_id	text	[en] Reference to the tagged task.
tag_creator	text	[en] User who created the tag. List members > > user_id
tag_name	text	[en] Name of the tag applied.
tag_bg	text	[en] Background color configured for the tag.
tag_fg	text	[en] Text color displayed on the tag.

clickup_tasks__dependencies

Dependencies recorded for tasks.

Campo	Tipo
task_id	text	[en] Task that holds the dependency.
dependency_date_created	timestamp	[en] Date when the dependency was created.
dependency_depends_on	text	[en] Task or element this task depends on.
dependency_type	float	[en] Dependency type (e.g., waiting, blocking).
dependency_userid	text	[en] User who registered the dependency. List members > > user_id

clickup_tasks__assignees

Relationship of task assignees.

Campo	Tipo
task_id	text	[en] Task to which the assignee is linked.
assignee_id	text	[en] User assigned to the task. List members > > user_id

Campo

Tipo

task_id

text

[en] Task to which the assignee is linked.

assignee_id

text

[en] User assigned to the task.

List members > > user_id

clickup_tasks__linked_tasks

Link relationships between tasks.

Campo	Tipo
task_id	text	[en] Primary task that has the linkage.
date_created	timestamp	[en] Date when the link was created.
link_id	text	[en] Identifier of the relationship between tasks.
userid	text	[en] User who created the linkage. List members > > user_id

Tasks: custom fields

Replication type: Incremental

Relationships:

task_id → Tasks > task_id

Custom field values per task.

Campo	Tipo
task_id	text	[en] Task that owns the custom fields. Tasks > > task_id
field_x	text
field_y	timestamp
field_z	float

Tasks: time in status

Replication type: Incremental

Relationships:

task_id → Tasks > task_id

Main object

Time spent in the current status for each task.

Campo	Tipo
task_id	text	[en] Task analyzed for time in status. Tasks > > task_id
current_status_name	text	[en] Name of the current status.
current_status_color	text	[en] Color configured for the current status.
current_status_total_time_by_minute	float	[en] Total time spent in the current status, minutes.
current_status_total_time_since	timestamp	[en] Start moment of the current status period.

clickup_tasks_time_in_status_history

Historical timings per status for each task.

Campo	Tipo
task_id	text	[en] Task referenced by the history record.
status_name	text	[en] Historic status being analyzed.
status_color	text	[en] Color used for that historic status.
status_type	text	[en] Category of the historic status.
total_time_by_minute	float	[en] Time accumulated in that status, minutes.
total_time_since	timestamp	[en] Start moment of the historic period.
orderindex	float	[en] Record order within the historical trail.

Workspaces

Replication type: Full

Workspaces available in the ClickUp account.

Campo	Tipo
id	text	[en] Unique workspace identifier.
name	text	[en] Display name for the workspace.
color	text	[en] Color configured to identify the workspace.
avatar	text	[en] Image or avatar associated with the workspace.

Notes

Part of this documentation was automatically generated by AI and may contain errors. We recommend verifying critical information

Add ClickUp as a data source on Kondado

Connect your ClickUp workspace data to Kondado by generating an API token and configuring the source for your pipelines.

Verify admin access requirements

Ensure you are using a ClickUp user with admin access to the Workspaces you want to replicate, as this is required for successful data extraction.

Generate API token for your ClickUp version

For ClickUp 2.0, go to My Settings → Apps → API Token. For ClickUp 3.0, go to Settings → Apps → Generate/Regenerate API Token. Copy the token value shown.

Add ClickUp source on Kondado platform

On the Kondado platform, navigate to the add new sources page, select the ClickUp data source, name your connection, paste the API Token, and click SAVE to complete the setup.

Review available ClickUp entities and relationships

Familiarize yourself with the data integration schema including Workspaces, Spaces, Folders, Lists, Tasks, and their related sub-entities to plan your pipeline configuration effectively.

Enable required ClickApps before extraction

For Tasks time-in-status data, confirm the Workspace owner or admin has enabled the Total time in Status ClickApp in ClickUp, otherwise this data will not be returned.

Connect ClickUp data to your preferred destination

Once configured, send your ClickUp data to destinations such as BI tools, data warehouses, or spreadsheets for analysis and reporting.

Frequently asked questions

What ClickUp user permission level is required to connect as a data source?▼

You must use a ClickUp user with admin access to the Workspaces you want to replicate. Without admin privileges, the API will not be able to access the necessary workspace data for extraction.

How do I get my ClickUp API token for Kondado?▼

The process depends on your ClickUp version. For ClickUp 2.0: click your profile icon (bottom left) → My Settings → Apps → API Token. For ClickUp 3.0: click your profile icon (upper-right) → Settings → Apps → Generate or Regenerate API Token. Copy the displayed token value and paste it when adding the ClickUp source on Kondado.

Why are custom fields from tasks in folderless lists not returned?▼

This is a known limitation of the ClickUp API integration. Custom fields from tasks located inside folderless lists will not be returned in the data extraction. Consider organizing your tasks within folders if you need these custom fields in your pipeline.

What ClickUp entities and data are available through Kondado?▼

Kondado extracts Workspaces, Spaces (with priorities, statuses, and features), Folders, Lists (with members), Tasks (with tags, dependencies, assignees, linked tasks, custom fields, and time in status), and related sub-entities. Review the relationship chart in the article to understand how these entities connect.

What must be enabled to get time-in-status data for ClickUp tasks?▼

The Total time in Status ClickApp must first be enabled by the Workspace owner or an admin in ClickUp. Without this ClickApp enabled, the time-in-status data will not be available for extraction through Kondado.

Where can I send my ClickUp data after connecting it to Kondado?▼

You can send your ClickUp data to various destinations including BI tools, data warehouses, and spreadsheets. For visualization options, explore data visualization solutions to build dashboards and reports from your ClickUp data.

Written by

Thassyo Pereira·Published 2023-06-08·Updated 2026-06-01