Search API Connector Documentation

Print

Import Trello Data to Google Sheets

In this guide, we’ll walk through how to pull data from the Trello API directly into Google Sheets, using the API Connector add-on for Sheets.

We’ll first get an API key from Trello, and then set up a request to pull in project board details to your spreadsheet.

Contents

Before You Begin

Click here to install the API Connector add-on from the Google Marketplace.

Part 1: Get Your Trello API Key and Token

  1. Log into your Trello account and navigate to https://trello.com/app-key. Click the Show API Key button.
    trello-img1
  2. Note your API Key and click the Token link.
    trello-img2
  3. You’ll be prompted to grant permissions. Click Allow.
    trello-img3
  4. You’ll now see a page with your API token. Copy this and keep it handy.
    trello-img4

Part 2: Pull Data from Trello to Sheets

The easiest way to get started with the Trello API is through API Connector’s built-in integration.

  1. Select Trello from the drop-down list of applications
    trello-application
  2. Choose an endpoint. We’ll start with /members/me/boards, which lists the boards in your account.
    trello-endpoints
  3. Under parameters, enter your API key and token.
  4. Select a destination sheet, name your request, and click Run.
    trello-response
  5. Note the board id in the id field, as you can plug that into subsequent requests.

Part 3: Create a Custom API Request

Alternatively, you can run your own custom requests instead of using API Connector’s pre-built integration, using any of the endpoints and parameters shown in Trello’s API documentation. To create a custom request, add the complete URL into the request URL field.

To easily convert from a preset request to a custom API URL, tick the Add request URL box before running your preset request (under Output options). This will print out your complete API URL, which you can then copy/paste into the request URL field.

Part 4: Handle Pagination

Note Trello’s limits on the number of records returned on a response. By default, a maximum of 1000 records will be returned as described in their documentation.

To retrieve more than 1000 records, multiple requests must be made using the ‘since’ and ‘before’ parameters. In API Connector, you can page through automatically using pagination handling (paid feature).

  • Pagination: cursor
  • Next token parameter: before
  • Next token path: id
  • Run until: choose when to stop fetching data
    trello-pagination-cursor

Part 5: API Documentation

Official API documentation: https://developers.trello.com/docs/api-introduction

Previous Import Torn API Data to Google Sheets
Next Import Twitter Data to Google Sheets

Leave a Comment

Table of Contents