ClickUp

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 open the relationship chart

Workspaces

Field	Type
id	text
name	text
color	text
avatar	text

Spaces

Main object

Field	Type
space_id	text
workspace_id	text
archived	boolean
multiple_assignees	boolean
name	text
private	boolean

priorities

Field	Type
space_id	text
color	text
priority_id	float
priorities__orderindex	float
priorities__priority	text

statuses

Field	Type
space_id	text
status_id	text
color	text
orderindex	float
status	text
type	text

_features

Field	Type
space_id	text
eature	text
feature_key	text
feature_val	boolean

Folders

Main object

Field	Type
folder_id	text
space_id	text
archived	boolean
hidden	boolean
name	text
orderindex	float
override_statuses	boolean
permission_level	text
task_count	float

statuses

Field	Type
folder_id	text
color	text
status_id	text
orderindex	float
status	text
type	text

Lists

Field	Type
list_id	text
folder_id	text
archived	boolean
due_date	timestamp
name	text
orderindex	float
override_statuses	boolean
permission_level	text
priority__color	text
priority__priority	text
start_date	timestamp
status__color	text
status__hide_label	boolean
status__status	text
task_count	float

Lists members

Field	Type
list_id	text
user_id	text
username	text
email	text
color	text
initials	text
profilepicture	text

Tasks

Main object

Campo	Tipo
task_id	text
workspace_id	text	Workspaces > > id
creator_id	text	List members > > user_id
folder_id	text	Folders > > folder_id
list_id	text	Lists > > list_id
space_id	text	Spaces > > space_id
custom_id	text
date_closed	timestamp
date_done	timestamp
date_created	timestamp
date_updated	timestamp
start_date	timestamp
description	text
due_date	timestamp
name	text
orderindex	float
parent	text
permission_level	text
points	float
archived	boolean
priority_color	text
priority_id	text
priority_orderindex	float
priority_priority	text
status__color	text
status__orderindex	float
status__status	text
status__type	text
text_content	text
time_estimate	float
url	text

clickup_tasks__tags

Campo	Tipo
task_id	text
tag_creator	text	List members > > user_id
tag_name	text
tag_bg	text
tag_fg	text

clickup_tasks__dependencies

Campo	Tipo
task_id	text
dependency_date_created	timestamp
dependency_depends_on	text
dependency_type	float
dependency_userid	text	List members > > user_id

clickup_tasks__assignees

Campo	Tipo
task_id	text
assignee_id	text	List members > > user_id

clickup_tasks__linked_tasks

Campo	Tipo
task_id	text
date_created	timestamp
link_id	text
userid	text	List members > > user_id

Tasks: custom fields

Field	Type
task_id	text
field_x	text
field_y	timestamp
field_z	float

Custom fields from tasks inside folderless lists will not be returned

Tasks: time in status

The Total time in Status ClickApp must first be enabled by the Workspace owner or an admin

Main object

Field	Type
task_id	text
current_status_name	text
current_status_color	text
current_status_total_time_by_minute	float
current_status_total_time_since	timestamp

status_history

Field	Type
task_id	text
status_name	text
status_color	text
status_type	text
total_time_by_minute	float
total_time_since	timestamp
orderindex	float

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.

1

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.

2

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.

3

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.

4

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.

5

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.

6

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-04-25