If the website has an api you can connect it to Google Sheets and then use Templater Bot to automate it in After Effects. If it does not have an api then you will need to make some sort of data scraper yourself that collect the weather data into a json file and then you can use either Templater Bot or Open Sesame Server to automate the renders in AE.