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

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

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

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 entityJSON URL
Import a Boardhttps://api.trello.com/1/boards/{board-id}?key={API-key}&token={server-token}
Import Boards in an Organizationhttps://api.trello.com/1/organizations/{organization-id}/boards?key={API-key}&token={server-token}
Import boardStars on a Boardhttps://api.trello.com/1/boards/{board-id}/boardStars?key={API-key}&token={server-token}

Cards

Data entityJSON URL
Import a Card on a Boardhttps://api.trello.com/1/boards/{board-id}/cards/{idCard}?key={API-key}&token={server-token}
Import Cards on a Boardhttps://api.trello.com/1/boards/{board-id}/cards?key={API-key}&token={server-token}
Import filtered Cards on a Boardhttps://api.trello.com/1/boards/{board-id}/cards/{filter}?key={API-key}&token={server-token}
Import filtered Cards on a Boardhttps://api.trello.com/1/boards/{board-id}/cards/{filter}?key={API-key}&token={server-token}
Import a Cardhttps://api.trello.com/1/cards/{card-id}?key={API-key}&token={server-token}
Import Attachments on a Cardhttps://api.trello.com/1/cards/{card-id}/attachments?key={API-key}&token={server-token}
Import the Board the Card is onhttps://api.trello.com/1/cards/{card-id}/board?key={API-key}&token={server-token}
Import checkItems on a Cardhttps://api.trello.com/1/cards/{card-id}/checkItemStates?key={API-key}&token={server-token}
Import checkItem on a Cardhttps://api.trello.com/1/cards/{card-id}/checkItem/{idCheckItem}?key={API-key}&token={server-token}
Import Stickers on a Cardhttps://api.trello.com/1/cards/{card-id}/stickers?key={API-key}&token={server-token}
Import a Sticker on a Cardhttps://api.trello.com/1/cards/{card-id}/stickers/{idSticker}?key={API-key}&token={server-token}

Checklists

Data entityJSON URL
Import Checklists on a Boardhttps://api.trello.com/1/boards/{board-id}/checklists?key={API-key}&token={server-token}
Import Checklists on a Cardhttps://api.trello.com/1/cards/{card-id}/checklists?key={API-key}&token={server-token}
Import a Checklisthttps://api.trello.com/1/checklists/{list-id}?key={API-key}&token={server-token}
Import the Board the Checklist is onhttps://api.trello.com/1/checklists/{list-id}/board?key={API-key}&token={server-token}
Import the Card a Checklist is onhttps://api.trello.com/1/checklists/{list-id}/cards?key={API-key}&token={server-token}
Import a Checkitem on a Checklisthttps://api.trello.com/1/checklists/{list-id}/checkItems/{idCheckItem}?key={API-key}&token={server-token}

Actions

Data entityJSON URL
Import Actions of a Boardhttps://api.trello.com/1/boards/{boardId}/actions?key={API-key}&token={server-token}
Import Actions on a Cardhttps://api.trello.com/1/cards/{card-id}/actions?key={API-key}&token={server-token}
Import an Actionhttps://api.trello.com/1/actions/{action-id}?key={API-key}&token={server-token}
Import the Board for an Actionhttps://api.trello.com/1/actions/{action-id}/board?key={API-key}&token={server-token}
Import the Card for an Actionhttps://api.trello.com/1/actions/{action-id}/card?key={API-key}&token={server-token}
Import Action’s Reactionhttps://api.trello.com/1/actions/{idAction}/reactions/{action-id}?key={API-key}&token={server-token}
List Action’s summary of Reactionshttps://api.trello.com/1/actions/{idAction}/reactionsSummary?key={API-key}&token={server-token}
Import Actions for a Listhttps://api.trello.com/1/lists/{list-id}/actions?key={API-key}&token={server-token}
Import a Member’s Actionshttps://api.trello.com/1/members/{member-id}/actions?key={API-key}&token={server-token}
Import Actions for Organizationhttps://api.trello.com/1/organizations/{organizations-id}/actions?key={API-key}&token={server-token}

Fields

Data entityJSON URL
Import a field on a Boardhttps://api.trello.com/1/boards/{board-id}/{field}?key={API-key}&token={server-token}
Import a field on a Cardhttps://api.trello.com/1/cards/{card-id}/{field}?key={API-key}&token={server-token}
Import field on a Checklisthttps://api.trello.com/1/checklists/{list-id}/{field}?key={API-key}&token={server-token}
Import a specific field on an Actionhttps://api.trello.com/1/actions/{action-id}/{field}?key={API-key}&token={server-token}
Import a field on a Memberhttps://api.trello.com/1/members/{member-id}/{field}?key={API-key}&token={server-token}
Import field on Organizationhttps://api.trello.com/1/organizations/{organizations-id}/{field}?key={API-key}&token={server-token}

Custom Fields

Data entityJSON URL
Import Custom Fields for Boardhttps://api.trello.com/1/boards/{board-id}/customFields?key={API-key}&token={server-token}
Import Custom Field Items for a Cardhttps://api.trello.com/1/cards/{card-id}/customFieldItems?key={API-key}&token={server-token}
Import a Custom Fieldhttps://api.trello.com/1/customFields/{id}?key={API-key}&token={server-token}
Import Options of Custom Field drop downhttps://api.trello.com/1/customFields/{id}/options?key={API-key}&token={server-token}
Import Option of Custom Field dropdownhttps://api.trello.com/1/customFields/{id}/options/{idCustomFieldOption}?key={API-key}&token={server-token}

Emoji

Data entityJSON URL
List available Emojihttps://api.trello.com/1/emoji?key={API-key}&token={server-token}
Import a Member’s customEmojishttps://api.trello.com/1/members/{member-id}/customEmoji?key={API-key}&token={server-token}
Import a Member’s custom Emojihttps://api.trello.com/1/members/{member-id}/customEmoji/{emoji-id}?key={API-key}&token={server-token}

Enterprises

Data entityJSON URL
Import an Enterprisehttps://api.trello.com/1/enterprises/{enterprise-id}?key={API-key}&token={server-token}
Import signupUrl for Enterprisehttps://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 entityJSON URL
Import Labels on a Boardhttps://api.trello.com/1/boards/{board-id}/labels?key={API-key}&token={server-token}
Import a Labelhttps://api.trello.com/1/labels/{labels-id}?key={API-key}&token={server-token}

Lists

Data entityJSON URL
Import Lists on a Boardhttps://api.trello.com/1/boards/{board-id}/lists?key={API-key}&token={server-token}
Import filtered Lists on a Boardhttps://api.trello.com/1/boards/{board-id}/lists/{filter}?key={API-key}&token={server-token}
Import the List of a Cardhttps://api.trello.com/1/cards/{card-id}/list?key={API-key}&token={server-token}
Import the List for an Actionhttps://api.trello.com/1/actions/{action-id}/list?key={API-key}&token={server-token}
Import a Listhttps://api.trello.com/1/lists/{list-id}?key={API-key}&token={server-token}
Import Cards in a Listhttps://api.trello.com/1/lists/{list-id}/cards?key={API-key}&token={server-token}

Members

Data entityJSON URL
Import Memberships of a Boardhttps://api.trello.com/1/boards/{board-id}/memberships?key={API-key}&token={server-token}
Import the Members of a Boardhttps://api.trello.com/1/boards/{board-id}/members?key={API-key}&token={server-token}
Import the Members of a Cardhttps://api.trello.com/1/cards/{card-id}/members?key={API-key}&token={server-token}
Import Members who have voted on a Cardhttps://api.trello.com/1/cards/{card-id}/membersVoted?key={API-key}&token={server-token}
Import the Member of an Actionhttps://api.trello.com/1/actions/{action-id}/member?key={API-key}&token={server-token}
Import Enterprise admin Membershttps://api.trello.com/1/enterprises/{enterprise-id}/admins?key={API-key}&token={server-token}
Import Members of Enterprisehttps://api.trello.com/1/enterprises/{enterprise-id}/members?key={API-key}&token={server-token}
Import a Member of Enterprisehttps://api.trello.com/1/enterprises/{enterprise-id}/members/{member-id}?key={API-key}&token={server-token}
Import a Memberhttps://api.trello.com/1/members/{member-id}?key={API-key}&token={server-token}
Import Member’s custom Board backgroundshttps://api.trello.com/1/members/{member-id}/boardBackgrounds?key={API-key}&token={server-token}
Import a boardBackground of a Memberhttps://api.trello.com/1/members/{member-id}/boardBackgrounds/{background-id}?key={API-key}&token={server-token}
Import a Member’s boardStarshttps://api.trello.com/1/members/{member-id}/boardStars?key={API-key}&token={server-token}
Import a boardStar of Memberhttps://api.trello.com/1/members/{member-id}/boardStars/{idStar}?key={API-key}&token={server-token}
Import Boards that Member belongs tohttps://api.trello.com/1/members/{member-id}/boards?key={API-key}&token={server-token}
Import Boards the Member has been invited tohttps://api.trello.com/1/members/{member-id}/boardsInvited?key={API-key}&token={server-token}
Import Cards the Member is onhttps://api.trello.com/1/members/{member-id}/cards?key={API-key}&token={server-token}
Import a Member’s custom Board Backgroundshttps://api.trello.com/1/members/{member-id}/customBoardBackgrounds?key={API-key}&token={server-token}
Import custom Board Background of Memberhttps://api.trello.com/1/members/{member-id}/customBoardBackgrounds/{background-id}?key={API-key}&token={server-token}
Import Member’s custom Stickershttps://api.trello.com/1/members/{member-id}/customStickers?key={API-key}&token={server-token}
Import a Member’s custom Stickerhttps://api.trello.com/1/members/{member-id}/customStickers/{idSticker}?key={API-key}&token={server-token}
Import Member’s saved searchedhttps://api.trello.com/1/members/{member-id}/savedSearches?key={API-key}&token={server-token}
Import a saved searchhttps://api.trello.com/1/members/{member-id}/savedSearches/{idSearch}?key={API-key}&token={server-token}
Import Member’s Tokenshttps://api.trello.com/1/members/{member-id}/tokens?key={API-key}&token={server-token}

Notifications

Data entityJSON URL
Import Member’s Notificationshttps://api.trello.com/1/members/{member-id}/notifications?key={API-key}&token={server-token}
Import a Notificationhttps://api.trello.com/1/notifications/{notification-id}?key={API-key}&token={server-token}
Import the Board a Notification is onhttps://api.trello.com/1/notifications/{notification-id}/board?key={API-key}&token={server-token}
Import the Card a Notification is onhttps://api.trello.com/1/notifications/{notification-id}/card?key={API-key}&token={server-token}
Import the List a Notification is onhttps://api.trello.com/1/notifications/{notification-id}/list?key={API-key}&token={server-token}
Import the Member who created the Notificationhttps://api.trello.com/1/notifications/{notification-id}/memberCreator?key={API-key}&token={server-token}

Organizations

Data entityJSON URL
Import the Organization of an Actionhttps://api.trello.com/1/actions/{action-id}/organization?key={API-key}&token={server-token}
Import Member’s Organizationshttps://api.trello.com/1/members/{member-id}/organizations?key={API-key}&token={server-token}
Import Organizations a Member has been invited tohttps://api.trello.com/1/members/{member-id}/organizationsInvited?key={API-key}&token={server-token}
Import a Notification’s associated Organizationhttps://api.trello.com/1/notifications/{notification-id}/organization?key={API-key}&token={server-token}
Import an Organizationhttps://api.trello.com/1/organizations/{organizations-id}?key={API-key}&token={server-token}
Import Members with Pending Invites to an Organizationhttps://api.trello.com/1/organizations/{organizations-id}/membersInvited?key={API-key}&token={server-token}
Import Memberships of an Organizationhttps://api.trello.com/1/organizations/{organizations-id}/memberships?key={API-key}&token={server-token}
Import a Membership of an Organizationhttps://api.trello.com/1/organizations/{organizations-id}/memberships/{membership-id}?key={API-key}&token={server-token}
Import Tags of an Organizationhttps://api.trello.com/1/organizations/{organizations-id}/tags?key={API-key}&token={server-token}
Import Organizations new billable guestshttps://api.trello.com/1/organizations/{organizations-id}/newBillableGuests/{board-id}?key={API-key}&token={server-token}

Plugins

Data entityJSON URL
Import Enabled Power-Ups on Boardhttps://api.trello.com/1/boards/{board-id}/boardPlugins?key={API-key}&token={server-token}
Import Power-Ups on a Boardhttps://api.trello.com/1/boards/{board-id}/plugins?key={API-key}&token={server-token}
Import pluginData on a Cardhttps://api.trello.com/1/cards/{card-id}/pluginData?key={API-key}&token={server-token}
Import the pluginData Scoped to Organizationhttps://api.trello.com/1/organizations/{organizations-id}/pluginData?key={API-key}&token={server-token}
Import a Pluginhttps://api.trello.com/1/plugins/{plugin-id}?key={API-key}&token={server-token}
Data entityJSON URL
Search Trellohttps://api.trello.com/1/search?query={text-to-search}&key={API-key}&token={server-token}
Search for Membershttps://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

Comments are closed.

Access your data
in a simple format for free!

Start Free