Overview
Step 1: Get the ID for the city or location
Search for a location [MetaWeather]
Please fill in any necessary fields and click Run.
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
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.
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