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.
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.
- Install Amigo Data add-on in Google Sheets
- Get the AccuWeather API key
- Get the AccuWeather API endpoint URL
- 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.
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.
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!
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.
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.
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.
In the Current Conditions API, click Current Conditions for Top Cities under Top Cities.
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.
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.
Now, click cURL. The URL enclosed by the pair of quotation marks is the API URL.
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.
2. Enter the AccuWeather API endpoint URL in the API URL field.
3. Click the preview button to retrieve the data and see the preview.
4. Flatten the nested datasets. And click IMPORT.
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.
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.
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
Why do I get the “Unauthorized. API authorization failed” error?
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.
How do I get the weather data for a city in Google Sheets?
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.
How to get weather forecasts data in Google Sheets?
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