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.
- Before You Begin
- Part 1: Get your AccuWeather API KEY
- Part 2: Create your API Request URL
- Part 3: Pull AccuWeather API data into Sheets
- Part 4: More API Examples
BEFORE YOU BEGIN
Click here to install the API Connector add-on from the Google Marketplace.
PART 1: GET YOUR ACUUWEATHER API KEY
Before we start pulling data from AccuWeather API, we will need to register on their site, choose a subscription plan and obtain our personal API key. Go to developer.accuweather.com/apis and click on the register button in the upper right corner. You will get a pop-up window shown below. Populate the textboxes with information. If you don’t have a business or business name, just put something random.
After that step, you will receive an email with a confirmation link, click on it! 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.
In order to get API key, we will need to create an application. Click on My Apps section, and after on Add a new App button.
Create a new app as shown in the example below.
Once we created the app, go to the My Apps section, click on the created application and your API key will appear below, as depicted in the picture.
PART 2: CREATE YOUR API REQUEST URL
We will create AccuWeather API requests based on the official documentation. Navigate yourself here to find a bunch of different APIs. If you click on some from the list, you will get already constructed API requests. Every designed request is followed by a short description of what you will get when you run it.
- API root: http://dataservice.accuweather.com/
PART 3: PULL ACCUWEATHER API DATA INTO GOOGLE SHEETS
In this section we will use locations and forecasts APIs, to get a location’s key and weather forecast for it.
- Open up Google Sheets and click Add-ons > API Connector > Open.
- In the Create tab, construct a link like this to get information for the top 50 cities worldwide in the English language (for language options, please have a look here):
3. Now create a new tab, give it a name and click Set current to use that tab as your data destination.
4. Give a name to your request and click run!
5. Now the pulled data will appear in your sheets. We got the top 50 cities worldwide with their keys that we will use in a Forecast API request.
To get a one day of daily forecast for Athens city, we will use key from the results we got in the previous request, and create an API link as shown below:
Following guidelines provided above, we will get a forecast for Athens.
PART 4: MORE EXAMPLE API URLS
Here we will present more API URL examples. We encourage you to go through the AccuWeather documentation for constructing even more requests!
- Get information about administrative areas in the US:
- Get hourly forecast for the next 12 hours in Athens:
- Get current weather conditions in Athens:
- Get current weather conditions data for 150 cities worldwide:
- Get severe weather alerts from official Government Meteorological Agencies and leading global weather alert providers for Athens:
- Get 1 day of weather alarms for Athens:
- Get government issued storm information for a 2020: