Log Rain in your city into Google Spreadsheet
Start today
Triggers (If this)
Queries (With)
Actions (Then that)
Popular Google Sheets and Weather Underground workflows and automations
-
5
-
-
Log the weather to GDrive everyday
9
-
-
Log rain in your city to a spreadsheet as it happens
9
-
-
At Sunset, log the weather
15
-
-
Track Weather
107
-
-
O tempo
1
-
-
Weather data to Google Drive spreadsheet
37
-
-
Log weather forecasts to a google spreadsheet
22
-
Useful Google Sheets and Weather Underground integrations
Triggers (If this)
-
Today's weather report
This Trigger retrieves today's current weather report within 5 minutes of the time you specify. NOTE: Pollen count available only in the USA.
-
New spreadsheet added to folder
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.
-
Tomorrow's weather report
This Trigger retrieves tomorrow's weather report within 5 minutes of the time you specify, depending on when forecast data is updated.
-
New worksheet in spreadsheet
This trigger fires when a new worksheet is added to a spreadsheet you specify.
-
Current temperature drops below
This Trigger monitors your local temperature and fires whenever the temperature drops below the value you provide.
-
New row added to spreadsheet
This trigger fires when a new row is added to a spreadsheet you specify.
-
Current temperature rises above
This Trigger monitors your local temperature and fires whenever the temperature rises above the value you provide.
-
Cell updated in spreadsheet
This trigger fires when a particular cell is updated within the spreadsheet you specify.
-
Current condition changes to
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.
-
Tomorrow's low drops below
This Trigger fires every time tomorrow’s forecasted low temperature drops below a value you provide.
-
Tomorrow's high rises above
This Trigger fires every time tomorrow’s forecasted high temperature rises above a value you provide.
-
Tomorrow's forecast calls for
This Trigger monitors changes in tomorrow’s forecasted weather condition.
-
Sunrise
This Trigger fires within 15 minutes of the sunrise in your location.
-
Sunset
This Trigger fires within 15 minutes of the sunset in your location.
-
Wind speed rises above
This Trigger fires every time the wind speed rises above a value you specify in your location.
-
Current pollen count rises above
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.
-
Current humidity level rises above
This Trigger monitors your local humidity and fires every time the humidity rises above the value you specify.
-
Current UV index rises above
This Trigger monitors your local UV levels and fires every time the UV index rises above the value you specify (0-16).
Today's weather report
This Trigger retrieves today's current weather report within 5 minutes of the time you specify. NOTE: Pollen count available only in the USA.
New spreadsheet added to folder
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.
Tomorrow's weather report
This Trigger retrieves tomorrow's weather report within 5 minutes of the time you specify, depending on when forecast data is updated.
New worksheet in spreadsheet
This trigger fires when a new worksheet is added to a spreadsheet you specify.
Current temperature drops below
This Trigger monitors your local temperature and fires whenever the temperature drops below the value you provide.
New row added to spreadsheet
This trigger fires when a new row is added to a spreadsheet you specify.
Current temperature rises above
This Trigger monitors your local temperature and fires whenever the temperature rises above the value you provide.
Cell updated in spreadsheet
This trigger fires when a particular cell is updated within the spreadsheet you specify.
Current condition changes to
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.
Tomorrow's low drops below
This Trigger fires every time tomorrow’s forecasted low temperature drops below a value you provide.
Tomorrow's high rises above
This Trigger fires every time tomorrow’s forecasted high temperature rises above a value you provide.
Tomorrow's forecast calls for
This Trigger monitors changes in tomorrow’s forecasted weather condition.
Sunrise
This Trigger fires within 15 minutes of the sunrise in your location.
Sunset
This Trigger fires within 15 minutes of the sunset in your location.
Wind speed rises above
This Trigger fires every time the wind speed rises above a value you specify in your location.
Current pollen count rises above
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.
Current humidity level rises above
This Trigger monitors your local humidity and fires every time the humidity rises above the value you specify.
Current UV index rises above
This Trigger monitors your local UV levels and fires every time the UV index rises above the value you specify (0-16).
Queries (With)
-
Current weather
Get the current weather
-
Current values of a row
This query returns the current values in a given row. Values from columns A-Z are available as ingredients.
-
Two day forecast
Two day forecast
-
Current value of a cell
This query returns the current value of a single cell in your spreadsheet.
-
History of humidity level rose above threshold
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.
-
History of rows added to spreadsheet
This query returns a list of when a new row is added to a spreadsheet you specify.
-
History of Wind speed rose above threshold
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.
-
History of when Cell was updated in spreadsheet
This query returns a list of when a particular cell was updated within the spreadsheet you specify.
-
History of pollen count rose above threshold
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.
-
History of spreadsheets added to folder
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.
-
History of Tomorrow's Forecast was above threshold alerts
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.
-
History of worksheets in spreadsheet
This query returns a list of when a new worksheet is added to a spreadsheet you specify.
-
History of Tomorrow's Forecast drops below alerts
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.
-
History of temperatre rose above threshold
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.
-
History of temperature dropped below threshold
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.
-
History of UV index rose above threshold
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.
-
History of Sunrises
This query returns a history of sunrises in your location. Note: this query will only return future events after this Applet is created.
-
History of Sunsets
This query returns a history of sunsets at your location.
-
History of specified weather conditions
This query returns a list of times when the observed weather changed to meet a specific condition (Rain, Snow, Cloudy, or Clear).
-
History of specified forecast conditions
This query returns a list of times when the forecasted weather changed to meet a specific condition (Rain, Snow, Cloudy, or Clear).
Current weather
Get the current weather
Current values of a row
This query returns the current values in a given row. Values from columns A-Z are available as ingredients.
Two day forecast
Two day forecast
Current value of a cell
This query returns the current value of a single cell in your spreadsheet.
History of humidity level rose above threshold
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.
History of rows added to spreadsheet
This query returns a list of when a new row is added to a spreadsheet you specify.
History of Wind speed rose above threshold
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.
History of when Cell was updated in spreadsheet
This query returns a list of when a particular cell was updated within the spreadsheet you specify.
History of pollen count rose above threshold
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.
History of spreadsheets added to folder
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.
History of Tomorrow's Forecast was above threshold alerts
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.
History of worksheets in spreadsheet
This query returns a list of when a new worksheet is added to a spreadsheet you specify.
History of Tomorrow's Forecast drops below alerts
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.
History of temperatre rose above threshold
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.
History of temperature dropped below threshold
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.
History of UV index rose above threshold
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.
History of Sunrises
This query returns a history of sunrises in your location. Note: this query will only return future events after this Applet is created.
History of Sunsets
This query returns a history of sunsets at your location.
History of specified weather conditions
This query returns a list of times when the observed weather changed to meet a specific condition (Rain, Snow, Cloudy, or Clear).
History of specified forecast conditions
This query returns a list of times when the forecasted weather changed to meet a specific condition (Rain, Snow, Cloudy, or Clear).
Actions (Then that)
-
Update cell in spreadsheet
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.
-
Add row to spreadsheet
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.
Update cell in spreadsheet
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.
Add row to spreadsheet
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.
Google Sheets and Weather Underground resources
IFTTT helps all your apps and devices work better together