Hi,
We can pull data from API into excel using the macro and adding timer also possible. The API downloaded data can be created in sheets as per your requirement. I have very strong knowledge in excel macro. If you give me the API details, I can show a demo as quick as possible
Please let me know if I can help.
Thanks,
Yesu