Trello api call

I’m needing export Trello info to google sheets and parce out the useful info from there for business analytics. I need to be able to pull this data in a visual way through something like Google Data Studio. I would need to tie in quickbooks at some point. I’d also like to run scheduled or triggered update/backup; either to a cloud drive or a physical drive.