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

[Matthew Ryan]

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. 

[Iain Dooley]

@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]

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

[Ricky Charpentier]

It depends. Where is the live tracker located? Is it through another online service? Is the excel tracker just giving you live updates of an actual Excel file that's sitting somewhere (such as Google Drive, etc.)?

[Matthew Ryan]

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.