Search API Connector Documentation

Print

Import AccuWeather Data to Google Sheets

In this guide, we will walk through how to pull data from the AccuWeather API directly into Google Sheets, using the API Connector add-on for Sheets. We will first get an API key from AccuWeather and then set up a request to pull in data to your spreadsheet.

Contents

Before You Begin

Click here to install the API Connector add-on from the Google Marketplace.

Part 1: Get Your AccuWeather API Key

Before we start pulling data from AccuWeather API, we need to register on their site, choose a subscription plan, and obtain our personal API key.

  1. Go to developer.accuweather.com/apis and click on the Register button in the upper right corner.
  2. You will get a pop-up window as shown below. Populate the textboxes with information.
    AccuWeather-API-1
  3. After that step, you will receive an email with a confirmation link, click on it!
  4. Next, click on the Packages & Pricing section to choose your subscription plan. If you want a free one, click on Get started now under the Limited Trial section.
    AccuWeather-API-2
  5. To get an API key, we need to create an application. Click on My Apps, and then +Add a new App
    AccuWeather-API-3
  6. Create a new app as shown in the example below.
    AccuWeather-API-4
  7. Go to the My Apps section, click on the created application and your API key will appear below, as depicted in the picture.
    AccuWeather-API-5

Part 2: Run an API Request

The easiest way to get started with the AccuWeather API is through API Connector’s built-in integration.

  1. Select Accuweather from the drop-down list of applications
  2. Choose an endpoint. We’ll start by searching locations by name.
    accuweather-library-endpoint
  3. Enter your API key and location name
    accuweather-library-parameters
  4. Click Run and you’ll see response data in your sheet. Pay attention to the Key field as this will provide the location key that you’ll use in subsequent requests.
    accuweather-library-response
  5. Now select any other endpoint of interest and subtitute in the key you just retrieved. You can pull in weather forecasts and other data points.
    accuweather-library-response2

Part 3: Create a Custom Request

If you prefer, you can create a custom request using any of the endpoints available in Accuweather’s API. When you create a custom request, you add your complete URL into the API URL field:

accuweather-custom

Part 4: Example API URLs

Here are some examples of custom API URLs. Check the AccuWeather documentation for the full set of available requests.

  • Get weather for top 50 cities
http://dataservice.accuweather.com/locations/v1/topcities/50?apikey=YOUR-API-KEY&language=en-us
  • Get hourly forecast for the next 12 hours in Athens:
http://dataservice.accuweather.com/forecasts/v1/hourly/12hour/28143?apikey=YOUR-API-KEY
  • Get current weather conditions in Athens:
http://dataservice.accuweather.com/currentconditions/v1/28143?apikey=YOUR-API-KEY
  • Get current weather conditions data for 150 cities worldwide:
http://dataservice.accuweather.com/currentconditions/v1/topcities/150?apikey=YOUR-API-KEY
  • Get severe weather alerts from official Government Meteorological Agencies and leading global weather alert providers for Athens:
http://dataservice.accuweather.com/alerts/v1/28143?apikey=YOUR-API-KEY
  • Get 1 day of weather alarms for Athens:
http://dataservice.accuweather.com/alarms/v1/1day/28143?apikey=YOUR-API-KEY
  • Get government issued storm information for a 2020:
http://dataservice.accuweather.com/tropical/v1/gov/storms/2020?apikey=YOUR-API-KEY

Part 5: API Documentation

Official API documentation: https://developer.accuweather.com/apis

Next Import ActiveCampaign Data to Google Sheets

Leave a Comment

Table of Contents