Google Sheet with data retrieved from APIs or PHP/Node Framework (that will also write data and send alerts based on triggers)

STOP! Please read the brief twice before replying. If you bid on this before reading I will have to report your bid. For those that are I left, I look forward to working with your skills and seeing what kind of creative solution you can come up with. I require a Google Sheet that calls 6 public APIs and; -format values from APIs into a specific structure -update API results with a refresh button - store results at set intervals - set trigger to send an email or slack messege when certain conditions are met - set trigger to log time when certain conditions are met -set up some light conditional formatting There’s three possible ways the data could be added to the sheet: Use CCTX to create and application (or API) to get the data back in a consistent way from the 6 APIs [login to view URL] or Use Google Script to get data via the CCTX library or Or manually adding data using the individual APIS, for example: [login to view URL] [login to view URL] [login to view URL] A Javascript / Node solution is a plus. Could you please provide me with: Expected turn around time A short description of the tools / methods you intend to use (just to make sure you understand the job) Then we can discuss the project further and any ideas you might have to add and work out a fair price.