ClickUp

ClickUp is a project management platform where teams track tasks, manage workflows, log time, and organize work across spaces, folders, and lists. Connecting ClickUp to Coupler.io lets you pull that data into spreadsheets, BI tools, or AI assistants — without manual exports.

Why connect ClickUp to Coupler.io?

• Export tasks, time tracking, goals, and team data to Google Sheets, BigQuery, Power BI, Looker Studio, Excel, or AI tools like ChatGPT, Claude, or Gemini

• Combine multiple ClickUp entities (e.g., Tasks + Time Trackings) using Join or Append transformations to build richer reports

• Keep your dashboards and reports up to date with scheduled syncs

• Access custom fields from lists and teams as structured columns in your destination

Prerequisites

• A ClickUp account with access to the workspaces you want to export

• A ClickUp personal API token (found in your ClickUp profile settings)

• Coupler.io account (free plan available)

Coupler.io pulls data based on your personal API token. You'll only see spaces, tasks, and users that your ClickUp account has permission to access. Private spaces or tasks shared with other members won't appear unless your account has explicit access.

Quick start

Start with the Tasks entity — it's the most data-rich ClickUp entity and the most common starting point for project reporting.

1

Get your ClickUp API token. In ClickUp, click your avatar in the bottom-left corner, go to Settings, then scroll to Apps. Click Generate (or copy your existing token) under Personal API Token.

2

Create a new data flow in Coupler.io. Go to your Coupler.io dashboard and click Add data flow. Search for and select ClickUp as the source.

3

Enter your API token. Paste your ClickUp personal API token into the connection field and click Connect.

4

Select an entity. Choose the data you want to export — for example, Tasks, Time Trackings, or Team Goals. You can add more entities to the same data flow later.

5

Choose a destination. Select where you want your data to land — Google Sheets, BigQuery, Power BI, Excel, Looker Studio, or an AI destination like ChatGPT or Claude.

6

Run your data flow. Click Run to execute a manual sync. Once it completes successfully, your data will appear in the destination.

Available entities

Entity	What it contains
Tasks	Task details, statuses, assignees, due dates, priorities
Time Trackings	Time entries logged against tasks
Time Tracking Tags	Tags used in time tracking entries
Users	Workspace members and their details
Teams	Workspace/team structure
Spaces	Top-level spaces in a workspace
Folders	Folders within spaces
Lists	Lists within folders or spaces
List Custom Fields	Custom field definitions for lists
Team Custom Fields	Custom field definitions for teams
Space Tags	Tags defined at the space level
Team Goals	Goals tracked at the team level
List Comments	Comments on lists