I am developing a operations and project app from a Marine services, and i want to include a SVG that shows weather info like wind speed, wind direction, temperature, etc. the license of my app is CORE so i want to take advantage of the possibitilities of create APIS with the webpage openweatherapp and my current license.
I had given some weather API ( Most probably it was OpenWeather API ) a try a couple of years ago. However the API response consists of some complex nested arrays that AppSheet return values option does not support. So I did not pursue further. You could of possibly circumvent this issue with more processing of the API response in the Google Apps Script(GAS) itself.
One good thing that was noy possibly available at the time of the above tips is AppSheet now supports GAS integration since last 3-4 years.