Create a Google Spreadsheet for your room's dropping carbon dioxide levels
Start today
Popular Google Sheets and Netatmo Weather Station workflows and automations
- Log strong wind gusts in my Google Drive
- Create a Google Spreadsheet for your room's rising carbon dioxide levels
- Create a rainfall log in a Google spreadsheet
- If environment is too noisy then log it to Google Drive spreadsheet for further tracking
- Recording the daily rainfall in a Google Spreadsheet.
Useful Google Sheets and Netatmo Weather Station integrations
Triggers (If this)
- Air pressure rises aboveThis Trigger fires every time the ambient air pressure rises above a value you specify.
- 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.
- Air pressure drops belowThis Trigger fires every time the ambient air pressure drops below a value you specify.
- New worksheet in spreadsheetThis trigger fires when a new worksheet is added to a spreadsheet you specify.
- Carbon dioxide rises aboveThis Trigger fires every time the carbon dioxide rises above a value you specify.
- New row added to spreadsheetThis trigger fires when a new row is added to a spreadsheet you specify.
- Carbon dioxide drops belowThis Trigger fires every time the carbon dioxide drops below a value you specify.
- Cell updated in spreadsheetThis trigger fires when a particular cell is updated within the spreadsheet you specify.
- Humidity rises aboveThis Trigger fires every time the humidity rises above a percentage you specify.
- Humidity drops belowThis Trigger fires every time the humidity drops below a percentage you specify.
- Noise level rises aboveThis Trigger fires every time the noise rises above a decibel value you specify.
- Noise level drops belowThis Trigger fires every time the noise drops below a decibel value you specify.
- Temperature rises aboveThis Trigger fires every time the temperature rises above a value you specify.
- Temperature drops belowThis Trigger fires every time the temperature drops below a value you specify.
- Rain detectedThis Trigger fires every time your Netatmo Rain Gauge detects that it is raining.
- Rain no longer detectedThis Trigger fires every time your Netatmo Rain Gauge detects that it is no longer raining.
- Today's rainfall measurementThis Trigger fires every day with the Netatmo Rain Gauge's rainfall measurement.
- Yesterday's rainfall measurementThis Trigger fires every day with yesterday's rainfall measurement.
- Wind speed drops belowThis Trigger fires every time the wind speed drops below a value you specify.
- Wind speed rises aboveThis Trigger fires every time the wind speed rises above a value you specify.
- Gust speed rises aboveThis Trigger fires ever time the gust speed rises above a value you specify.
Queries (With)
- History of Air pressure rose above threshold alertsThis query returns a list of times when the ambient air pressure rose above a value you specified. Note: this query will only return future events after this Applet is created.
- Current values of a rowThis query returns the current values in a given row. Values from columns A-Z are available as ingredients.
- History of times wind speed was faster than the threshold value you specifiedThis query returns a list of when the wind speed rose above the threshold value you specified. Note: this query will only return future events after this Applet is created.
- Current value of a cellThis query returns the current value of a single cell in your spreadsheet.
- History of Gust speed exceeded thresholdThis query returns a list of times when the gust speed rose above a 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 Rain StoppedThis query returns a list of events when your Netatmo Rain Gauge detected that it was no longer raining.
- 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 humidity drops belowThis query returns a list of when the humidity drops below a percentage you specify. 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 today's rainfall measurementThis query returns a list of every day with the Netatmo Rain Gauge's rainfall measurement.
- History of worksheets in spreadsheetThis query returns a list of when a new worksheet is added to a spreadsheet you specify.
- History of carbon dioxide drops belowThis query returns a list of when the carbon dioxide drops below a value you specify. Note: this query will only return future events after this Applet is created.
- History of humidity rises aboveThis query returns a list of when the humidity rises above a percentage you specify. Note: this query will only return future events after this Applet is created.
- History of rainfall measurementsThis query returns a list of past daily rainfall measurements.
- History of noise level rises aboveThis query returns a list of when the noise rises above a decibel value you specify. Note: this query will only return future events after this Applet is created.
- History of rain detectedThis query returns a list of when your Netatmo Rain Gauge detects that it was raining.
- History of temperature drops belowThis query returns a list of when the temperature drops below a value you specify. Note: this query will only return future events after this Applet is created.
- History of temperature rises aboveThis query returns a list of when the temperature rises above a value you specify. Note: this query will only return future events after this Applet is created.
- History of Carbon dioxide rising above thresholdThis query returns a list of when the carbon dioxide rose above a value you specify. Note: this query will only return future events after this Applet is created.
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