Search API Connector Documentation
Import Weatherstack Data to Google Sheets
In this guide, we’ll walk through how to pull realtime weather data from the Weatherstack API directly into Google Sheets, using the API Connector add-on for Sheets.
We'll first get an API key from Weatherstack, and then set up a request to pull in weather data from Weatherstack to your spreadsheet.
- Before You Begin
- Part 1: Get your Weatherstack API Key
- Part 2: Pull Weatherstack API Data into Sheets
- Part 3: Weatherstack API Notes
- Part 4: API Documentation
Before You Begin
Click here to install the API Connector add-on from the Google Marketplace.
Part 1: Get Your Weatherstack API Key
- If you haven't already, sign up for an account at https://weatherstack.com/product. For this walkthrough, the free plan is fine.
- You will automatically be directed to a quickstart page containing your API key. Keep it handy as we'll need it shortly. That's it! You now have access to the Weatherstack API.
Part 2: Pull Weatherstack API Data into Sheets
For this example, we'll get current weather for Los Angeles. Substitute in your own API key where it says
- Open up Google Sheets and click Extensions > API Connector > Open > Create request.
- In the request form enter the following:
- Request URL:
- Create a new tab and click Set current to use that tab as your data destination.
- Name your request and click Run. A moment later you’ll see weather data populate your Google Sheet:
Part 3: Weatherstack API Notes
- Locations can be identified by their name (
query=New York), zip code (
query=10001), latitude/longitude (
query=40.7831,-73.9712), or IP address (
- Append query strings
units=sfor scientific, and
units=ffor Fahrenheit. For example:
- Other types of weather data, including historical weather, historical time-series, and weather forecasts are available via Weatherstack's paid plans.
Part 4: API Documentation
Official API documentation: https://weatherstack.com/documentation