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
- Boards
- Cards
- Checklists
- Actions
- Fields
- Custom Fields
- Emoji
- Enterprises
- Labels
- Lists
- Members
- Notifications
- Organizations
- Plugins
- Bonus: Trello Search
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:
{API-key}– Get your Trello API Key at https://trello.com/app-key
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.comYou should attach it with a resource of a respective Trello data entity.
Boards
| Data entity | Resource 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 entity | Resource 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 entity | Resource 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 entity | Resource 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 entity | Resource 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 entity | Resource 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 entity | Resource 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 entity | Resource 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 entity | Resource 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 entity | Resource 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 entity | Resource 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 entity | Resource 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 entity | Resource 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 entity | Resource 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} |
Bonus: Trello Search
| Data entity | Resource 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