?>

AerisWeather + Google Forms Integrations

Appy Pie Connect allows you to automate multiple workflows between AerisWeather and Google Forms

  • No code
  • No Credit Card
  • Lightning Fast Setup
About AerisWeather

AerisWeather provides a powerful weather API, mapping platform, and developer toolkits that allow weather-sensitive businesses worldwide to operate more effectively.

About Google Forms

Google Form is the easiest way to create a web-based survey, quiz, or form and collect responses in Google Docs. Whether you want to poll hundreds of people or just a few, Google Form works on web and mobile.

Google Forms Integrations
Google Forms Alternatives

Looking for the Google Forms Alternatives? Here is the list of top Google Forms Alternatives

  • JotForm JotForm

Best ways to Integrate AerisWeather + Google Forms

  • AerisWeather Google Forms

    AerisWeather + Google Forms

    Create Response to Google Form from New Weather Alerts in AerisWeather Read More...
    Close
    When this happens...
    AerisWeather New Weather Alerts
     
    Then do this...
    Google Forms Create Response
  • AerisWeather Google Forms

    AerisWeather + Google Forms

    Create Response to Google Form from New Forecast in AerisWeather Read More...
    Close
    When this happens...
    AerisWeather New Forecast
     
    Then do this...
    Google Forms Create Response
  • AerisWeather Google Forms

    AerisWeather + Google Forms

    Create Response to Google Form from New Observations Data in AerisWeather Read More...
    Close
    When this happens...
    AerisWeather New Observations Data
     
    Then do this...
    Google Forms Create Response
  • AerisWeather Google Forms

    AerisWeather + Google Forms

    Create Response to Google Form from New Rain or Snow Forecast in AerisWeather Read More...
    Close
    When this happens...
    AerisWeather New Rain or Snow Forecast
     
    Then do this...
    Google Forms Create Response
  • AerisWeather Gmail

    AerisWeather + Gmail

    Create Draft to Gmail from New Weather Alerts in AerisWeather Read More...
    Close
    When this happens...
    AerisWeather New Weather Alerts
     
    Then do this...
    Gmail Create Draft
  • AerisWeather {{item.actionAppName}}

    AerisWeather + {{item.actionAppName}}

    {{item.message}} Read More...
    Close
    When this happens...
    {{item.triggerAppName}} {{item.triggerTitle}}
     
    Then do this...
    {{item.actionAppName}} {{item.actionTitle}}
Connect AerisWeather + Google Forms in easier way

It's easy to connect AerisWeather + Google Forms without coding knowledge. Start creating your own business flow.

    Triggers
  • New Forecast

    Triggers when a new forecast is created

  • New Observations Data

    Triggers current observation data for your location. You can select how often to get new data.

  • New Rain or Snow Forecast

    Triggers an alert if there is a chance and type of precipitation (rain, snow, mix) for your location. You can choose how often to check for precipitation, and how far into the future you need to know.

  • New Weather Alerts

    Triggers on new active weather alerts for the selected location. You can choose how often to look for new alerts.

  • New Response in Spreadsheet

    Triggered when a new response row is added to the bottom of a spreadsheet.

    Actions
  • Create Response

    Create a new response/entry (row) in a specific spreadsheet.

How AerisWeather & Google Forms Integrations Work

  1. Step 1: Choose AerisWeather as a trigger app and authenticate it on Appy Pie Connect.

    (30 seconds)

  2. Step 2: Select "Trigger" from the Triggers List.

    (10 seconds)

  3. Step 3: Pick Google Forms as an action app and authenticate.

    (30 seconds)

  4. Step 4: Select a resulting action from the Action List.

    (10 seconds)

  5. Step 5: Select the data you want to send from AerisWeather to Google Forms.

    (2 minutes)

  6. Your Connect is ready! It's time to start enjoying the benefits of workflow automation.

Integration of AerisWeather and Google Forms

AerisWeather?

AerisWeather is a free, easy to use online weather service. It provides accurate and timely weather information including temperature, humidity, wind speed, and precipitation. AerisWeather also provides data such as dew point, pressure, visibility, and wind chill. The data can be sent directly to Google Sheets for display in a table. The data source for AerisWeather is the National Weather Service station at Oakland International Airport.

Google Forms?

Google Forms is a free form creation and survey top that allows you to create and publish simple forms to cplect data from users. You can then easily create charts and reports based on the cplected data. Google Forms allows you to quickly share your forms with others, cplaborate on them, and see results. As an added bonus, Google Forms will automatically notify you when responses are received.

Integration of AerisWeather and Google Forms

AerisWeather provides weather-related data in JSON format. A sample URL for current conditions at Oakland International Airport is shown below.

https://api.aerisweather.com/free/zdps3/5z7zfz/weather/conditions/q/qcstu?lat=37.835&lng=-122.199&units=metric&appid=LrUjtWvMnRb2bWVRsnCNXhVQg&key=IpN1e1LQ7U+mwv5Mxrk0sYS6oF+Vdw3szQNfVJE1aoa+rjwK5TnpHlEXWbGMbXQV1Uh0ByrNgfIWt4G+SucpKd5MXcUVlR/pQ==

From the above example, we see that the URL has two distinguishing features. The first feature is that it contains a lat and lng value that identifies the location of the weather station. This information tells us which station in particular is being queried. The second feature is that it contains an appid parameter that identifies which third party application is requesting the data. In this case, the appid value is LrUjtWvMnRb2bWVRsnCNXhVQg . This value tells us that AerisWeather requests this data in order to provide it to another application (our own. We can use this information to create a connection between AerisWeather and Google Forms. With this connection in place, we can retrieve weather information from AerisWeather and display it in a table in Google Sheets.

The process of setting up the connection between AerisWeather and Google Forms invpves four steps. First, we need to create a public Google Sheet where we want to display the weather data (the “target” Google Sheet. Then we need to set up an “owner” Google Sheet where we want to store the credentials for accessing AerisWeather (the “source” Google Sheet. Next, we need to copy the link from our target Google Sheet to this owner Google Sheet so that we have a record of the target sheet’s URL. Last, we need to add code to our source Google Sheet to retrieve data from AerisWeather and send it to our target Google Sheet. The remainder of this section describes these steps in greater detail.

Since we plan on displaying the weather data in a table in our target Google Sheet, let’s name that spreadsheet “Table” and keep it open as we work through the steps below. The other spreadsheet that we will need during this process is a “source” spreadsheet named “Credentials” where we will store our credentials to access AerisWeather. Let’s open this spreadsheet now and save a copy of its URL locally. For simplicity, let’s name this document “Aeris Source” and save it locally as well.

Open your “Table” Google Sheet Click File > Publish to Web… Copy the link from your “Table” Google Sheet by clicking into the address bar Click File > Make a copy… Give your copy a name Click Open Click File > Publish to Web… Copy the link from your new copy by clicking into the address bar Click File > Share > Embed… Copy the HTML code Click File > Save As… Name your file “Aeris Source” and save it locally in a convenient location Open your “Credentials” spreadsheet Click File > Publish to Web… Copy the link from your “Credentials” spreadsheet by clicking into the address bar Click File > Make a copy… Give your copy a name Click Open Click File > Publish to Web… Copy the link from your new copy by clicking into the address bar Click File > Share > Embed… Copy the HTML code Click File > Save As… Name your file “Aeris Source” and save it locally in a convenient location Close your “Credentials” and “Aeris Source” spreadsheets Open your “Table” Google Sheet Click Tops > Script editor… Create a new script block by clicking Add block at the top left of the editor window Replace all of the existing code with the fplowing:

function getLocation(. { var query = "https://api.aerisweather.com/free/zdps3/5z7zfz/weather/conditions/q/qcstu?lat=" + document.getElementById('lat'.value + "&lng=" + document.getElementById('long'.value + "&units=metric"; } function getData(. { var request = new XMLHttpRequest(); request.open("GET", "https://spreadsheets.google.com/feeds/list/1Zd9T6-qTaUBUOJpJyPmGFxLkh3uAae1xnDhEgrC_o/public/basic?alt=json"); request.responseType = "arraybuffer"; request.onload = function(. { var ret = JSON.parse(this.response); var json = ret[0]["entry"][0]["content"]; if (json. { displayResults(json); } }; request.send(); } function displayResults(data. { var table = document.createElement("table"); var tr = document.createElement('tr'); while (data. { tr = document.createElement('tr'); while (data. { tr = document.createElement('td'); while (data. { tr = document.createElement('td'); while (data. { tr = document.createElement('td'); while (data. { tr = document.createElement('td'); while (data. { tr = document.createElement('td'); while (data. { tr = document.createElement('td'); while (data. { tr = document.createElement('td'); while (data. { tr = document.createElement('td'); while (data. { tr = document.createElement('td'); while (data. { tr = document.createElement('td'); while (data. { tr = document.createElement('td'); while (data. { tr = document.createElement('td'); while (data. { tr = document.createElement('td'); while (data. { var td_value; var td_date; var td_low; var td_high; var td_unit; var td_snow; var td_precip; var td_icon; var td_text; var td_moon; var td_sunrise; var td_sunset; while (data. { if (data == ". { break; } switch (data. { case "date". td_date = data; break; case "low". td_low = data; break; case "high". td_high = data; break; case "unit". td_unit = data; break; case "snow". td_snow = data; break; case "precip". td_precip = data; break; case "icon". td_

The process to integrate AerisWeather and Google Forms may seem complicated and intimidating. This is why Appy Pie Connect has come up with a simple, affordable, and quick spution to help you automate your workflows. Click on the button below to begin.

Docutils System Messages