Connect Google Sheets to Weather Underground and unlock powerful automations

This Trigger retrieves today's current weather report within 5 minutes of the time you specify. NOTE: Pollen count available only in the USA.

This trigger fires when a new spreadsheet is added to a Google Drive folder you specify. Note: only works for spreadsheets created after the Applet turned on.

This Trigger retrieves tomorrow's weather report within 5 minutes of the time you specify, depending on when forecast data is updated.

This trigger fires when a new worksheet is added to a spreadsheet you specify.

This Trigger monitors your local temperature and fires whenever the temperature drops below the value you provide.

This trigger fires when a new row is added to a spreadsheet you specify.

This Trigger monitors your local temperature and fires whenever the temperature rises above the value you provide.

This trigger fires when a particular cell is updated within the spreadsheet you specify.

This Trigger monitors changes in the current weather condition. When one of those conditions is met the Trigger fires. Currently only these simple conditions are supported: Rain, Snow, Cloudy, Clear.

This Trigger fires every time tomorrow’s forecasted low temperature drops below a value you provide.

This Trigger fires every time tomorrow’s forecasted high temperature rises above a value you provide.

This Trigger monitors changes in tomorrow’s forecasted weather condition.

This Trigger fires within 15 minutes of the sunrise in your location.

This Trigger fires within 15 minutes of the sunset in your location.

This Trigger fires every time the wind speed rises above a value you specify in your location.

This Trigger monitors your local pollen levels and fires every time the pollen count rises above the value you specify (1-12). NOTE: Available only in the USA.

This Trigger monitors your local humidity and fires every time the humidity rises above the value you specify.

This Trigger monitors your local UV levels and fires every time the UV index rises above the value you specify (0-16).

Get the current weather

This query returns the current values in a given row. Values from columns A-Z are available as ingredients.

Two day forecast

This query returns the current value of a single cell in your spreadsheet.

This query monitors your local humidity and returns a list of times when the humidity rose above the value you specified. Note: this query will only return future events after this Applet is created.

This query returns a list of when a new row is added to a spreadsheet you specify.

This query returns a list of times when the wind speed rose above a value you specify in your location. Note: this query will only return future events after this Applet is created.

This query returns a list of when a particular cell was updated within the spreadsheet you specify.

This query monitors your local pollen levels and returns a list of times when the pollen count rose above the value you specified (1-12). NOTE: Available only in the USA. Note: this query will only return future events after this Applet is created.

This query returns a list of when a new spreadsheet is added to a Google Drive folder you specify. Note: only works for spreadsheets created after the Applet turned on.

This query returns a list of times when tomorrows forecasted high temperature rose above a value you provided. Note: this query will only return future events after this Applet is created.

This query returns a list of when a new worksheet is added to a spreadsheet you specify.

This query returns a list of alerts when tomorrows forecasted low temperature dropped below a value you provided. Note: this query will only return future events after this Applet is created.

This query monitors your local temperature and returns a list of times when the temperature rose above the value you provided. Note: this query will only return future events after this Applet is created.

This query monitors your local temperature and returns a list of times when the temperature dropped below the value you provide. Note: this query will only return future events after this Applet is created.

This query monitors your local UV levels and returns a list of times when the UV index rose above the value you specified (0-16). Note: this query will only return future events after this Applet is created.

This query returns a history of sunrises in your location. Note: this query will only return future events after this Applet is created.

This query returns a history of sunsets at your location.

This query returns a list of times when the observed weather changed to meet a specific condition (Rain, Snow, Cloudy, or Clear).

This query returns a list of times when the forecasted weather changed to meet a specific condition (Rain, Snow, Cloudy, or Clear).

This action will add a single row to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.

This action will update a single cell in the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created if the file doesn't exist.