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.
Table of Contents
hide
How to set up Trello – Google Sheets integration
Install Coupler.io
Coupler.io is the GSheets add-on to sync spreadsheets with different data sources, such as Trello, Airtable, Xero, Clockify, and many more. Find Coupler.io on the G Suite Marketplace or install it with this direct link.
Alternatively, you can install Coupler.io right from the Add-ons menu of your spreadsheet. For more about the add-on and available importers, visit the Coupler.io home 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. Follow the instructions below to succeed. Run Coupler.io (from the Add-ons menu of a spreadsheet), click +Add Importer and select JSON Client.
The JSON Client importer has several fields, but you’ll mostly need the following ones to connect to Trello:
- Title – add the name of your Trello JSON to Google Sheets integration.
- Sheet Name – type in the name of your sheet.
- JSON URL – 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, Trello to Google Sheets integration parameters.
- HTTP Method – pick GET to pull data to a spreadsheet.
Automatic data refresh lets you automate data import. Choose the frequency to enable the feature or toggle off to disable it.
Once the parameters are inserted, click Add Importer and run it afterwards 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
Insert it in the JSON Client importer, click Add Importer and run it to pull data.
JSON URL parameters to import Trello data
Check out this spreadsheet with a detailed breakdown of Trello data entities.
Boards
| Data entity | JSON URL |
|---|---|
| Import a Board | https://api.trello.com/1/boards/{board-id}?key={API-key}&token={server-token} |
| Import Boards in an Organization | https://api.trello.com/1/organizations/{organization-id}/boards?key={API-key}&token={server-token} |
| Import boardStars on a Board | https://api.trello.com/1/boards/{board-id}/boardStars?key={API-key}&token={server-token} |
Cards
| Data entity | JSON URL |
|---|---|
| Import a Card on a Board | https://api.trello.com/1/boards/{board-id}/cards/{idCard}?key={API-key}&token={server-token} |
| Import Cards on a Board | https://api.trello.com/1/boards/{board-id}/cards?key={API-key}&token={server-token} |
| Import filtered Cards on a Board | https://api.trello.com/1/boards/{board-id}/cards/{filter}?key={API-key}&token={server-token} |
| Import filtered Cards on a Board | https://api.trello.com/1/boards/{board-id}/cards/{filter}?key={API-key}&token={server-token} |
| Import a Card | https://api.trello.com/1/cards/{card-id}?key={API-key}&token={server-token} |
| Import Attachments on a Card | https://api.trello.com/1/cards/{card-id}/attachments?key={API-key}&token={server-token} |
| Import the Board the Card is on | https://api.trello.com/1/cards/{card-id}/board?key={API-key}&token={server-token} |
| Import checkItems on a Card | https://api.trello.com/1/cards/{card-id}/checkItemStates?key={API-key}&token={server-token} |
| Import checkItem on a Card | https://api.trello.com/1/cards/{card-id}/checkItem/{idCheckItem}?key={API-key}&token={server-token} |
| Import Stickers on a Card | https://api.trello.com/1/cards/{card-id}/stickers?key={API-key}&token={server-token} |
| Import a Sticker on a Card | https://api.trello.com/1/cards/{card-id}/stickers/{idSticker}?key={API-key}&token={server-token} |
Checklists
| Data entity | JSON URL |
|---|---|
| Import Checklists on a Board | https://api.trello.com/1/boards/{board-id}/checklists?key={API-key}&token={server-token} |
| Import Checklists on a Card | https://api.trello.com/1/cards/{card-id}/checklists?key={API-key}&token={server-token} |
| Import a Checklist | https://api.trello.com/1/checklists/{list-id}?key={API-key}&token={server-token} |
| Import the Board the Checklist is on | https://api.trello.com/1/checklists/{list-id}/board?key={API-key}&token={server-token} |
| Import the Card a Checklist is on | https://api.trello.com/1/checklists/{list-id}/cards?key={API-key}&token={server-token} |
| Import a Checkitem on a Checklist | https://api.trello.com/1/checklists/{list-id}/checkItems/{idCheckItem}?key={API-key}&token={server-token} |
Actions
| Data entity | JSON URL |
|---|---|
| Import Actions of a Board | https://api.trello.com/1/boards/{boardId}/actions?key={API-key}&token={server-token} |
| Import Actions on a Card | https://api.trello.com/1/cards/{card-id}/actions?key={API-key}&token={server-token} |
| Import an Action | https://api.trello.com/1/actions/{action-id}?key={API-key}&token={server-token} |
| Import the Board for an Action | https://api.trello.com/1/actions/{action-id}/board?key={API-key}&token={server-token} |
| Import the Card for an Action | https://api.trello.com/1/actions/{action-id}/card?key={API-key}&token={server-token} |
| Import Action’s Reaction | https://api.trello.com/1/actions/{idAction}/reactions/{action-id}?key={API-key}&token={server-token} |
| List Action’s summary of Reactions | https://api.trello.com/1/actions/{idAction}/reactionsSummary?key={API-key}&token={server-token} |
| Import Actions for a List | https://api.trello.com/1/lists/{list-id}/actions?key={API-key}&token={server-token} |
| Import a Member’s Actions | https://api.trello.com/1/members/{member-id}/actions?key={API-key}&token={server-token} |
| Import Actions for Organization | https://api.trello.com/1/organizations/{organizations-id}/actions?key={API-key}&token={server-token} |
Fields
| Data entity | JSON URL |
|---|---|
| Import a field on a Board | https://api.trello.com/1/boards/{board-id}/{field}?key={API-key}&token={server-token} |
| Import a field on a Card | https://api.trello.com/1/cards/{card-id}/{field}?key={API-key}&token={server-token} |
| Import field on a Checklist | https://api.trello.com/1/checklists/{list-id}/{field}?key={API-key}&token={server-token} |
| Import a specific field on an Action | https://api.trello.com/1/actions/{action-id}/{field}?key={API-key}&token={server-token} |
| Import a field on a Member | https://api.trello.com/1/members/{member-id}/{field}?key={API-key}&token={server-token} |
| Import field on Organization | https://api.trello.com/1/organizations/{organizations-id}/{field}?key={API-key}&token={server-token} |
Custom Fields
| Data entity | JSON URL |
|---|---|
| Import Custom Fields for Board | https://api.trello.com/1/boards/{board-id}/customFields?key={API-key}&token={server-token} |
| Import Custom Field Items for a Card | https://api.trello.com/1/cards/{card-id}/customFieldItems?key={API-key}&token={server-token} |
| Import a Custom Field | https://api.trello.com/1/customFields/{id}?key={API-key}&token={server-token} |
| Import Options of Custom Field drop down | https://api.trello.com/1/customFields/{id}/options?key={API-key}&token={server-token} |
| Import Option of Custom Field dropdown | https://api.trello.com/1/customFields/{id}/options/{idCustomFieldOption}?key={API-key}&token={server-token} |
Emoji
| Data entity | JSON URL |
|---|---|
| List available Emoji | https://api.trello.com/1/emoji?key={API-key}&token={server-token} |
| Import a Member’s customEmojis | https://api.trello.com/1/members/{member-id}/customEmoji?key={API-key}&token={server-token} |
| Import a Member’s custom Emoji | https://api.trello.com/1/members/{member-id}/customEmoji/{emoji-id}?key={API-key}&token={server-token} |
Enterprises
| Data entity | JSON URL |
|---|---|
| Import an Enterprise | https://api.trello.com/1/enterprises/{enterprise-id}?key={API-key}&token={server-token} |
| Import signupUrl for Enterprise | https://api.trello.com/1/enterprises/{enterprise-id}/signupUrl?key={API-key}&token={server-token} |
| Import whether an organization can be transferred to an enterprise. | https://api.trello.com/1/enterprises/{enterprise-id}/transferrable/organization/{idOrganization}?key={API-key}&token={server-token} |
Labels
| Data entity | JSON URL |
|---|---|
| Import Labels on a Board | https://api.trello.com/1/boards/{board-id}/labels?key={API-key}&token={server-token} |
| Import a Label | https://api.trello.com/1/labels/{labels-id}?key={API-key}&token={server-token} |
Lists
| Data entity | JSON URL |
|---|---|
| Import Lists on a Board | https://api.trello.com/1/boards/{board-id}/lists?key={API-key}&token={server-token} |
| Import filtered Lists on a Board | https://api.trello.com/1/boards/{board-id}/lists/{filter}?key={API-key}&token={server-token} |
| Import the List of a Card | https://api.trello.com/1/cards/{card-id}/list?key={API-key}&token={server-token} |
| Import the List for an Action | https://api.trello.com/1/actions/{action-id}/list?key={API-key}&token={server-token} |
| Import a List | https://api.trello.com/1/lists/{list-id}?key={API-key}&token={server-token} |
| Import Cards in a List | https://api.trello.com/1/lists/{list-id}/cards?key={API-key}&token={server-token} |
Members
| Data entity | JSON URL |
|---|---|
| Import Memberships of a Board | https://api.trello.com/1/boards/{board-id}/memberships?key={API-key}&token={server-token} |
| Import the Members of a Board | https://api.trello.com/1/boards/{board-id}/members?key={API-key}&token={server-token} |
| Import the Members of a Card | https://api.trello.com/1/cards/{card-id}/members?key={API-key}&token={server-token} |
| Import Members who have voted on a Card | https://api.trello.com/1/cards/{card-id}/membersVoted?key={API-key}&token={server-token} |
| Import the Member of an Action | https://api.trello.com/1/actions/{action-id}/member?key={API-key}&token={server-token} |
| Import Enterprise admin Members | https://api.trello.com/1/enterprises/{enterprise-id}/admins?key={API-key}&token={server-token} |
| Import Members of Enterprise | https://api.trello.com/1/enterprises/{enterprise-id}/members?key={API-key}&token={server-token} |
| Import a Member of Enterprise | https://api.trello.com/1/enterprises/{enterprise-id}/members/{member-id}?key={API-key}&token={server-token} |
| Import a Member | https://api.trello.com/1/members/{member-id}?key={API-key}&token={server-token} |
| Import Member’s custom Board backgrounds | https://api.trello.com/1/members/{member-id}/boardBackgrounds?key={API-key}&token={server-token} |
| Import a boardBackground of a Member | https://api.trello.com/1/members/{member-id}/boardBackgrounds/{background-id}?key={API-key}&token={server-token} |
| Import a Member’s boardStars | https://api.trello.com/1/members/{member-id}/boardStars?key={API-key}&token={server-token} |
| Import a boardStar of Member | https://api.trello.com/1/members/{member-id}/boardStars/{idStar}?key={API-key}&token={server-token} |
| Import Boards that Member belongs to | https://api.trello.com/1/members/{member-id}/boards?key={API-key}&token={server-token} |
| Import Boards the Member has been invited to | https://api.trello.com/1/members/{member-id}/boardsInvited?key={API-key}&token={server-token} |
| Import Cards the Member is on | https://api.trello.com/1/members/{member-id}/cards?key={API-key}&token={server-token} |
| Import a Member’s custom Board Backgrounds | https://api.trello.com/1/members/{member-id}/customBoardBackgrounds?key={API-key}&token={server-token} |
| Import custom Board Background of Member | https://api.trello.com/1/members/{member-id}/customBoardBackgrounds/{background-id}?key={API-key}&token={server-token} |
| Import Member’s custom Stickers | https://api.trello.com/1/members/{member-id}/customStickers?key={API-key}&token={server-token} |
| Import a Member’s custom Sticker | https://api.trello.com/1/members/{member-id}/customStickers/{idSticker}?key={API-key}&token={server-token} |
| Import Member’s saved searched | https://api.trello.com/1/members/{member-id}/savedSearches?key={API-key}&token={server-token} |
| Import a saved search | https://api.trello.com/1/members/{member-id}/savedSearches/{idSearch}?key={API-key}&token={server-token} |
| Import Member’s Tokens | https://api.trello.com/1/members/{member-id}/tokens?key={API-key}&token={server-token} |
Notifications
| Data entity | JSON URL |
|---|---|
| Import Member’s Notifications | https://api.trello.com/1/members/{member-id}/notifications?key={API-key}&token={server-token} |
| Import a Notification | https://api.trello.com/1/notifications/{notification-id}?key={API-key}&token={server-token} |
| Import the Board a Notification is on | https://api.trello.com/1/notifications/{notification-id}/board?key={API-key}&token={server-token} |
| Import the Card a Notification is on | https://api.trello.com/1/notifications/{notification-id}/card?key={API-key}&token={server-token} |
| Import the List a Notification is on | https://api.trello.com/1/notifications/{notification-id}/list?key={API-key}&token={server-token} |
| Import the Member who created the Notification | https://api.trello.com/1/notifications/{notification-id}/memberCreator?key={API-key}&token={server-token} |
Organizations
| Data entity | JSON URL |
|---|---|
| Import the Organization of an Action | https://api.trello.com/1/actions/{action-id}/organization?key={API-key}&token={server-token} |
| Import Member’s Organizations | https://api.trello.com/1/members/{member-id}/organizations?key={API-key}&token={server-token} |
| Import Organizations a Member has been invited to | https://api.trello.com/1/members/{member-id}/organizationsInvited?key={API-key}&token={server-token} |
| Import a Notification’s associated Organization | https://api.trello.com/1/notifications/{notification-id}/organization?key={API-key}&token={server-token} |
| Import an Organization | https://api.trello.com/1/organizations/{organizations-id}?key={API-key}&token={server-token} |
| Import Members with Pending Invites to an Organization | https://api.trello.com/1/organizations/{organizations-id}/membersInvited?key={API-key}&token={server-token} |
| Import Memberships of an Organization | https://api.trello.com/1/organizations/{organizations-id}/memberships?key={API-key}&token={server-token} |
| Import a Membership of an Organization | https://api.trello.com/1/organizations/{organizations-id}/memberships/{membership-id}?key={API-key}&token={server-token} |
| Import Tags of an Organization | https://api.trello.com/1/organizations/{organizations-id}/tags?key={API-key}&token={server-token} |
| Import Organizations new billable guests | https://api.trello.com/1/organizations/{organizations-id}/newBillableGuests/{board-id}?key={API-key}&token={server-token} |
Plugins
| Data entity | JSON URL |
|---|---|
| Import Enabled Power-Ups on Board | https://api.trello.com/1/boards/{board-id}/boardPlugins?key={API-key}&token={server-token} |
| Import Power-Ups on a Board | https://api.trello.com/1/boards/{board-id}/plugins?key={API-key}&token={server-token} |
| Import pluginData on a Card | https://api.trello.com/1/cards/{card-id}/pluginData?key={API-key}&token={server-token} |
| Import the pluginData Scoped to Organization | https://api.trello.com/1/organizations/{organizations-id}/pluginData?key={API-key}&token={server-token} |
| Import a Plugin | https://api.trello.com/1/plugins/{plugin-id}?key={API-key}&token={server-token} |
Bonus: Trello Search
| Data entity | JSON URL |
|---|---|
| Search Trello | https://api.trello.com/1/search?query={text-to-search}&key={API-key}&token={server-token} |
| Search for Members | https://api.trello.com/1/search/members?query={member-to-search}&key={API-key}&token={server-token} |
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