Add new iOS Contacts to Google Sheets automatically
How this automation works
Automatically record each time a Wireless Tag detects that a door or window has been closed by adding a new entry to a Google Sheets spreadsheet. This helps you maintain a clear activity log for your home or office. For example, keep track of when doors or windows are secured for security or maintenance records.
If
Trigger ingredients
Angle
Answer
TagName
TagImageURL
OccurredAt
Comment
Then
Action fields
filename
formatted_row
path
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 Google Sheets and Wireless Tag 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.
66 triggers, queries, and actions
Back in range
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 when a specified tag comes out of "out of range" state. Only tags with auto-update is enabled can come out of "out of range" state.
Brightness returns to normal
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 when a specified tag senses that its ambient light intensity returns between the upper and lower thresholds configured at light options screen inside the WirelessTag app.
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.
Door or window is closed
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 when a specified motion sensor tag(s) or reed sensor(s) detect that a door or window is closed.
Door or window is opened
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 when a specified motion sensor tag(s) or reed sensor(s) detect that a door or window is open.
Humidity or moisture is too high
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 when a specified tag with humidity or moisture monitoring enabled, detects "too wet" state. Adjust the threshold from the humidity/moisture options screen inside the WirelessTag app.
Humidity or moisture is too low
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 when a specified tag with humidity or moisture monitoring enabled, detects "too dry" state. Adjust the threshold from the humidity/moisture options screen inside the WirelessTag app.
Humidity or moisture returns to normal
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 when a specified tag with humidity or moisture monitoring enabled, returns within normal humidity range. Adjust the upper/lower thresholds from the humidity/moisture options screen inside the WirelessTag app.
Motion sensor has timed out
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 when specified PIR KumoSensor or regular motion sensor tag detects no movement for a time-out period.
Movement is detected
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 when specified PIR KumoSensor detects movement.
New KumoApp message
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 a specific KumoApp produces a log message with KumoApp.Log call with a specific type.
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.
Current Tag Manager State
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.
The query returns if the specified tag manager is online or offline, as well as how many hours it has been online.
Current Tag State
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 specified door/window sensor/tag's current state, including temperature, humidity/lux (when available) and motion state such as door open/close, moved, or detected motion (for PIR sensor)
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 door or window is closed
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 specified motion sensor tag(s) or reed sensor(s) detect that a door or window was closed.
History of door or window is opened
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 specified motion sensor tag(s) or reed sensor(s) detect that a door or window was open.
History of High Temperature 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 a specified tag senses that its ambient temperature exceeded an upper threshold configured at temperature options screen inside the WirelessTag app. Note: this query will only return future events after this Applet
History of humidity or moisture is too high
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 specified tag with humidity or moisture monitoring enabled, detects "too wet" state.
History of KumoApp messages
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 time a specific KumoApp produces a log message with KumoApp.Log call with a specific type.
History of motion sensor has timed out
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 specified PIR KumoSensor or regular motion sensor tag detects no movement for a time-out period.
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 sensor no longer detects water
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 specified water sensor tag transitions from detected water state to not detected water state, or when you open circuit its tip.
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.
Arm motion sensor
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 arms motion sensor on a tag. Regular angle based motion sensor, Reed KumoSensor and PIR KumoSensor can all be armed using this action.
Beep a tag
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 beep the tag. NOTE: Only compatible with the Motion Sensor Tags with buzzer.
Disable brightness monitoring
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 disable brightness/ambient light intensity monitoring on a tag.
Disable humidity or moisture monitoring
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 disable humidity or moisture monitoring on a tag.
Disable temperature monitoring
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 disable temperature monitoring on a tag.
Disarm motion sensor
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 disarms motion sensor on a tag. Regular angle based motion sensor, Reed KumoSensor and PIR KumoSensor can all be disarmed using this action.
Enable brightness monitoring
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 enable brightness/ambient light intensity monitoring on a tag. NOTE: Only compatible with Tags with ambient light sensor.
Enable humidity or moisture monitoring
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 enable humidity or moisture monitoring on a tag. NOTE: Only compatible with Tags with humidity or moisture sensor.
Enable temperature monitoring
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 enable temperature monitoring on a tag.
Run a KumoApp
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 a KumoApp installed under the current user account. If the KumoApp is running, nothing will happen. If a KumoApp does not register any event handler or timer, it will automatically stop after executing the first time, allowing this action to run multiple times without user intervention.
Stop a KumoApp
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 stop a KumoApp. If the KumoApp is not running, nothing will happen.
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.
Arm motion sensor
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 arms motion sensor on a tag. Regular angle based motion sensor, Reed KumoSensor and PIR KumoSensor can all be armed using this action.
Back in range
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 when a specified tag comes out of "out of range" state. Only tags with auto-update is enabled can come out of "out of range" state.
Beep a tag
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 beep the tag. NOTE: Only compatible with the Motion Sensor Tags with buzzer.
Brightness returns to normal
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 when a specified tag senses that its ambient light intensity returns between the upper and lower thresholds configured at light options screen inside the WirelessTag app.
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 Tag Manager State
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.
The query returns if the specified tag manager is online or offline, as well as how many hours it has been online.
Current Tag State
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 specified door/window sensor/tag's current state, including temperature, humidity/lux (when available) and motion state such as door open/close, moved, or detected motion (for PIR sensor)
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.
Disable brightness monitoring
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 disable brightness/ambient light intensity monitoring on a tag.
Disable humidity or moisture monitoring
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 disable humidity or moisture monitoring on a tag.
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 Google Sheets and Wireless Tag
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 Wireless Tag
Wireless Sensor Tag monitors and records motion events, temperature, humidity, ambient light, water leaks and can be used to find keys through beeps.
Wireless Sensor Tag monitors and records motion events, temperature, humidity, ambient light, water leaks and can be used to find keys through beeps.