Log Rain in your city into Google Spreadsheet
Start today
Popular Google Sheets and Weather Underground workflows and automations
- Log rain in your city to a spreadsheet as it happens
- Log the weather to GDrive everyday
- Log weather forecasts to a google spreadsheet
- Write sunrise time and weather condition to a google spreadsheet
- O tempo
- Track Weather
- Weather data to Google Drive spreadsheet
- At Sunset, log the weather
Useful Google Sheets and Weather Underground integrations
Triggers (If this)
- Today's weather reportThis 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 folderThis 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 reportThis Trigger retrieves tomorrow's weather report within 5 minutes of the time you specify, depending on when forecast data is updated.
- New worksheet in spreadsheetThis trigger fires when a new worksheet is added to a spreadsheet you specify.
- Current temperature drops belowThis Trigger monitors your local temperature and fires whenever the temperature drops below the value you provide.
- New row added to spreadsheetThis trigger fires when a new row is added to a spreadsheet you specify.
- Current temperature rises aboveThis Trigger monitors your local temperature and fires whenever the temperature rises above the value you provide.
- Cell updated in spreadsheetThis trigger fires when a particular cell is updated within the spreadsheet you specify.
- Current condition changes toThis 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 belowThis Trigger fires every time tomorrow’s forecasted low temperature drops below a value you provide.
- Tomorrow's high rises aboveThis Trigger fires every time tomorrow’s forecasted high temperature rises above a value you provide.
- Tomorrow's forecast calls forThis Trigger monitors changes in tomorrow’s forecasted weather condition.
- SunriseThis Trigger fires within 15 minutes of the sunrise in your location.
- SunsetThis Trigger fires within 15 minutes of the sunset in your location.
- Wind speed rises aboveThis Trigger fires every time the wind speed rises above a value you specify in your location.
- Current pollen count rises aboveThis 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 aboveThis Trigger monitors your local humidity and fires every time the humidity rises above the value you specify.
- Current UV index rises aboveThis Trigger monitors your local UV levels and fires every time the UV index rises above the value you specify (0-16).
Queries (With)
- Current weatherGet the current weather
- Current values of a rowThis query returns the current values in a given row. Values from columns A-Z are available as ingredients.
- Two day forecastTwo day forecast
- Current value of a cellThis query returns the current value of a single cell in your spreadsheet.
- History of humidity level rose above thresholdThis 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 spreadsheetThis query returns a list of when a new row is added to a spreadsheet you specify.
- History of Wind speed rose above thresholdThis 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 spreadsheetThis query returns a list of when a particular cell was updated within the spreadsheet you specify.
- History of pollen count rose above thresholdThis 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 folderThis 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 alertsThis 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 spreadsheetThis query returns a list of when a new worksheet is added to a spreadsheet you specify.
- History of Tomorrow's Forecast drops below alertsThis 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 thresholdThis 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 thresholdThis 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 thresholdThis 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 SunrisesThis query returns a history of sunrises in your location. Note: this query will only return future events after this Applet is created.
- History of SunsetsThis query returns a history of sunsets at your location.
- History of specified weather conditionsThis 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 conditionsThis query returns a list of times when the forecasted weather changed to meet a specific condition (Rain, Snow, Cloudy, or Clear).
Actions (Then that)
- Add row to spreadsheetThis 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 spreadsheetThis 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.
IFTTT helps all your apps and devices work better together