Back to Blog

Connect Trello to Google Sheets and Automate Data Import

According to the Trello Getting Started Guide, you have two options for exporting data from a Trello board: 

  • Export as CSV (available for Business Class and Enterprise users only)
  • Export as JSON

Neither of the above will pull your Trello data directly into a spreadsheet; you’ll need to make additional manipulations anyway. However, there is a tool that connects Trello to Google Sheets right away and imports data automatically. Read on to learn how it works.

How to set up Trello – Google Sheets integration

Coupler.io is an integration solution to sync Google Sheets with different data sources, such as Trello, Airtable, Xero, Clockify, and many more. Install Coupler.io from the Google Workspace Marketplace

Alternatively, you can install Coupler.io right from the Add-ons menu of your spreadsheet. For more about the tool and available importers, visit the Coupler.io integration page.

Set up a JSON Client importer

Now, you need to set up a Trello to Google Sheets integration. We’ll use the JSON Client importer to connect to Trello. Go to the Add-ons menu => Coupler.io => Open dashboard. Click +Add Importer and select JSON Client

Select JSON Client from the list and complete following steps to connect Google Sheets to Trello:

Title

Name your Trello JSON to Google Sheets integration.

Source

Insert the JSON URL to import data from. The JSON URL will change depending on the data to be imported. For example, here is the JSON URL to pull a particular Trello board:

https://api.trello.com/1/boards/{board-ID}?key={API-key}&token={server-token}

And here is the JSON URL to import checklists on a card:

https://api.trello.com/1/cards/{card-id}/checklists?key={API-key}&token={server-token}
  • ?key={API-key}&token={server-token} is the authentication string, which you’ll need to get an API key and a server token for. This, as well as JSON URLs to pull versatile data entities, are introduced in the section, JSON URL parameters to import Trello data.

Destination

Set up the Destination parameters:

  • Destination account – a Google account to connect to.
  • Sheet name – add the name of the sheet that will be receiving data.

Click Show Advanced to expand an optional parameter – Cell address. This lets you specify the first cell where the JSON data will be imported to.

Settings

In the Settings section, you can enable Automatic data refresh. Customize the schedule for automatic data exports from JSON API to Google Sheets. For more about the optional parameters in the Settings section, refer to the Coupler.io knowledge base

Once the parameters are inserted, click Save & Run to pull data to a spreadsheet.

What data you can export from Trello to Google Sheets

Trello to Google Sheets integration parameters

Let’s check out how it works. As an example, we’ll import Cards on a Trello board. Here is JSON URL sample for this:

https://api.trello.com/1/boards/{board-id}/cards?key={API-key}&token={server-token}
  • You’ll find {board-id} in the Menu => More => Link to this board 

Or simply in the URL bar:

Example: 

key=cfd453b9d2dfe5321137gdb3465c7og
  • {server-token} – to generate a server token, click Token on the Developer API Keys page and allow access for the server token. 

Example: 

token=23dch4dte21a8daf3et1fch546de712css341g24cb6dcd6ca

Replace {API-key} and {server-token} with your values. Here is how the authentication string will look:

?key=cab036d2y4svd4326313stda3424f5cc&token=32db21df543v6asd4mn1fdc543ss143fge111d32fs4ges7cc12a4dsbvc2af12f

And here is the ready-to-use JSON URL:

https://api.trello.com/1/boards/UTwMSVOS/cards?key=cfd453b9d2dfe5321137gdb3465c7og&token=23dch4dte21a8daf3et1fch546de712css341g24cb6dcd6ca

Click Save & Run and the Trello data will be imported into Google Sheets.

JSON URL parameters to import Trello data

The basic Trello REST API URL is 

https://api.trello.com

You should attach it with a resource of a respective Trello data entity. 

Boards

Data entityResource to attach to the basic JSON URL
Import a Board/1/boards/{board-id}?key={API-key}&token={server-token}
Import Boards in an Organization/1/organizations/{organization-id}/boards?key={API-key}&token={server-token}
Import boardStars on a Board/1/boards/{board-id}/boardStars?key={API-key}&token={server-token}

Cards

Data entityResource to attach to the basic JSON URL
Import a Card on a Board/1/boards/{board-id}/cards/{idCard}?key={API-key}&token={server-token}
Import Cards on a Board/1/boards/{board-id}/cards?key={API-key}&token={server-token}
Import filtered Cards on a Board/1/boards/{board-id}/cards/{filter}?key={API-key}&token={server-token}
Import filtered Cards on a Board/1/boards/{board-id}/cards/{filter}?key={API-key}&token={server-token}
Import a Card/1/cards/{card-id}?key={API-key}&token={server-token}
Import Attachments on a Card/1/cards/{card-id}/attachments?key={API-key}&token={server-token}
Import the Board the Card is on/1/cards/{card-id}/board?key={API-key}&token={server-token}
Import checkItems on a Card/1/cards/{card-id}/checkItemStates?key={API-key}&token={server-token}
Import checkItem on a Card/1/cards/{card-id}/checkItem/{idCheckItem}?key={API-key}&token={server-token}
Import Stickers on a Card/1/cards/{card-id}/stickers?key={API-key}&token={server-token}
Import a Sticker on a Card/1/cards/{card-id}/stickers/{idSticker}?key={API-key}&token={server-token}

Checklists

Data entityResource to attach to the basic JSON URL
Import Checklists on a Board/1/boards/{board-id}/checklists?key={API-key}&token={server-token}
Import Checklists on a Card/1/cards/{card-id}/checklists?key={API-key}&token={server-token}
Import a Checklist/1/checklists/{list-id}?key={API-key}&token={server-token}
Import the Board the Checklist is on/1/checklists/{list-id}/board?key={API-key}&token={server-token}
Import the Card a Checklist is on/1/checklists/{list-id}/cards?key={API-key}&token={server-token}
Import a Checkitem on a Checklist/1/checklists/{list-id}/checkItems/{idCheckItem}?key={API-key}&token={server-token}

Actions

Data entityResource to attach to the basic JSON URL
Import Actions of a Board/1/boards/{boardId}/actions?key={API-key}&token={server-token}
Import Actions on a Card/1/cards/{card-id}/actions?key={API-key}&token={server-token}
Import an Action/1/actions/{action-id}?key={API-key}&token={server-token}
Import the Board for an Action/1/actions/{action-id}/board?key={API-key}&token={server-token}
Import the Card for an Action/1/actions/{action-id}/card?key={API-key}&token={server-token}
Import Action’s Reaction/1/actions/{idAction}/reactions/{action-id}?key={API-key}&token={server-token}
List Action’s summary of Reactions/1/actions/{idAction}/reactionsSummary?key={API-key}&token={server-token}
Import Actions for a List/1/lists/{list-id}/actions?key={API-key}&token={server-token}
Import a Member’s Actions/1/members/{member-id}/actions?key={API-key}&token={server-token}
Import Actions for Organization/1/organizations/{organizations-id}/actions?key={API-key}&token={server-token}

Fields

Data entityResource to attach to the basic JSON URL
Import a field on a Board/1/boards/{board-id}/{field}?key={API-key}&token={server-token}
Import a field on a Card/1/cards/{card-id}/{field}?key={API-key}&token={server-token}
Import field on a Checklist/1/checklists/{list-id}/{field}?key={API-key}&token={server-token}
Import a specific field on an Action/1/actions/{action-id}/{field}?key={API-key}&token={server-token}
Import a field on a Member/1/members/{member-id}/{field}?key={API-key}&token={server-token}
Import field on Organization/1/organizations/{organizations-id}/{field}?key={API-key}&token={server-token}

Custom Fields

Data entityResource to attach to the basic JSON URL
Import Custom Fields for Board/1/boards/{board-id}/customFields?key={API-key}&token={server-token}
Import Custom Field Items for a Card/1/cards/{card-id}/customFieldItems?key={API-key}&token={server-token}
Import a Custom Field/1/customFields/{id}?key={API-key}&token={server-token}
Import Options of Custom Field drop down/1/customFields/{id}/options?key={API-key}&token={server-token}
Import Option of Custom Field dropdown/1/customFields/{id}/options/{idCustomFieldOption}?key={API-key}&token={server-token}

Emoji

Data entityResource to attach to the basic JSON URL
List available Emoji/1/emoji?key={API-key}&token={server-token}
Import a Member’s customEmojis/1/members/{member-id}/customEmoji?key={API-key}&token={server-token}
Import a Member’s custom Emoji/1/members/{member-id}/customEmoji/{emoji-id}?key={API-key}&token={server-token}

Enterprises

Data entityResource to attach to the basic JSON URL
Import an Enterprise/1/enterprises/{enterprise-id}?key={API-key}&token={server-token}
Import signupUrl for Enterprise/1/enterprises/{enterprise-id}/signupUrl?key={API-key}&token={server-token}
Import whether an organization can be transferred to an enterprise./1/enterprises/{enterprise-id}/transferrable/organization/{idOrganization}?key={API-key}&token={server-token}

Labels

Data entityResource to attach to the basic JSON URL
Import Labels on a Board/1/boards/{board-id}/labels?key={API-key}&token={server-token}
Import a Label/1/labels/{labels-id}?key={API-key}&token={server-token}

Lists

Data entityResource to attach to the basic JSON URL
Import Lists on a Board/1/boards/{board-id}/lists?key={API-key}&token={server-token}
Import filtered Lists on a Board/1/boards/{board-id}/lists/{filter}?key={API-key}&token={server-token}
Import the List of a Card/1/cards/{card-id}/list?key={API-key}&token={server-token}
Import the List for an Action/1/actions/{action-id}/list?key={API-key}&token={server-token}
Import a List/1/lists/{list-id}?key={API-key}&token={server-token}
Import Cards in a List/1/lists/{list-id}/cards?key={API-key}&token={server-token}

Members

Data entityResource to attach to the basic JSON URL
Import Memberships of a Board/1/boards/{board-id}/memberships?key={API-key}&token={server-token}
Import the Members of a Board/1/boards/{board-id}/members?key={API-key}&token={server-token}
Import the Members of a Card/1/cards/{card-id}/members?key={API-key}&token={server-token}
Import Members who have voted on a Card/1/cards/{card-id}/membersVoted?key={API-key}&token={server-token}
Import the Member of an Action/1/actions/{action-id}/member?key={API-key}&token={server-token}
Import Enterprise admin Members/1/enterprises/{enterprise-id}/admins?key={API-key}&token={server-token}
Import Members of Enterprise/1/enterprises/{enterprise-id}/members?key={API-key}&token={server-token}
Import a Member of Enterprise/1/enterprises/{enterprise-id}/members/{member-id}?key={API-key}&token={server-token}
Import a Member/1/members/{member-id}?key={API-key}&token={server-token}
Import Member’s custom Board backgrounds/1/members/{member-id}/boardBackgrounds?key={API-key}&token={server-token}
Import a boardBackground of a Member/1/members/{member-id}/boardBackgrounds/{background-id}?key={API-key}&token={server-token}
Import a Member’s boardStars/1/members/{member-id}/boardStars?key={API-key}&token={server-token}
Import a boardStar of Member/1/members/{member-id}/boardStars/{idStar}?key={API-key}&token={server-token}
Import Boards that Member belongs to/1/members/{member-id}/boards?key={API-key}&token={server-token}
Import Boards the Member has been invited to/1/members/{member-id}/boardsInvited?key={API-key}&token={server-token}
Import Cards the Member is on/1/members/{member-id}/cards?key={API-key}&token={server-token}
Import a Member’s custom Board Backgrounds/1/members/{member-id}/customBoardBackgrounds?key={API-key}&token={server-token}
Import custom Board Background of Member/1/members/{member-id}/customBoardBackgrounds/{background-id}?key={API-key}&token={server-token}
Import Member’s custom Stickers/1/members/{member-id}/customStickers?key={API-key}&token={server-token}
Import a Member’s custom Sticker/1/members/{member-id}/customStickers/{idSticker}?key={API-key}&token={server-token}
Import Member’s saved searched/1/members/{member-id}/savedSearches?key={API-key}&token={server-token}
Import a saved search/1/members/{member-id}/savedSearches/{idSearch}?key={API-key}&token={server-token}
Import Member’s Tokens/1/members/{member-id}/tokens?key={API-key}&token={server-token}

Notifications

Data entityResource to attach to the basic JSON URL
Import Member’s Notifications/1/members/{member-id}/notifications?key={API-key}&token={server-token}
Import a Notification/1/notifications/{notification-id}?key={API-key}&token={server-token}
Import the Board a Notification is on/1/notifications/{notification-id}/board?key={API-key}&token={server-token}
Import the Card a Notification is on/1/notifications/{notification-id}/card?key={API-key}&token={server-token}
Import the List a Notification is on/1/notifications/{notification-id}/list?key={API-key}&token={server-token}
Import the Member who created the Notification/1/notifications/{notification-id}/memberCreator?key={API-key}&token={server-token}

Organizations

Data entityResource to attach to the basic JSON URL
Import the Organization of an Action/1/actions/{action-id}/organization?key={API-key}&token={server-token}
Import Member’s Organizations/1/members/{member-id}/organizations?key={API-key}&token={server-token}
Import Organizations a Member has been invited to/1/members/{member-id}/organizationsInvited?key={API-key}&token={server-token}
Import a Notification’s associated Organization/1/notifications/{notification-id}/organization?key={API-key}&token={server-token}
Import an Organization/1/organizations/{organizations-id}?key={API-key}&token={server-token}
Import Members with Pending Invites to an Organization/1/organizations/{organizations-id}/membersInvited?key={API-key}&token={server-token}
Import Memberships of an Organization/1/organizations/{organizations-id}/memberships?key={API-key}&token={server-token}
Import a Membership of an Organization/1/organizations/{organizations-id}/memberships/{membership-id}?key={API-key}&token={server-token}
Import Tags of an Organization/1/organizations/{organizations-id}/tags?key={API-key}&token={server-token}
Import Organizations new billable guests/1/organizations/{organizations-id}/newBillableGuests/{board-id}?key={API-key}&token={server-token}

Plugins

Data entityResource to attach to the basic JSON URL
Import Enabled Power-Ups on Board/1/boards/{board-id}/boardPlugins?key={API-key}&token={server-token}
Import Power-Ups on a Board/1/boards/{board-id}/plugins?key={API-key}&token={server-token}
Import pluginData on a Card/1/cards/{card-id}/pluginData?key={API-key}&token={server-token}
Import the pluginData Scoped to Organization/1/organizations/{organizations-id}/pluginData?key={API-key}&token={server-token}
Import a Plugin/1/plugins/{plugin-id}?key={API-key}&token={server-token}
Data entityResource to attach to the basic JSON URL
Search Trello/1/search?query={text-to-search}&key={API-key}&token={server-token}
Search for Members/1/search/members?query={member-to-search}&key={API-key}&token={server-token}

Check out this spreadsheet with a detailed breakdown of Trello data entities.

To wrap up: Should I import data to Trello?

You wouldn’t have got here if you hadn’t needed to pull Trello data to a spreadsheet, would you? Actually, the Coupler.io team has had multiple users’ requests asking how to integrate Trello and Google Sheets. So, this blog post should help them handle this. Besides, you can fill out this form and contribute to the choice of the next ready-to-use importer. If you need a Trello importer, let us know about this. Good luck with your data!

Back to Blog

Comments are closed.

Access your data
in a simple format for free!

Start Free