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 see a modal asking you to enter your name and email address and accept their terms and conditions.
  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 wish to get started for free, click on Get started now under the Limited Trial section.
    AccuWeather-API-2
  5. To get an API key, 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. Keep this key handy as we'll use it shortly.
    AccuWeather-API-5

Part 2: Pull Data from AccuWeather to Sheets

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

  1. In Sheets, open API Connector and create a new request (Extensions > API Connector > Open > Create request)
  2. Select Accuweather from the drop-down list of applications
  3. Choose an endpoint. We'll start by searching locations by name.
    accuweather-library-endpoint
  4. Enter your API key and location name
    accuweather-library-parameters
  5. 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
  6. 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

Alternatively, you can run your own custom requests instead of using API Connector’s pre-built integration, using any of the request URLs shown in Accuweather's API documentation. Here's an example of how to set up a custom request to retrieve a 5 day forecast, just substitute in your own desired location ID where it says 4-315078_1_AL (get your location ID from their Locations API).

  • Application: Custom
  • Method: GET
  • Request URL: http://dataservice.accuweather.com/forecasts/v1/daily/5day/4-315078_1_AL?apikey=11111111111
  • OAuth: None
accuweather-custom

Part 4: API Documentation

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

6 thoughts on “Import AccuWeather Data to Google Sheets”

  1. I am new to app development and spreadsheets. So this is definitely a helpful tool. It is helping me get an understanding of how to make API calls. As of now, the data being returned is not the exact data that I want. However this has nothing to do with API Connector. As a freshman developer, these are issues that I have to work out. So thank you for a great tool.

    Reply
  2. This is fantastic! Great guide - simple enough for even a tech novice to make it work. Is there a way to get the 15 day forecast rather than just the 5?

    Reply
    • Awesome, I'm glad you liked it! You can get the 15 day forecast by simply changing "5day" to "15day" in a custom request, e.g.http://dataservice.accuweather.com/forecasts/v1/daily/15day/4-315078_1_AL?apikey=11111111111/. However, Accuweather only provides access to that via their Elite plan (info). Only the 5 day forecast is available on their free plan.

      Reply
  3. Hi, I have a API key yet i am still getting this error, would you be able to help me with this?

    1) : Completed with errors
    - We received an error from accuweather.com (401) show response
    {"Code":"Unauthorized","Message":"Api Authorization failed","Reference":"/locations/v1/search?q=Brazil&apikey=SOg7H0i1vlPWkAt0nfpYpq4lA7AeJ6ky"}

    Reply

Leave a Comment

Jump To