How to automate GET requests and view/save the response data sent by the API?

My question: I’d like to run a series of GET requests and be able to view and save the response data sent by the API. For example: I’d like to configure something to get the weather data of 3 cities every 24 hours automatically and at the end of the day download all these data and store it in a DB.

I’m aware of the collections run but is there something where I can automatically schedule the run of a collection to get the data and not the test results [Pass/Fail].

I’ve already tried: I’ve tried Collections Run & Monitors but again it is something which needs to be invoked manually every time and I cannot see the response sent by the web API.

Please advise on how to proceed with this. Any help is appreciated! Thank you.