ℹ️ Premium and Supreme only

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, contact our Support team via the in-app chat at the bottom-right of your screen (or email support@perdoo.com) so they can set one up for you.


1. First, you'll need to get your Trello key and server token on https://trello.com/app-key:

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

3. Then, set up your Google Sheets Integration. In a separate tab, setup SyncWith to pull https://api.trello.com/1/boards/{idBoard}/cards:

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!

Did this answer your question?