Add new iOS Contacts to Google Sheets automatically
How this automation works
Stay informed instantly when the temperature falls below your chosen threshold. This Applet runs when your Netatmo Weather Station detects a lower temperature and then displays an alert on your LaMetric device and updates a cell in your Google Sheet. It’s perfect for tracking temperature changes and keeping your home or office environment comfortable.
If
Trigger ingredients
MeasuredAt
DeviceName
TargetTemperatureC
TargetTemperatureF
MeasuredTemperatureC
MeasuredTemperatureF
Then
Action fields
device
icon
text
sound
priority
And
Action fields
path
filename
cell
value
Services used in this Applet
You might also like...
-
272K
-
-
Track time at locations with Google Sheets
157K
-
-
Log work hours in Google Sheets with a Button Widget
124K
-
Related services
Create your own 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.
65 triggers, queries, and actions
Action Button Pressed
Realtime trigger
Realtime Applets run after the trigger service notifies IFTTT of a new trigger event. Since IFTTT is notified proactively of new trigger events, realtime Applets normally run within a few seconds of a trigger event occurring.
This Trigger fires every time you press the action button on LaMetric Time.
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.
Alarm Went Off
Realtime trigger
Realtime Applets run after the trigger service notifies IFTTT of a new trigger event. Since IFTTT is notified proactively of new trigger events, realtime Applets normally run within a few seconds of a trigger event occurring.
This trigger fires an event when the LaMetric Clock app fires an alarm.
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.
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.
Activate App Or Effect
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 activate specific app or effect on a LaMetric device.
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.
Dim LaMetric SKY
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 dim your LaMetric SKY.
Display Notification
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 display notification on your LaMetric device.
Display Sticky Notification
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 display notification on your LaMetric device. The notification will stay on screen until dismissed.
Pause Stopwatch
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 pause stopwatch on a LaMetric Time device.
Pause Timer
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 pause the timer on a LaMetric device.
Reset Stopwatch
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 reset stopwatch on a LaMetric device.
Reset Timer
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 reset the timer on a LaMetric device.
Set Clock Face
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 set or update a clock face on your LaMetric device.
Set Color On LaMetric SKY
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 set color on your LaMetric SKY.
Start Radio
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 start playing radio on a LaMetric Time device.
Action Button Pressed
Realtime trigger
Realtime Applets run after the trigger service notifies IFTTT of a new trigger event. Since IFTTT is notified proactively of new trigger events, realtime Applets normally run within a few seconds of a trigger event occurring.
This Trigger fires every time you press the action button on LaMetric Time.
Activate App Or Effect
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 activate specific app or effect on a LaMetric device.
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.
Alarm Went Off
Realtime trigger
Realtime Applets run after the trigger service notifies IFTTT of a new trigger event. Since IFTTT is notified proactively of new trigger events, realtime Applets normally run within a few seconds of a trigger event occurring.
This trigger fires an event when the LaMetric Clock app fires an alarm.
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.
Dim LaMetric SKY
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 dim your LaMetric SKY.
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!
More on these services
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.
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 LaMetric
LaMetric TIME clock is the most beautiful&versatile smart display ever created. It lets you track important information and smart home notifications at a glance, and take action with the click of a button.
LaMetric SKY smart lighting is the most advanced modular wall smart lighting that can work as a smart display. It lets you create unique lighting decorations, enjoy breathtaking visuals with triangle pixels, track time and get smart home notifications at a glance.
LaMetric TIME clock is the most beautiful&versatile smart display ever created. It lets you track important information and smart home notifications at a glance, and take action with the click of a button.
LaMetric SKY smart lighting is the most advanced modular wall smart lighting that can work as a smart display. It lets you create unique lighting decorations, enjoy breathtaking visuals with triangle pixels, track time and get smart home notifications at a glance.