designing a dashboard in Excel using data extracted from trello and required to make this process automated. (The export data feature in trello can only be used to extract the past data?)
The export in Trello will just export the board at the current state.
You can automate this process by using an undocumented API feature. If you're unfamiliar with the API, you can read more at https://developer.atlassian.com/cloud/trello. For a Python example of exporting your organization's data via the API, see https://github.com/bentleycook/trello-python-demo/blob/master/demo_bc_org_backup.py
Another option might be using a 3rd party service like Zapier to keep data from Trello in sync with the other service: https://zapier.com/apps/trello/integrations
Hello Community! My name is Brittany Joiner and I am a Trello enthusiast and Atlassian Community Leader. I'll be sharing with you a series of videos with my top tips on how to best use Trello...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event