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