ℹ️ 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 email@example.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:
2. Get your board’s ID from the Trello URL (copy the text after b/ and before /test):
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!