Skip to content
Book a demoStart free
Connectors

Trello connector

Set up the Trello connector in Kaivo: authentication, configuration, the 7 BigQuery tables it syncs, and answers to common questions.

Trello connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Trello data into a Google BigQuery warehouse and keeps it up to date automatically. There is no pipeline to build and no infrastructure to run, so you can spend your time analysing your project management data instead of moving it.

Sync your Trello board data into BigQuery with Kaivo to report on cards, lists, and activity across your boards.

CategoryProject Management
AuthenticationAPI key
SetupSelf-service
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Trello account.
  3. Choose which tables to sync.
  4. Wait for the initial sync to finish.
  5. Query your data in BigQuery or your favourite AI or BI tool.

Authenticate with your Trello credentials. You provide:

Field Description
API key
Your Trello API key. See the Trello Power-Ups admin page for instructions on how to generate it.

| | API token |

Your Trello API token. On your API key page (reached from the Trello Power-Ups admin page), click the Token link and authorize the app to generate it.

|

Prerequisites

Trello requires you to register your own Power-Up (developer application) and generate a personal token:

  1. Visit the Trello Power-Ups admin page and create a new Power-Up to obtain your API key.
  2. On the API key page, click the Token link and authorize the app to generate your API token.

Then enter those values below.

Need help? Reach our team via the chat in the bottom-right corner.

When you set up the connector, you provide:

Field Description
Start Date
Any data before this date will not be fetched.

| | Trello Board IDs |

IDs of the boards to replicate data from. If left empty, all boards you have access to will be replicated. This is the 24-character board ID returned by the API, not the short ID from the board URL.

|

Kaivo syncs 7 tables from Trello into a dedicated dataset in your BigQuery warehouse. Click any table to see its columns and types.

actions (71 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING
id_member_creator STRING
data__card__id STRING
data__card__name STRING
data__card__id_short INT64
data__card__short_link STRING
data__card__pos FLOAT64
data__card__desc STRING
data__card__closed BOOL
data__card__id_list STRING
data__list__id STRING
data__list__name STRING
data__list__pos FLOAT64
data__list__closed BOOL
data__board__id STRING
data__board__name STRING
data__board__short_link STRING
data__board__prefs__background STRING
data__old__pos FLOAT64
data__old__desc STRING
data__old__name STRING
data__old__closed BOOL
data__old__id_list STRING
data__old__prefs__background STRING
data__list_before__id STRING
data__list_before__name STRING
data__list_after__id STRING
data__list_after__name STRING
data__member_type STRING
data__id_member_added STRING
data__card_source__id STRING
data__card_source__name STRING
data__card_source__id_short INT64
data__card_source__short_link STRING
data__id_member_inviter STRING
data__method STRING
data__id_member STRING
data__member__id STRING
data__member__name STRING
data__deactivated BOOL
data__text STRING
data__organization__id STRING
data__organization__name STRING
type STRING
date STRING
member_creator__id STRING
member_creator__username STRING
member_creator__activity_blocked BOOL
member_creator__avatar_hash STRING
member_creator__avatar_url STRING
member_creator__full_name STRING
member_creator__id_member_referrer STRING
member_creator__initials STRING
member_creator__non_public_available BOOL
member__id STRING
member__username STRING
member__activity_blocked BOOL
member__avatar_hash STRING
member__avatar_url STRING
member__full_name STRING
member__id_member_referrer STRING
member__initials STRING
member__non_public_available BOOL
limits__reactions__per_action__status STRING
limits__reactions__per_action__disable_at INT64
limits__reactions__per_action__warn_at INT64
limits__reactions__unique_per_action__status STRING
limits__reactions__unique_per_action__disable_at INT64
limits__reactions__unique_per_action__warn_at INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
boards (57 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
name STRING
desc STRING
desc_data STRING
closed BOOL
id_organization STRING
id_enterprise STRING
limits__attachments__per_board__status STRING
limits__attachments__per_board__disable_at INT64
limits__attachments__per_board__warn_at INT64
pinned BOOL
short_link STRING
date_last_activity TIMESTAMP
date_plugin_disable TIMESTAMP
creation_method STRING
ix_update STRING
enterprise_owned BOOL
id_board_source STRING
id STRING
starred BOOL
url STRING
prefs__permission_level STRING
prefs__hide_votes BOOL
prefs__voting STRING
prefs__comments STRING
prefs__invitations STRING
prefs__self_join BOOL
prefs__card_covers BOOL
prefs__is_template BOOL
prefs__card_aging STRING
prefs__calendar_feed_enabled BOOL
prefs__background STRING
prefs__background_image STRING
prefs__background_tile BOOL
prefs__background_brightness STRING
prefs__background_bottom_color STRING
prefs__background_top_color STRING
prefs__can_be_public BOOL
prefs__can_be_enterprise BOOL
prefs__can_be_org BOOL
prefs__can_be_private BOOL
prefs__can_invite BOOL
subscribed BOOL
label_names__green STRING
label_names__yellow STRING
label_names__orange STRING
label_names__red STRING
label_names__purple STRING
label_names__blue STRING
label_names__sky STRING
label_names__lime STRING
label_names__pink STRING
label_names__black STRING
date_last_view TIMESTAMP
short_url STRING
template_gallery STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: boards__prefs__background_image_scaled

Section titled “Subtable: boards__prefs__background_image_scaled”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
width INT64
height INT64
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING
id_member STRING
member_type STRING
unconfirmed BOOL
deactivated BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
cards (45 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING
start STRING
closed BOOL
date_last_activity TIMESTAMP
desc STRING
due_reminder STRING
id_board STRING
id_list STRING
id_short INT64
id_attachment_cover STRING
manual_cover_attachment BOOL
name STRING
pos FLOAT64
short_link STRING
is_template BOOL
badges__attachments_by_type__trello__board INT64
badges__attachments_by_type__trello__card INT64
badges__location BOOL
badges__votes INT64
badges__viewing_member_voted BOOL
badges__subscribed BOOL
badges__fogbugz STRING
badges__check_items INT64
badges__check_items_checked INT64
badges__check_items_earliest_due TIMESTAMP
badges__comments INT64
badges__attachments INT64
badges__description BOOL
badges__due TIMESTAMP
badges__due_complete BOOL
due_complete BOOL
due TIMESTAMP
short_url STRING
subscribed BOOL
url STRING
cover__id_attachment STRING
cover__color STRING
cover__id_uploaded_background STRING
cover__size STRING
cover__brightness STRING
cover__edge_color STRING
cover__shared_source_url STRING
cover__id_plugin STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING
id_value STRING
id_custom_field STRING
id_model STRING
model_type STRING
value__checked STRING
value__date STRING
value__number STRING
value__text STRING
value__option STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING
id_board STRING
name STRING
color STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
checklists (130 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING
id_member_creator STRING
data__old__closed BOOL
data__old__name STRING
data__old__prefs__self_join BOOL
data__old__prefs__permission_level STRING
data__old__due_complete BOOL
data__old__due STRING
data__card__closed BOOL
data__card__id STRING
data__card__name STRING
data__card__id_short INT64
data__card__short_link STRING
data__card__due_complete BOOL
data__card__due STRING
data__board__id STRING
data__board__name STRING
data__board__short_link STRING
data__board__prefs__self_join BOOL
data__board__prefs__permission_level STRING
data__list__id STRING
data__list__name STRING
data__checklist__id STRING
data__checklist__name STRING
data__organization__id STRING
data__organization__name STRING
data__creation_method STRING
type STRING
date STRING
member_creator__id STRING
member_creator__username STRING
member_creator__activity_blocked BOOL
member_creator__avatar_hash STRING
member_creator__avatar_url STRING
member_creator__full_name STRING
member_creator__id_member_referrer STRING
member_creator__initials STRING
member_creator__non_public_available BOOL
name STRING
desc STRING
desc_data STRING
closed BOOL
id_organization STRING
id_enterprise STRING
limits__check_items__per_checklist__status STRING
limits__check_items__per_checklist__disable_at INT64
limits__check_items__per_checklist__warn_at INT64
pinned STRING
short_link STRING
date_last_activity STRING
date_plugin_disable STRING
creation_method STRING
ix_update STRING
enterprise_owned BOOL
id_board_source STRING
starred BOOL
url STRING
prefs__permission_level STRING
prefs__hide_votes BOOL
prefs__voting STRING
prefs__comments STRING
prefs__invitations STRING
prefs__self_join BOOL
prefs__card_covers BOOL
prefs__is_template BOOL
prefs__card_aging STRING
prefs__calendar_feed_enabled BOOL
prefs__background STRING
prefs__background_image STRING
prefs__background_tile BOOL
prefs__background_brightness STRING
prefs__background_color STRING
prefs__background_bottom_color STRING
prefs__background_top_color STRING
prefs__can_be_public BOOL
prefs__can_be_enterprise BOOL
prefs__can_be_org BOOL
prefs__can_be_private BOOL
prefs__can_invite BOOL
subscribed BOOL
label_names__green STRING
label_names__yellow STRING
label_names__orange STRING
label_names__red STRING
label_names__purple STRING
label_names__blue STRING
label_names__sky STRING
label_names__lime STRING
label_names__pink STRING
label_names__black STRING
date_last_view STRING
short_url STRING
template_gallery STRING
check_item_states STRING
due_reminder STRING
id_board STRING
id_list STRING
id_short INT64
id_attachment_cover STRING
manual_cover_attachment BOOL
pos FLOAT64
is_template BOOL
badges__attachments_by_type__trello__board INT64
badges__attachments_by_type__trello__card INT64
badges__location BOOL
badges__votes INT64
badges__viewing_member_voted BOOL
badges__subscribed BOOL
badges__fogbugz STRING
badges__check_items INT64
badges__check_items_checked INT64
badges__check_items_earliest_due STRING
badges__comments INT64
badges__attachments INT64
badges__description BOOL
badges__due STRING
badges__due_complete BOOL
due_complete BOOL
due STRING
cover__id_attachment STRING
cover__color STRING
cover__id_uploaded_background STRING
cover__size STRING
cover__brightness STRING
username STRING
full_name STRING
soft_limit STRING
id_card STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: checklists__prefs__background_image_scaled

Section titled “Subtable: checklists__prefs__background_image_scaled”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
width INT64
height INT64
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING
id_member STRING
member_type STRING
unconfirmed BOOL
deactivated BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id_checklist STRING
state STRING
id_member STRING
id STRING
name STRING
name_data STRING
type STRING
pos FLOAT64
creation_method STRING
due STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
lists (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING
name STRING
closed BOOL
pos FLOAT64
soft_limit INT64
id_board STRING
subscribed BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
organizations (35 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING
name STRING
display_name STRING
desc STRING
domain_name STRING
id_member_creator STRING
invited BOOL
limits__orgs__total_members_per_org__status STRING
limits__orgs__total_members_per_org__disable_at INT64
limits__orgs__total_members_per_org__warn_at INT64
limits__orgs__free_boards_per_org__status STRING
limits__orgs__free_boards_per_org__disable_at INT64
limits__orgs__free_boards_per_org__warn_at INT64
members_count INT64
prefs__permission_level STRING
prefs__board_invite_restrict STRING
prefs__external_members_disabled BOOL
prefs__google_apps_version INT64
prefs__board_visibility_restrict__private STRING
prefs__board_visibility_restrict__org STRING
prefs__board_visibility_restrict__enterprise STRING
prefs__board_visibility_restrict__public STRING
prefs__board_delete_restrict__private STRING
prefs__board_delete_restrict__org STRING
prefs__board_delete_restrict__enterprise STRING
prefs__board_delete_restrict__public STRING
billable_member_count INT64
active_billable_member_count INT64
billable_collaborator_count INT64
url STRING
ix_update STRING
new_license_invite_restrict STRING
new_license_invite_restrict_url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id_member STRING
member_type STRING
unconfirmed BOOL
deactivated BOOL
id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: organizations__prefs__org_invite_restrict

Section titled “Subtable: organizations__prefs__org_invite_restrict”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
users (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING
board_id STRING
username STRING
full_name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where Trello supports it, each sync pulls only new and changed records so it stays fast; otherwise it refreshes the whole table. Every record keeps its original ID, so you won’t get duplicate rows.

How long does the initial sync take for Trello?

Section titled “How long does the initial sync take for Trello?”

It depends on how much history is in your Trello account. Most initial syncs finish within minutes, while large accounts can take a few hours. After that, syncs only fetch new and changed records, so they’re much faster.

Yes. You pick which tables to sync when you set up the connection and can change the selection later. Tables you don’t select are never copied to your warehouse.

What happens when Trello’s schema changes?

Section titled “What happens when Trello’s schema changes?”

New fields are never added automatically. You choose which fields to sync, so data you haven’t selected (sensitive personal data, for example) never lands in your warehouse. When a new field appears, it becomes available for you to add. What happens to removed or renamed fields depends on a table’s sync mode: full-refresh tables always match what’s currently in Trello, so dropped fields disappear, while incremental tables keep their existing columns and history, so an old field stays and newly added fields fill in over time.

How do I handle GDPR or data deletion requests?

Section titled “How do I handle GDPR or data deletion requests?”

Your data lives in your own Kaivo-managed BigQuery warehouse, so the most direct option is to delete or anonymise specific records right in BigQuery. If you delete data in Trello instead, full-refresh tables drop it on the next sync, while incremental tables keep it, so you would remove the row in BigQuery or ask us to run a full refresh. To remove everything, delete the Trello connector in Kaivo and all of its synced data is deleted with it.

Use cards and lists to see how work moves across your boards over time.

Bring actions into BigQuery to track who does what and when.

Group cards by board and member to understand where work is concentrated.

Join cards with actions to measure how long work sits in each list.

Once Trello data lands in your Kaivo-managed BigQuery warehouse, you can explore it with AI tools or any BI tool that connects to BigQuery. Here’s how the most common destinations work with Trello data.

Use Kaivo’s MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →

Microsoft’s BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →

Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →

The premium analytics standard, with native BigQuery integration. Setup guide →

Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →

Connect via Power Query’s BigQuery connector. Setup guide →

Open-source BI tool with strong BigQuery support. Setup guide →

See our pricing page for Trello connector pricing and plan details.

  • ClickUp: Sync ClickUp to BigQuery.
  • GitHub: Sync GitHub to BigQuery.
  • GitLab: Sync GitLab to BigQuery.
  • Harvest: Sync Harvest to BigQuery.
  • Jira: Sync Jira to BigQuery.
  • Kellokortti: Sync Kellokortti to BigQuery.