Create a rainfall log in a Google spreadsheet
Connect popular automations
Quickly and easily enable Applets using Google Sheets and Netatmo Weather Station.-
508
-
-
Create a Google Spreadsheet for your room's rising carbon dioxide levels
450
-
-
Create a rainfall log in a Google spreadsheet
122
-
-
If environment is too noisy then log it to Google Drive spreadsheet for further tracking
50
-
-
Create a Google Spreadsheet for your room's dropping carbon dioxide levels
50
-
-
Tägliche Regenmenge > Speichern in Google Doc Tabelle
47
-
-
Eintrag der täglichen Regenmenge in eine Google Drive Tabelle
18
-
-
Log strong wind gusts in my Google Drive
7
-
-
Recording the daily rainfall in a Google Spreadsheet.
5
-
Build your own Google Sheets and Netatmo Weather Station automations
Triggers (If this)
-
Air pressure rises above
This Trigger fires every time the ambient air pressure rises above a value you specify.
-
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.
-
Air pressure drops below
This Trigger fires every time the ambient air pressure drops below a value you specify.
-
New worksheet in spreadsheet
This trigger fires when a new worksheet is added to a spreadsheet you specify.
-
Carbon dioxide rises above
This Trigger fires every time the carbon dioxide rises above a value you specify.
-
New row added to spreadsheet
This trigger fires when a new row is added to a spreadsheet you specify.
-
Carbon dioxide drops below
This Trigger fires every time the carbon dioxide drops below a value you specify.
-
Cell updated in spreadsheet
This trigger fires when a particular cell is updated within the spreadsheet you specify.
-
Humidity rises above
This Trigger fires every time the humidity rises above a percentage you specify.
-
Humidity drops below
This Trigger fires every time the humidity drops below a percentage you specify.
-
Noise level rises above
This Trigger fires every time the noise rises above a decibel value you specify.
-
Noise level drops below
This Trigger fires every time the noise drops below a decibel value you specify.
-
Temperature rises above
This Trigger fires every time the temperature rises above a value you specify.
-
Temperature drops below
This Trigger fires every time the temperature drops below a value you specify.
-
Rain detected
This Trigger fires every time your Netatmo Rain Gauge detects that it is raining.
-
Rain no longer detected
This Trigger fires every time your Netatmo Rain Gauge detects that it is no longer raining.
-
Today's rainfall measurement
This Trigger fires every day with the Netatmo Rain Gauge's rainfall measurement.
-
Yesterday's rainfall measurement
This Trigger fires every day with yesterday's rainfall measurement.
-
Wind speed drops below
This Trigger fires every time the wind speed drops below a value you specify.
-
Wind speed rises above
This Trigger fires every time the wind speed rises above a value you specify.
-
Gust speed rises above
This Trigger fires ever time the gust speed rises above a value you specify.
Air pressure rises above
This Trigger fires every time the ambient air pressure rises above a value you specify.
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.
Air pressure drops below
This Trigger fires every time the ambient air pressure drops below a value you specify.
New worksheet in spreadsheet
This trigger fires when a new worksheet is added to a spreadsheet you specify.
Carbon dioxide rises above
This Trigger fires every time the carbon dioxide rises above a value you specify.
New row added to spreadsheet
This trigger fires when a new row is added to a spreadsheet you specify.
Carbon dioxide drops below
This Trigger fires every time the carbon dioxide drops below a value you specify.
Cell updated in spreadsheet
This trigger fires when a particular cell is updated within the spreadsheet you specify.
Humidity rises above
This Trigger fires every time the humidity rises above a percentage you specify.
Humidity drops below
This Trigger fires every time the humidity drops below a percentage you specify.
Noise level rises above
This Trigger fires every time the noise rises above a decibel value you specify.
Noise level drops below
This Trigger fires every time the noise drops below a decibel value you specify.
Temperature rises above
This Trigger fires every time the temperature rises above a value you specify.
Temperature drops below
This Trigger fires every time the temperature drops below a value you specify.
Rain detected
This Trigger fires every time your Netatmo Rain Gauge detects that it is raining.
Rain no longer detected
This Trigger fires every time your Netatmo Rain Gauge detects that it is no longer raining.
Today's rainfall measurement
This Trigger fires every day with the Netatmo Rain Gauge's rainfall measurement.
Yesterday's rainfall measurement
This Trigger fires every day with yesterday's rainfall measurement.
Wind speed drops below
This Trigger fires every time the wind speed drops below a value you specify.
Wind speed rises above
This Trigger fires every time the wind speed rises above a value you specify.
Gust speed rises above
This Trigger fires ever time the gust speed rises above a value you specify.
Queries (With)
-
History of Air pressure rose above threshold alerts
This 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 row
This 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 specified
This 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 cell
This query returns the current value of a single cell in your spreadsheet.
-
History of Gust speed exceeded threshold
This 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 spreadsheet
This query returns a list of when a new row is added to a spreadsheet you specify.
-
History of Rain Stopped
This 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 spreadsheet
This query returns a list of when a particular cell was updated within the spreadsheet you specify.
-
History of humidity drops below
This 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 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 today's rainfall measurement
This query returns a list of every day with the Netatmo Rain Gauge's rainfall measurement.
-
History of worksheets in spreadsheet
This query returns a list of when a new worksheet is added to a spreadsheet you specify.
-
History of carbon dioxide drops below
This 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 above
This 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 measurements
This query returns a list of past daily rainfall measurements.
-
History of noise level rises above
This 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 detected
This query returns a list of when your Netatmo Rain Gauge detects that it was raining.
-
History of temperature drops below
This 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 above
This 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 threshold
This 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.
History of Air pressure rose above threshold alerts
This 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 row
This 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 specified
This 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 cell
This query returns the current value of a single cell in your spreadsheet.
History of Gust speed exceeded threshold
This 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 spreadsheet
This query returns a list of when a new row is added to a spreadsheet you specify.
History of Rain Stopped
This 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 spreadsheet
This query returns a list of when a particular cell was updated within the spreadsheet you specify.
History of humidity drops below
This 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 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 today's rainfall measurement
This query returns a list of every day with the Netatmo Rain Gauge's rainfall measurement.
History of worksheets in spreadsheet
This query returns a list of when a new worksheet is added to a spreadsheet you specify.
History of carbon dioxide drops below
This 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 above
This 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 measurements
This query returns a list of past daily rainfall measurements.
History of noise level rises above
This 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 detected
This query returns a list of when your Netatmo Rain Gauge detects that it was raining.
History of temperature drops below
This 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 above
This 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 threshold
This 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)
-
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.
How to connect Google Sheets and Netatmo Weather Station
Find or create an Applet
Start by discovering an automation to connect or customizing your own. It's quick and easy.Connect IFTTT to your accounts
Securely connect your Google Sheets and Netatmo Weather Station accounts.Finalize and customize your Applet
Review your trigger and action settings. Your Applet is ready to go!Upgrade your automations with
-
Connect to more Applets
Connect up to 20 automations with Pro, and unlimited automations with Pro+ -
Add multiple actions with exclusive services
Add real-time data and multiple actions for smarter automations -
Get access to faster speeds
Get faster updates and more actions with higher rate limits and quicker checks
More on Discord and Instagram
About Google Sheets
Google Sheets lets you create and edit spreadsheets stored on your Google Drive. Turn on Applets to monitor specific cells in your spreadsheets as well create news docs, rows, and cell updates.
About Netatmo Weather Station
The Netatmo Weather Station contains a unique set of sensors to monitor your living environment's temperature, barometric pressure, humidity, carbon dioxide concentration, noise pollution, and more.
The Netatmo App displays your Station’s indoor and outdoor measurements into clear and comprehensive dashboards, graphs and notifications.