In this article we're going to use the OpenWeatherMap free API to pull weather forecasts for the next 7 days. OpenWeatherMap has a number of API endpoints, we're going to use One Call which returns a forecasts for the next hour, 48 hours, and 7 days.
This API method returns a lot of data, we've used the SyncWith Google Sheets Addon to select just the data we wanted, which is inside the
dailyfield, and inside there we took most of the data from the
feels_likefields, deleting the rest of the data that we didn't need.
First, you'll need an API key from OpenWeatherMap, to do that go and sign up for a free account.
Paste your API key into the box below labelled
Get the latitude and longitude of the place you'd like to get the weather for, I did this following the instructions
Get the coordinates of a placefrom google here: https://support.google.com/maps/answer/18539
Copy and paste the numeric values into the
By default I've set the units parameter to
imperialwhich will get you temperature in Fahrenheit, you can change it to
metricto get temperature in Celsius
Once you've filled in the values below, click Submit to get your data!
Please fill in any necessary fields and click Submit.
View the API response, get a live Google Sheet dashboard, or export to CSV