I’m looking to provide data from the following information into a Google Sheet, but I’m having a difficult time finding the easiest method for doing this. The two inputs I have will be zip code and date, while I’m looking to output basic weather forecasts like high temperature, windspeed, and precipitation percentage. I would really appreciate any help or guidance.

EXAMPLE

I have tried to use a handful of different weather providers, and have been able to get current weather data, but have yet to be able to get forecast data for future dates. I realize that it won’t be possible more than 7-10 days out, but that is all I am looking for.