Hi @Siru5
Have you tried using the forecast.solar integration? If not, I’d suggest adding the integration and comparing the forecast to your production. The decide how you might want to use it with your automation(s).
I don’t do EXACTLY what you want, but I do look at the weather forecast to determine the temperature setpoint for pre-cooling my home while the energy tariff is low. It is a very straightforward automation.
Also, if you are an advanced user, you may wish to look at EMHASS (an add-on), which uses sophisticated linear programming to determine the best time to run appliances according to various inputs (forecast, user history, etc.). I found it too difficult to use (couldn’t get things working), but others have had good success.