Import AccuWeather Data To Google Sheets

Import AccuWeather data to Google Sheets
Reading Time: 6 minutes

In this tutorial, you’ll learn how to:
– Get the AccuWeather API key
– Get AccuWeather API endpoints URL
– Import weather data to Google Sheets
– Auto-update weather reports in Google Sheets

In the snippet below is a sample of weather data imported into Google Sheets from AccuWeather.

Weather data in  Google Sheets from AccuWeather

AccuWeather is one of the most widely used weather services. It has minute-by-minute forecast data as well as data of forecasting range up to 90 days and publicly available historical data for one year.

Most of these data are available to the public and can be pulled to Google Sheets where we can analyse the data and throw some light on the raw data. Google Sheets’ various data visualisations tools such as charts and pivot tables make this a breeze.

So, let’s learn how to pull real-time as well as historical weather data into Google Sheets with AccuWeather API using a data automation tool called Amigo. Using the Amigo add-on, we can create a weather Google Sheets integration and import weather data into Google Sheets.

Here are the steps to import weather data into Google Sheets with AccuWeather API.

  1. Install Amigo Data add-on in Google Sheets
  2. Get the AccuWeather API key
  3. Get the AccuWeather API endpoint URL
  4. Import the weather data to Google Sheets

How to import AccuWeather data to Google Sheets

Follow these steps to import set up a weather Google Sheets integration and import weather data into Google Sheets using AccuWeather API.

Step 1: Install the Amigo Data add-on in Google Sheets

The Amigo add-on allows us to integrate AccuWeather API with Google Sheets and import weather data into Google Sheets. Get it from the Google Workspace Marketplace by clicking the link below.

Amigo Installation link

Install Amigo to import AccuWeather data to Google Sheets

Once the installation is complete, we can move on to the next step, which is getting the AccuWeather API key.

Step 2: Create AccuWeather API key

In order to retrieve weather data from AccuWeather and import weather data into Google Sheets, we’ll need the AccuWeather API key.

Here are the steps to get the AccuWeather API key.

1. Register on AccuWeather Developer platform

Go to the AccuWeather Developer platform and click “Register” to create a new account to get an AccuWeather API key.

Register on AccuWeather developer to get an AccuWeather API key

2. Choose a subscription plan

Once you’ve created an account, click PACKAGES & PRICING and pick a subscription plan to use the AccuWeather API. Just choose the free one (for now; you can always updrade later should you need to) and click Get Started now! 

Choose a subscription option to use the AccuWeather API

You’ll be redirected to the My Apps section.

3. Create an app to generate AccuWeather API key

On the My Apps page, click Add a new App. Fill in the details and click CREATE APP.

Creating an app to generate AccuWeather API key

Congrats! You’ve created your app. We can use this app to create a weather-Google Sheets integration. We now need to get the AccuWeather API key.

4. Get the API key

To get the AccuWeather API key, go to MY APPS and click on the app you have created to get the API key.

AccuWeather API key

Now that we’ve got the AccuWeather API key, it’s time to get the endpoint of the weather data to import into Google Sheets.

Step 3: Get the AccuWeather API endpoint URL

Go to the AccuWeather API documentation by clicking API REFERENCE.

Here, we’ll find a list of the types of weather data we can retrieve with AccuWeather API.

As an example, let us import the weather data for the top 50 cities worldwide. So we click the Current Conditions API.

List of AccuWeather API endpoints

In the Current Conditions API, click Current Conditions for Top Cities under Top Cities.

Current conditions of top 50 cities API endpoint

In the Resource URL, replace {group} with 50 as we want the information for the top 50 cities.

Then under Query Parameters, enter the AccuWeather API key in the box, and click Sent this request.

Getting the URL for the data

If everything goes well, you will see a result like the one shown below. If for some reason you get some kind of error such as 401 error (Unauthorized. API authorization failed), try editing your app and verify that MinuteCast is set to None.

Success message for generating the API URL

Now, click cURL. The URL enclosed by the pair of quotation marks is the API URL.

API URL for the top 50 cities weather conditions

Copy the AccuWeather API endpoint URL excluding the quotation marks. This will be used to import AccuWeather data to Google Sheets.

Step 4: Import AccuWeather data to Google Sheets

To import AccuWeather data to Google Sheets, follow these steps:

1. Launch Amigo Data in Google Sheets.

Launch Amigo to import AccuWeather data to Google Sheets

2. Enter the AccuWeather API endpoint URL in the API URL field.

AccuWeather API endpoint URL

3. Click the preview button to retrieve the data and see the preview.

4. Flatten the nested datasets. And click IMPORT.

Preview of the weather data to import to Gogle Shets

The weather data will be imported into Google Sheets in a few moments.

Below is a snippet of the weather data imported into Google Sheets using AccuWeather API.

Data imported from AccuWeather to Google Sheets

Should you want to edit the data, you can do so from the View Reports menu.

  • Expand the menu
  • Select the report to edit under Your Reports
  • Click Edit Report and then PREVIEW
  • Once the editing is done, click UPDATE
  • Then finally click Save & Run.

Auto-update the weather data in Google Sheets

To get the weather data in Google updated automatically in regular intervals, set a refresh schedule. Choose the update frequency and set the time. And then click Yes, set the refresh timing. The weather data you’ve imported into Google Sheets will be updated automatically.

You can also set the refresh schedule later for any data you’ve imported. From the Amigo sidebar, click View Reports, select the import, and set the refresh schedule. Then click Save & Run.

Setting refresh schedule for automatic update

Alerts via email or Slack

You can get the report sent to your email or a Slack channel if you want to.

To set up an alert, click Get Alerts→Add alert data+. Edit the details and click Set Alert.

Conclusion

Using Amigo Data we can easily create a weather integration with Google Sheets with AccuWeather API. We can then get current weather data in Google Sheets, as well as AccuWeather historical data in Google Sheets.

There are various other things you can do with the AccuWeather API such as importing weather information for a specific city, historical data and forecast information and so on. The process is the same as described here. You can get Amigo Data and try them yourself. I bet you’ll like it.


FAQs

You could be getting the AccuWeather “API authorization failed” error because you’re trying to access data that you’re not subscribed to or because the scope of your AccuWeather API is limited. If you get this error and you’re on the free plan, then edit your app and make sure that Minute Cast is set to None.

To get the weather data for a specific city or region, click the Current Conditions API. Then enter the unique ID for the city/region in the API URL.

The city/region unique ID can be found from the AccuWeather URL for that city’s weather page. For example, in the weather forecasts in AccuWeather for New Delhi: https://www.accuweather.com/en/in/new-delhi/187745/weather-forecast/187745. Here 187745 is the unique ID.

To retrieve weather forecasts data and import them to Google Shees, click the Forecast API. Then select the type of forecast data–daily or hourly–and the duration. And then enter the unique ID for the location and the AccuWeather API key.

See also

There are plenty of other things that you can use Amigo Data for such as importing data from Google Trends, YouTube Analytics, Facebook Ads and Google Search Console among others. You can check out our blog for tutorials on them.

Some articles you may be interested in:

Export Google Ads data to Google Sheets

Export Snowflake data to Google Sheets

Import Skyscanner Data To Google Sheets

X
Hire expert data analysts on-demand. Get 30 Days Free Trial