Importing AccuWeather Data
This guide will walk through how to pull data from the AccuWeather API and put it directly into
Google Sheets.
Begin by acquiring an API key from AccuWeather, then setting up a request to pull data using Phlorin
in Google Sheets.
Getting Started
Install the API solution add-on from Google Marketplace.
Getting your AccuWeather API key
To request data from AccuWeather you must first register with the site and choose a subscription
plan. After this you can obtain a personal API key.
1. Register at developer.accuweather.com/ (Register button located at the top of the page).
2. After creating an account you will receive an email from AccuWeather. Use the email to
finish setting up your account.
3. After you are registered,, continue onto developer.accuweather.com and select
the Packages & Pricing section. Select the desired subscription plan
To get started for free, click “Get started now!”, under the Free optio
4. Next acquire your API key. First create an application; click on My Apps and then +Add a
new App
5. Create a new app with the following setup:
6. Return to the My Apps section and click on the newly created application. This will now
show the API key needed to pull data into Google Sheets using Phlorin.
Pulling data into Google Sheets
To get the most out of AccuWeather use Phlorin to pull data seamlessly into Google Sheets.
1. In your desired Sheets document, open Phlorin and create a new request:
Extensions > Phlorin > Open > Create a request
2. In the Application dropdown select or search for AccuWeather
3. Next choose what endpoint you are seeking. This example shows searching locations by
name
4. Take your API key from the AccuWeather website, My Apps, (see Begin by getting your
AccuWeather API key)
5. Add the location name
6. Make sure your desired sheet is selected and click Run
7. For subsequent pulls, locate the Key field. This will provide the location key to use in future
request
8. For other weather forecast and data, use the Key with different AccuWeather Endpoints to
accurately pull the data points you need
Creating Custom Request
With Phlorin and AccuWeather’s API documentation you can create URLs to run custom request.
Search their documentation for the desired request and adapt the URL to suit your needs.
This example shows how to retrieve a 5 day forecast:
- Application: Custom
- Method: GET
- Request URL: http://dataservice.accuweather.com/forecasts/v1/daily/5day/328763?
- apikey=abc12345
- OAuth: None
Adapting the URL to your needs:
The request URL requires formatting to fit with desired location and work with your API key.
In the example above, the location key, 328763 in the URL, is specifically for Springfield. The API
key, abc12345 is specific to the user whom is submitting the request.
URL Example: http://dataservice.accuweather.com/forecasts/v1/daily/5day/(DESIRED
LOCATION ID HERE)?apikey=(YOUR API KEY HERE)
Documentation
AccuWeather official API documentation: https://developer.accuweather.com/apis