ℹ️ 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 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 https://trello.com/app-key:
2. Get your board’s ID from the Trello URL (copy the text after b/ and before /test):
3. Then, set up your Google Sheets Integration. In a separate tab, setup SyncWith to pull https://developer.atlassian.com/cloud/trello/rest/api-group-boards/#api-boards-id-cards-get:
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!