Get Data out of Trello using API and use it to insert a value into an Office 365 online spreadsheet

PLEASE ONLY TRELLO EXPERTS APPLY FOR THIS PROJECT. We manufacture automotive exhaust parts. We use [login to view URL] to manage our production workflow. The card titles are structured as follows: [Part Number] x [Quantity] For dashboard purposes, we want to be able to calculate a live dollar value of the finished goods sitting on our factory floor, before they are entered into our ERP. (Trello runs independently of our ERP, there is no direct integration). I want a utility developed that is able to use the Trello API to look at the part number, look it up in a separate table with a value assigned to the part number, and then calculate the total value of the card by multiplying the value by the card quantity. I want to be able to specify the List Names that the utility will look at, as these can change on a daily basis. Once the utility has calculated the total value of all the cards in the specified lists, it will then update a cell in an Office 365 spreadsheet we use to calculate production data.