How to populate a live excel tracker from your Trello board?

Question

I've been unable to find a power-up solution for a workflow i'd like to implement:

I want my Trello cards to link through to a live Excel tracker and populate cells in real time as updates happen on cards.

For example, once I tick off a checklist, I would like for that to trigger an action in my live tracker that updates a cell.

Is anyone aware of a way in which this may be possible?

Thanks.

Matthew Ryan_rvsguf · Answer

Thanks Ian i'll have a look at this, appreciated.

Iain Dooley · Answer

@Matthew Ryan if you can use Google Sheets rather than Excel this simple Trellinator command would do it:

https://gist.github.com/iaindooley/eee1753fe310463505d11769fa009c9a

You can see how to set up Trellinator here:

https://community.atlassian.com/t5/Marketplace-Apps-articles/Introducing-Trellinator-Automate-Trello-with-Google-Apps-Script/ba-p/925271

Matthew Ryan_rvsguf · Answer

Thanks for the quick reply.

We have existing trackers that are located in Sharepoint via Microsoft teams. Employees open trackers locally. The trackers autosave as they are updated so changes appear in real time.

Ideally, we would like for either 1. These trackers to link specific cells/columns to trello cards which update accordingly or 2. Updates on Trello cards to filter through to our trackers.

Hope that makes sense.