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