Create a rainfall log in a Google spreadsheet
Connect popular automations
Quickly and easily enable Applets using Google Sheets and Netatmo Weather Station.-
777
-
-
Create a Google Spreadsheet for your room's rising carbon dioxide levels
731
-
-
Create a rainfall log in a Google spreadsheet
677
-
-
Log strong wind gusts in my Google Drive
126
-
-
If environment is too noisy then log it to Google Drive spreadsheet for further tracking
100
-
-
Create a Google Spreadsheet for your room's dropping carbon dioxide levels
89
-
-
Tägliche Regenmenge > Speichern in Google Doc Tabelle
80
-
-
Eintrag der täglichen Regenmenge in eine Google Drive Tabelle
30
-
-
Recording the daily rainfall in a Google Spreadsheet.
18
-
USE CASE
Location-based time logging
Track the time you spend in specific locations, like your office or home, by automatically logging data into a Google Sheet each time you arrive or leave.
Get startedCreate your own Google Sheets and Netatmo Weather Station workflow
Create custom workflows effortlessly by selecting triggers, queries, and actions. With IFTTT, it's simple: “If this” trigger happens, “then that” action follows. Streamline tasks and save time with automated workflows that work for you.
43 triggers, queries, and actions
Air pressure drops below
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time the ambient air pressure drops below a value you specify.
Air pressure rises above
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time the ambient air pressure rises above a value you specify.
Carbon dioxide drops below
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time the carbon dioxide drops below a value you specify.
Carbon dioxide rises above
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time the carbon dioxide rises above a value you specify.
Cell updated in spreadsheet
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a particular cell is updated within the spreadsheet you specify.
Gust speed rises above
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires ever time the gust speed rises above a value you specify.
Humidity drops below
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time the humidity drops below a percentage you specify.
Humidity rises above
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time the humidity rises above a percentage you specify.
New row added to spreadsheet
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a new row is added to a spreadsheet you specify.
New spreadsheet added to folder
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
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.
New worksheet in spreadsheet
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a new worksheet is added to a spreadsheet you specify.
Noise level drops below
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time the noise drops below a decibel value you specify.
Noise level rises above
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time the noise rises above a decibel value you specify.
Rain detected
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time your Netatmo Rain Gauge detects that it is raining.
Rain no longer detected
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time your Netatmo Rain Gauge detects that it is no longer raining.
Temperature drops below
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time the temperature drops below a value you specify.
Temperature rises above
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time the temperature rises above a value you specify.
Today's rainfall measurement
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every day with the Netatmo Rain Gauge's rainfall measurement.
Wind speed drops below
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time the wind speed drops below a value you specify.
Wind speed rises above
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time the wind speed rises above a value you specify.
Yesterday's rainfall measurement
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every day with yesterday's rainfall measurement.
Current value of a cell
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the current value of a single cell in your spreadsheet.
Current values of a row
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the current values in a given row. Values from columns A-Z are available as ingredients.
History of Air pressure rose above threshold alerts
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
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.
History of carbon dioxide drops below
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
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 Carbon dioxide rising above threshold
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
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 Gust speed exceeded threshold
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
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 humidity drops below
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
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 humidity rises above
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
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 noise level rises above
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
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
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when your Netatmo Rain Gauge detects that it was raining.
History of Rain Stopped
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of events when your Netatmo Rain Gauge detected that it was no longer raining.
History of rainfall measurements
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of past daily rainfall measurements.
History of rows added to spreadsheet
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when a new row is added to a spreadsheet you specify.
History of spreadsheets added to folder
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
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 temperature drops below
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
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
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
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 times wind speed was faster than the threshold value you specified
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
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.
History of today's rainfall measurement
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of every day with the Netatmo Rain Gauge's rainfall measurement.
History of when Cell was updated in spreadsheet
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when a particular cell was updated within the spreadsheet you specify.
History of worksheets in spreadsheet
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when a new worksheet is added to a spreadsheet you specify.
Add row to spreadsheet
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
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
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
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
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
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.
Air pressure drops below
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time the ambient air pressure drops below a value you specify.
Air pressure rises above
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time the ambient air pressure rises above a value you specify.
Carbon dioxide drops below
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time the carbon dioxide drops below a value you specify.
Carbon dioxide rises above
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time the carbon dioxide rises above a value you specify.
Cell updated in spreadsheet
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a particular cell is updated within the spreadsheet you specify.
Current value of a cell
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the current value of a single cell in your spreadsheet.
Current values of a row
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the current values in a given row. Values from columns A-Z are available as ingredients.
Gust speed rises above
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires ever time the gust speed rises above a value you specify.
History of Air pressure rose above threshold alerts
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
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.
History of carbon dioxide drops below
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
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 Carbon dioxide rising above threshold
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
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 Gust speed exceeded threshold
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
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 humidity drops below
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
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 humidity rises above
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
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 noise level rises above
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
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
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when your Netatmo Rain Gauge detects that it was raining.
History of Rain Stopped
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of events when your Netatmo Rain Gauge detected that it was no longer raining.
History of rainfall measurements
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of past daily rainfall measurements.
History of rows added to spreadsheet
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when a new row is added to a spreadsheet you specify.
History of spreadsheets added to folder
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
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 temperature drops below
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
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
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
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 times wind speed was faster than the threshold value you specified
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
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.
History of today's rainfall measurement
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of every day with the Netatmo Rain Gauge's rainfall measurement.
History of when Cell was updated in spreadsheet
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when a particular cell was updated within the spreadsheet you specify.
History of worksheets in spreadsheet
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when a new worksheet is added to a spreadsheet you specify.
Humidity drops below
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time the humidity drops below a percentage you specify.
Humidity rises above
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time the humidity rises above a percentage you specify.
New row added to spreadsheet
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a new row is added to a spreadsheet you specify.
New spreadsheet added to folder
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
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.
New worksheet in spreadsheet
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a new worksheet is added to a spreadsheet you specify.
Noise level drops below
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time the noise drops below a decibel value you specify.
Noise level rises above
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time the noise rises above a decibel value you specify.
Rain detected
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time your Netatmo Rain Gauge detects that it is raining.
Rain no longer detected
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time your Netatmo Rain Gauge detects that it is no longer raining.
Temperature drops below
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time the temperature drops below a value you specify.
Temperature rises above
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time the temperature rises above a value you specify.
Today's rainfall measurement
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every day with the Netatmo Rain Gauge's rainfall measurement.
Update cell in spreadsheet
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
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.
Wind speed drops below
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time the wind speed drops below a value you specify.
Wind speed rises above
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time the wind speed rises above a value you specify.
Yesterday's rainfall measurement
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every day with yesterday's rainfall measurement.
Build an automation in seconds!
If
Select a trigger the automation will use
Then
Select an action the automation will perform
You can add delays, queries, and more actions in the next step!
GET STARTED
How to connect to a Google Sheets automation
Find an automation using Google Sheets
Find an automation to connect to, or create your own!Connect IFTTT to your Google Sheets account
Securely connect the Applet services to your respective accounts.Finalize and customize your Applet
Review trigger and action settings, and click connect. Simple as that!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.
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.
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.