I created a script on Make.com that retrieves the daily weather.
This module on Make.com creates a scenario that retrieves the daily weather for 7 days, calculates the average maximum temperature for the week, and then sends this information to GSheet.