All Collections
Trello integration
Trello integration

Use our Google Sheet integration to pull data from Trello to automatically update your goals.

Nicole Capobianco avatar
Written by Nicole Capobianco
Updated over a week ago

Our integrations meet your team where they are by bringing all the tools you already use into Perdoo. Trello is a collaboration tool that organizes your projects into boards.

Using our Google Sheets integration, integrate with Trello by following these steps:

Make sure you have a Google Sheets integration set up. If you don't yet, simply install our GSheets Add-on , (2) Connect a GSheet to your Perdoo account, (3) Automatically pull data from any spreadsheet and 200+ apps. You can learn more here.

1. First, you'll need to get your Trello key and server token on

Trello API keys
Server Token in Trello

2. Get your board’s ID from the Trello URL (copy the text after b/ and before /test):

Board ID in Trello URL

4. Find completion state in idList column by looking at an existing ‘done’ card.

5. In the Goals tab, link an existing Result or KPI and setup an IF function for the value that links to the other tab (e.g. IF state of linked card is ‘done’, value is 100, else it’s 0).

And you're done! Perdoo will then check once a day, around 2AM CET, for the new value in this spreadsheet, to keep your goal automatically up-to-date!

Need help?

Contact our friendly Support team via the live chat at the bottom-right of your screen, or email

Did this answer your question?