Trello

Creating the data source

Once logged into Trello with the account you want to integrate, visit https://trello.com/power-ups/admin/
Click the "New" button to create a new power-up
Fill in the information with the name of the power-up, choose the workspace from which you wish to replicate the data and fill in the fields "Email", "Support Contact" and "Author", then click “Create”
Click the "Create new API Key" button and then again the "Create API Key" button
Store the key generated on the "API Key" field and then choose the option to manually create an API token (it will be located on the right side of the API Key field)
You will be redirected to the token generation page, similar to the image below:
Scroll down the screen a little more, until you find the “Allow” button. Click that button
Your token will be generated similar to the image below. Copy it
With the API Key and Token in hand, log into Kondado > click the CREATE+ button > Data Source > Trello
Fill in the data source information as follows:
1. Name: An internal identification of your data source, for example “Trello Operations Account”
2. API Key: API Key generated in step (5)
3. API Token: Token generated in step (8)
Once the values are filled in, just click on SAVE and your data source is ready to use!

Pipelines

Relationship chart

Click to expand

Boards and Lists

Main object

Campo	Tipo
id	text	[en] Unique identifier of the Board.
idorganization	text	[en] Unique identifier of the Organization. Organizations > > id
name	text	[en] Board name.
board_desc	text
closed	boolean
url	text
datelastactivity	timestamp
datelastview	timestamp
shorturl	text

trello_lists

Campo	Tipo
board_id	text
id	text
idorganization	text
name	text
closed	boolean

Cards and actions

To get custom fields data use the details pipeline

Main object

Campo	Tipo
id	text	[en] Unique identifier of the card.
board_id	text	[en] Identifier of the board to which the card belongs. Boards and Lists > > id
list_id	text	[en] Identifier of the list where the card is located.
closed	boolean	[en] Indicates if the card is archived (true) or active (false).
duecomplete	boolean	[en] Indicates if the card's due date has been marked as complete.
datelastactivity	timestamp	[en] Timestamp of the last activity recorded on the card.
card_desc	text	[en] Detailed description of the card's content or purpose.
due	timestamp	[en] Scheduled date and time for the task associated with the card.
name	text	[en] Title or name of the card.
position	float	[en] Position of the card within the list, used for ordering.
shortlink	text	[en] Unique short link referencing the card.
shorturl	text	[en] Short URL directing to the card in Trello.
url	text	[en] Full URL directing to the card in Trello.

trello_cards__actions

Campo	Tipo
card_id	text
action_id	text	[en] Unique identifier of the action.
action_type	text	[en] Type of action performed (e.g., commentCard, updateCard).
action_date	timestamp	[en] Timestamp when the action was performed.
action_idmembercreator	text	[en] Identifier of the member who performed the action.
action_data_list_id	text
action_data_old_desc	text

trello_cards__labels

Campo	Tipo
card_id	text	[en] Unique identifier of the label.
labels__id	text	[en] Identifier of the board to which the label belongs.
labels__idboard	text	[en] Identifier of the board to which the label belongs.
labels__name	text	[en] Name of the label.
labels__color	text	[en] Color assigned to the label.

Cards and actions: details

This pipeline includes custom fields data but it takes more time to run. If you do not need custom field data, use its non-detail version

Main object

Campo	Tipo
id	text	[en] Unique identifier of the card.
board_id	text	[en] Identifier of the board to which the card belongs. Boards and Lists > > id
list_id	text	[en] Identifier of the list where the card is located.
closed	boolean	[en] Indicates if the card is archived (true) or active (false).
duecomplete	boolean	[en] Indicates if the card's due date has been marked as complete.
datelastactivity	timestamp	[en] Timestamp of the last activity recorded on the card.
card_desc	text	[en] Detailed description of the card's content or purpose.
due	timestamp	[en] Scheduled date and time for the task associated with the card.
name	text	[en] Title or name of the card.
position	float	[en] Position of the card within the list, used for ordering.
shortlink	text	[en] Unique short link referencing the card.
shorturl	text	[en] Short URL directing to the card in Trello.
url	text	[en] Full URL directing to the card in Trello.
custom_field_board1_x	text	[en] A custom text field named X on board 1
custom_field_board1_y	date	[en] A custom text field named Y on board 2
custom_field_board2_z	float	[en] A custom text field named Z on board 2

trello_cards__actions

Campo	Tipo
card_id	text
action_id	text	[en] Unique identifier of the action.
action_type	text	[en] Type of action performed (e.g., commentCard, updateCard).
action_date	timestamp	[en] Timestamp when the action was performed.
action_idmembercreator	text	[en] Identifier of the member who performed the action.
action_data_list_id	text
action_data_old_desc	text

trello_cards__labels

Campo	Tipo
card_id	text	[en] Unique identifier of the label.
labels__id	text	[en] Identifier of the board to which the label belongs.
labels__idboard	text	[en] Identifier of the board to which the label belongs.
labels__name	text	[en] Name of the label.
labels__color	text	[en] Color assigned to the label.

Checklists

Main object

Campo	Tipo
id	text
name	text
idboard	text
idcard	text	Cards and actions > > id
pos	float

trello_checklists__checkItems

Campo	Tipo
checkitems_name	text
checkitems_idchecklist	text
checkitems__due	text
checkitems_pos	float
checkitems_state	text
checkitems_id	text

Organizations

Main object

Campo	Tipo
id	text
displayname	text
name	text

trello_organizations__boards

Campo	Tipo
org_id	text	[en] Unique identifier of the Organization.
board_id	text	[en] Unique identifier of the Board. Boards and Lists > > id

Campo

Tipo

org_id

text

[en] Unique identifier of the Organization.

board_id

text

[en] Unique identifier of the Board.

Boards and Lists > > id

Connect Trello to Kondado

Set up a Trello data source on Kondado by creating a Power-Up, generating API credentials, and configuring the connector.

1

Create a Trello Power-Up

Log into Trello and visit the Power-Up admin page. Click "New" to create a power-up, fill in the name, select your workspace, and complete the required fields (Email, Support Contact, Author), then click Create.

2

Generate API Key and Token

Click "Create new API Key" twice to generate your API Key. Then manually create an API token from the right-side option, scroll down to click "Allow," and copy the generated token.

3

Add Trello as a data source on Kondado

Log into the Kondado platform, go to add data sources, and select Trello. Enter a descriptive Name, paste your API Key and API Token, then click SAVE to finalize the data source setup.

4

Build pipelines with Trello data

Use your connected Trello source to create pipelines that extract boards, lists, cards, actions, labels, and checklists for analysis in your preferred destination.

Frequently asked questions

What Trello data can I extract with Kondado?▼

You can extract organizations, boards, lists, cards, actions, labels, and checklists—including fields like card descriptions, due dates, activity timestamps, and checklist item states. You can then send this data to BI tools, warehouses, or spreadsheets.

Why do I need to create a Power-Up to connect Trello?▼

Trello requires a Power-Up to generate API credentials (API Key and Token). This is Trello's standard authentication flow for third-party integrations like Kondado, ensuring secure access to your workspace data.

What is the difference between the API Key and API Token?▼

The API Key identifies your Power-Up application, while the API Token authorizes access to your specific Trello account data. Both are required to authenticate Kondado's connection to your Trello workspace.

Can I connect multiple Trello workspaces to Kondado?▼

Yes. When creating each Power-Up, select the desired workspace. You can then set up separate Trello data sources in Kondado for each workspace by using their respective API Keys and Tokens.

How can I visualize my Trello data after extraction?▼

After piping Trello data through Kondado, you can visualize it in tools like Google Data Studio, Amazon QuickSight, or other supported platforms to track team productivity and project KPIs.

Written by

Thassyo Pereira·Published 2023-07-17·Updated 2026-04-25