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, 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: 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. 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

Alternatively, you can run your own custom requests instead of using API Connector’s pre-built integration, using any of the URLs shown in the API documentation. To create a custom request, add the complete URL into the request URL field.

accuweather-custom

To easily convert from a preset request to a custom API URL, tick the Add request URL box before running your preset request (under Output options). This will print out your complete API URL, which you can then copy/paste into the request URL field.

Part 4: API Documentation

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

Next Import ActiveCampaign Data to Google Sheets

Leave a Comment

Table of Contents