Weather Integrations
Below is a listing of the top weather APIs accessed through API Connector for Google Sheets. These APIs enable hobbyists and analysts to pull forecasts and weather data into their spreadsheet.
Need something else? Connect to nearly any JSON/XML/CSV API with a custom connection, or see all integrations.
#1 OpenWeatherMap API
Open Weather Map
Description
OpenWeatherMap is a popular service providing global weather data via API.
Top Endpoints
/data/2.5/forecast: Get a 5 day forecast/data/2.5/onecall: Get essential data in one call/data/2.5/weather: Get current weather
#2 Accuweather API
Accuweather
Description
Accuweather provides access to its weather service via API.
Top Endpoints
/currentconditions/v1/{locationKey}: Get current weather/currentconditions/v1/{locationKey}/historical: Get past weather/currentconditions/v1/topcities/{group}:Get weather for top cities
#3 Weatherstack
Weatherstack
Description
Weatherstack is a real-time weather API.
Top Endpoints
/current: Get current weather
#4 7Timer
7Timer
Description
7Timer is a totally free weather API with a focus on weather for astronomical purposes.
Top Endpoints
/astro.php: Get weather for astronomy/civil.php: Get 8-day weather forecast/meteo.php: Get weather for meterology
#5 Weatherbit
Weatherbit
Description
Weatherbit is a global weather data service.
Top Endpoints
/current?lat={lat}&lon={lon}: Get current weather/history/daily?lat={lat}&lon={lon}: Get historical data/current/airquality?lat={lat}&lon={lon}: Get air quality