Trello API to Google Sheets: Import Trello Data [Tutorial]

How to pull Trello data into Google Sheets using the Trello API and the Apipheny Add-on

Trello is a popular visual project and task management platform, used by companies and individuals alike. Projects and tasks are organized into boards and cards, allowing users to easily track and annotate both professional and personal assignments.

In this tutorial, you’ll learn how to connect the Trello REST API to Google Sheets so you can import Trello data into Google Sheets, in 5 steps:

Install the Apipheny Add-on
Create a Trello Application
Get Access Credentials
Obtain a Trello Endpoint URL
Enter the Trello API Request into Apipheny
Run the Trello API Request

Step 1.) Install and open the Apipheny Add-on in Google Sheets

To pull data from the Trello API to Google Sheets, first install and open the Apipheny add-on for Google Sheets.

Apipheny is a no-code API integrator for Google Sheets that you can use to make unlimited API requests, connect to unlimited APIs, save API requests, schedule API requests, and more. Click here for more information about Apipheny on the homepage. There’s a 30-day free trial included, then it’s $19-$29/month.

1. Install Apipheny by opening the following link on desktop and then clicking the Install button on the page: https://gsuite.google.com/marketplace/app/apipheny/966163326746

2. After you’ve installed Apipheny, open a Google Sheet and then click on the Add-Ons option in the top menu. In the add-ons menu, you should see Apipheny.

Click Apipheny > Import API to open the Apipheny sidebar in your Google Sheets.

Step 2.) Create a Trello Application

1. First, log in to your Trello developer account, then make sure you’re in the Reference tab.

Then click on your profile picture to access the user menu, in the top-right corner.

Then click the Create App option:

2. On the next page, complete the Name field, check the Atlassian Developer Terms checkbox and then click the Create button:

3. A page dedicated to your newly created app will be open:

Step 3.) Get Access Credentials for Your Trello Application

To access the Trello API endpoints, you will need a Developer API key and an access token. To obtain them, follow the instructions below. If you already have an API Key and an access token, you can skip this section.

1. To get your Developer API key, log into Trello and go to https://trello.com/1/appKey/generate

Check the Trello Developer Terms agreement checkbox and then click the Show API Key button:

Your 32-character Developer API Key will be listed in the first box:

Copy and paste the key somewhere safe, as you will need it in the next steps.

2. To generate an access token, click on the Token link, below the Developer API Key:

Click the Allow button to display the token.

For security reasons, after you navigate off the page, you will not be able to see the token again.

Copy and paste your access token somewhere safe because you will need it later, to make your Trello API request in Google Sheets.

Step 4.) Obtain a Trello Endpoint URL

An endpoint is the part of your API URL that tells the Trello API what information you’re requesting. If you already have your endpoint or you want to use the same example endpoint as us, skip to the next section.

If you want to choose your own API endpoint, follow these steps:

Open the Trello REST API documentation page, by going to: https://developer.atlassian.com/cloud/trello/rest/

The menu on the left contains a list of available APIs, each linking to a list of available endpoints. Clicking on an API takes you to that API’s section, containing a list of associated endpoints.

For instance, the Actions API scrolls to the list of its 16 available endpoints: Get an Action, Update an Action, Delete an Action, all the way to List Action’s summary of Reactions:

All endpoints are presented starting with their HTTP method, followed by their individual URL.

When making requests, the endpoint should be appended to the Trello API root URL, which is:

http://api.trello.com

Also, the endpoint’s path parameters and request parameters will be listed and described, along with relevant examples of requests and expected responses.

Step 5.) Enter the Trello API Request into Apipheny

Go back to your Google Sheet and make sure that the Apipheny add-on is open with the Import tab open.

Once you find the endpoint URL you need, copy the whole URL and paste it into the API URL Path field in the Apipheny add-on. Make sure that the URL also includes any GET parameters required for your query.

At the top of the Apipheny sidebar, select the HTTP method (GET or POST) required by the API endpoint you’ve chosen. For this example, we are using GET.

In this example we are using the Get a Board endpoint, to obtain a single board’s details:

http://api.trello.com/1/boards/<board_id>

<board_id> is the ID of the board. To obtain the board ID you have to use the following URL:

https://api.trello.com/1/members/me/boards?key=<yourKey>&token=<yourToken>

Where <yourKey> is your Developer API Key and <yourToken> is your previously generated token (do not include the carrots “<>”).

Trello API request entered into Apipheny

Step 6.) Run the Trello API Request in Google Sheets

To get your Trello data into your Google Sheet, click the Run button at the bottom of the Apipheny add-on and then wait for the Trello data to be imported into your Google Sheets:

After making a successful request to the Trello API, try querying a different endpoint, or try using one of the more advanced features in the Apipheny add-on, such as:

Save and schedule your API request
Make a POST request (if available)
Use the custom =APIPHENY() function to call the API request inside your spreadsheet
Create an API request by referencing the value of a cell in the API URL with three curly braces eg. {{{Sheet1!A1}}}