Overview
Here we'll use the free MetaWeather API to get a weather forecast for the next 5+ days into Google Sheets, and use the SyncWith Addon to keep the forecast live automatically.
Step 1: Get the ID for the city or location
MetaWeather uses its own IDs, called the Where On Earth ID, or woeid for short. Punch in the city or location you're looking for to get its woeid.
Search for a location [MetaWeather]
Please fill in any necessary fields and click Run.
GET
Preview
View the API data, get a live Google Sheet dashboard
title | location_type | woeid | latt_long |
|---|---|---|---|
Get a live Google Sheet
Export your data to a google sheet, with the SyncWith Addon, or download to CSV
Automatically updated
Schedule your data to update hourly or daily
Add data sources
Import additional data from other apps
Build reports & dashboards
Easily build live reports within Google Sheets
Step 2: Use the ID to get the forecast
Grab the woeid from above, fill it in below, and you can get the weather forecast, then click
Get Google Sheet to get the forecast in Google Sheets with the SyncWith addon pre-installed to keep the forecast live automatically.Weather Forecast [MetaWeather]
Please fill in any necessary fields and click Run.
GET
Preview
View the API data, get a live Google Sheet dashboard
consolidated_weather.id | consolidated_weather.weather_state_name | consolidated_weather.weather_state_abbr | consolidated_weather.wind_direction_compass | consolidated_weather.created | consolidated_weather.applicable_date | consolidated_weather.min_temp | consolidated_weather.max_temp | consolidated_weather.the_temp | consolidated_weather.wind_speed | consolidated_weather.wind_direction | consolidated_weather.air_pressure | consolidated_weather.humidity | consolidated_weather.visibility | consolidated_weather.predictability | time | sun_rise | sun_set |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Get a live Google Sheet
Export your data to a google sheet, with the SyncWith Addon, or download to CSV
Automatically updated
Schedule your data to update hourly or daily
Add data sources
Import additional data from other apps
Build reports & dashboards
Easily build live reports within Google Sheets