Import AccuWeather Data To Google Sheets

Import AccuWeather Data To Google Sheets
Reading Time: 5 minutes

In this tutorial, you’ll learn how to
– Get the API key from AccuWeather
– Get the endpoints URL for the data to be imported
– Import AccuWeather data to Google Sheets

AccuWeather is one of the most widely used weather services. Its data is used by journalists, media, businesses, and government entities worldwide. It has a vast database with weather data for all major cities around the globe.

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 exported to databases such as Google Sheets. You can then analyse the historical trends, make an informed prediction, compare the data for different regions or dates and plenty of other things.

So, let’s learn how we can import real-time AccuWeather data to Google Sheets.

↠ Getting the tool to import the data
↠ Getting the API key
↠ Fetching the API URL
↠ Importing data from AccuWeather to Google Sheets
↠ Setting refresh schedule
↠ Alerts via email or Slack

Step 1: Getting the tool to import AccuWeather data to Google Sheets

We need a tool with which to import AccuWeather data to Google Sheets. For this, we’ll use Amigo Data, a simple but versatile Google Sheets extension that’s easy to use, rich in features, and gives you the ability to pull data from several different sources.

You can get it from the Google Workspace Marketplace here.

Install Amigo Data from Google Mareketplace

Alternatively, you can open a Google Sheets document, then go to Extensions→Add-ons→Get add-ons. And search for Amigo Data and install.

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

Step 2: Getting the API key

In order to access the Yahoo Finance database, we’ll need a key called the API key. It is a code used to identify and authenticate access.

Register on AccuWeather

To get your AccuWeather API key, go to https://developer.accuweather.com/ and register to create a new account.

Choose a plan (a free one will do)

Once you’ve created an account, click PACKAGES & PRICING and pick a subscription plan. Just choose the free one (for now) and click Get Started now! 

AccuWeather subscription plan

You’ll be redirected to a new page.

Create an app

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

Details for creating application

Congrats! You’ve created your app. Now we can get the API key.

Get the API key

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

Step 3: Fetching the API URL

Now that we’ve got the API key, it’s time to get the endpoint for the data we want to import. We’ll need to go to the API documentation page and get the URL using the key we’ve created. 

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

API endpoint for current conditions

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, paste the 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. Copy that, excluding the quotation marks.

API URL for the top 50 cities weather conditions

Step 4: Importing AccuWeather data to Google Sheets

Now that we have got the resource we need to import the data, we can actually begin importing the data.

  1. Go to Google Sheets and open a new spreadsheet. Then go to Extensions→Amigo Data→Connect.
  2. From the list of sources, select Custom API.
  3. Keet GET as the option, and under API URL, paste the URL you’ve copied from AccuWeather.
  4. Leave everything else as they are and click PREVIEW.

The preview data is cluttered and unorganised. So make sure to organise and delete the information you don’t require by clicking the FLATTEN button.

Flattening the data from the preview page

Here you have the option to flatten or delete the information you don’t want to import. It’s recommended that you flatten all the options so that you have the data in a more readable format.

Once all that is done, click the IMPORT button. The data will be imported into Google Sheets in a couple of seconds.

Below is a sample of data exported from AccuWeather to Google Sheets

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 the PREVIEW
  • Once the editing is done, click UPDATE
  • Then finally click Save & Run

Setting refresh schedule

To get the information updated periodically, click the report you want to update automatically, toggle on the Refresh Schedule and select the schedule–hourly, daily, weekly or custom days.

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

Importing AccuWeather data to Google Sheets with Amigo Data is an easy and fun process. It may at first seem like a long process but as you get familiar with it, it becomes easier and quicker.

There are various other things you can do with it 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.

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:

https://blog.tryamigo.com/export-google-ads-data-to-google-sheets/

https://blog.tryamigo.com/importing-mysql-data-to-google-sheets/

https://blog.tryamigo.com/export-data-from-snowflake-to-google-sheets/