Log your smart devices on/off activity
Connect top workflows
Quickly and easily enable Applets using Google Sheets and Smart Life.
Build your own Google Sheets and Smart Life automations
Triggers (If this)
-
Device or group is turned on
This trigger fires when the specified device/group is turned on.
-
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.
-
Device or group is turned off
This trigger fires when the specified device/group is turned off.
-
New worksheet in spreadsheet
This trigger fires when a new worksheet is added to a spreadsheet you specify.
-
Unlock the lock
This trigger fires when user unlocking the lock, his password or fingerprint identification or card is confirmed.
-
New row added to spreadsheet
This trigger fires when a new row is added to a spreadsheet you specify.
-
Camera detects motion
This trigger fires when the specified camera detects motion. To use this trigger, camera’s motion detection should be turned on.
-
Cell updated in spreadsheet
This trigger fires when a particular cell is updated within the spreadsheet you specify.
-
Camera detects sound
This trigger fires when the specified camera detects sound. To use this trigger, camera’s sound detection should be turned on.
-
Input incorrect password repetitiously
This trigger fires when someone input incorrect password repetitiously.
-
Battery low
This trigger fires when residual electricity in the lock under threshold.
-
Door sensor is open
This trigger fires when the door sensor is open.
-
Door sensor is closed
This trigger fires when the door sensor is closed.
-
Person is detected
This trigger fires when PIR detects person.
-
Leak detected
This trigger fires when water leak detected.
-
Sound and light detected
This trigger fires when water sound and light detected.
-
Shake detected
This trigger fires when sensor shake detected
Device or group is turned on
This trigger fires when the specified device/group is turned on.
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.
Device or group is turned off
This trigger fires when the specified device/group is turned off.
New worksheet in spreadsheet
This trigger fires when a new worksheet is added to a spreadsheet you specify.
Unlock the lock
This trigger fires when user unlocking the lock, his password or fingerprint identification or card is confirmed.
New row added to spreadsheet
This trigger fires when a new row is added to a spreadsheet you specify.
Camera detects motion
This trigger fires when the specified camera detects motion. To use this trigger, camera’s motion detection should be turned on.
Cell updated in spreadsheet
This trigger fires when a particular cell is updated within the spreadsheet you specify.
Camera detects sound
This trigger fires when the specified camera detects sound. To use this trigger, camera’s sound detection should be turned on.
Input incorrect password repetitiously
This trigger fires when someone input incorrect password repetitiously.
Battery low
This trigger fires when residual electricity in the lock under threshold.
Door sensor is open
This trigger fires when the door sensor is open.
Door sensor is closed
This trigger fires when the door sensor is closed.
Person is detected
This trigger fires when PIR detects person.
Leak detected
This trigger fires when water leak detected.
Sound and light detected
This trigger fires when water sound and light detected.
Shake detected
This trigger fires when sensor shake detected
Queries (With)
-
History of Leak detected
This query returns a list of times when the sensor detected a water leak.
-
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 when Door sensor was closed
This query returns a list of times when the door sensor was closed.
-
Current value of a cell
This query returns the current value of a single cell in your spreadsheet.
-
History of when Door sensor was open
This query returns a list of times when the door sensor was open.
-
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 when a Person was detected
This query returns a list of when PIR detected person.
-
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 Device turned off
This query returns a list of times when the specified device/group was turned off.
-
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 Device was turned on
This query returns a list of when the specified device/group was turned on.
-
History of worksheets in spreadsheet
This query returns a list of when a new worksheet is added to a spreadsheet you specify.
-
History of repetitious incorrect password alerts
This query returns a list of times when someone input an incorrect password repetitiously.
-
History of motion detections by Camera
This query returns a list of when a Camera detected motion. To use this query, Camera motion detected should be turned on.
-
History of Camera detected sound
This query returns a list of times when the specified camera detected sound. To use this query, camera’s sound detection must have been turned on.
-
History of Shake detected
This query returns a list of when sensor detected a shake
-
History of when lock unlocked
This query returns a list of when a user unloocked the lock and his password, fingerprint identification, or card was confirmed.
-
History of Sound or Light Detected
This query returns a list of when water sound or light were detected.
-
History of low Battery alerts
This query returns a list of when residual electricity in the lock dropped below the threshold. Note: this query will only return future events after this Applet is created.
History of Leak detected
This query returns a list of times when the sensor detected a water leak.
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 when Door sensor was closed
This query returns a list of times when the door sensor was closed.
Current value of a cell
This query returns the current value of a single cell in your spreadsheet.
History of when Door sensor was open
This query returns a list of times when the door sensor was open.
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 when a Person was detected
This query returns a list of when PIR detected person.
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 Device turned off
This query returns a list of times when the specified device/group was turned off.
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 Device was turned on
This query returns a list of when the specified device/group was turned on.
History of worksheets in spreadsheet
This query returns a list of when a new worksheet is added to a spreadsheet you specify.
History of repetitious incorrect password alerts
This query returns a list of times when someone input an incorrect password repetitiously.
History of motion detections by Camera
This query returns a list of when a Camera detected motion. To use this query, Camera motion detected should be turned on.
History of Camera detected sound
This query returns a list of times when the specified camera detected sound. To use this query, camera’s sound detection must have been turned on.
History of Shake detected
This query returns a list of when sensor detected a shake
History of when lock unlocked
This query returns a list of when a user unloocked the lock and his password, fingerprint identification, or card was confirmed.
History of Sound or Light Detected
This query returns a list of when water sound or light were detected.
History of low Battery alerts
This query returns a list of when residual electricity in the lock dropped below the threshold. Note: this query will only return future events after this Applet is created.
Actions (Then that)
-
Turn on
This action will turn on the device/group of your choosing.
-
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.
-
Turn off
This action will turn off the device/group of your choosing.
-
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.
-
Activate Scene
This action will activate the specified scene.
-
Set light brightness
This action will set your light to a specified brightness.
-
Set light color
This action will set the light to specified color.
-
Start Cool Mode
This action will set your AC to Cool Mode.
-
Start Heat Mode
This action will set your AC to Heat Mode.
-
Set AC temperature
This action will set your AC to a specified temperature by remote controller.
-
Turn on oscillation function of fan
This action will turn on the oscillation function of your fan by IR remote controller.
-
Turn off oscillation function of fan
This action will turn off the oscillation function of your fan by IR remote controller.
Turn on
This action will turn on the device/group of your choosing.
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.
Turn off
This action will turn off the device/group of your choosing.
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.
Activate Scene
This action will activate the specified scene.
Set light brightness
This action will set your light to a specified brightness.
Set light color
This action will set the light to specified color.
Start Cool Mode
This action will set your AC to Cool Mode.
Start Heat Mode
This action will set your AC to Heat Mode.
Set AC temperature
This action will set your AC to a specified temperature by remote controller.
Turn on oscillation function of fan
This action will turn on the oscillation function of your fan by IR remote controller.
Turn off oscillation function of fan
This action will turn off the oscillation function of your fan by IR remote controller.
How to connect Google Sheets and Smart Life
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 Smart Life accounts.Finalize and customize your Applet
Review your trigger and action settings. Your Applet is ready to go!Top integration tips, tools, and resources
-
Holiday
Automate New Year’s Resolutions
-
Popular
How an IFTTTer automates their Twitch
-
Productivity
10 best productivity apps for 2025
-
Lifestyle
The 25 best IFTTT Applets: Revolutionizing your digital workflow
-
Business
What are Webhooks and How Should I Use Them?
-
Productivity
Ten tips to keep your New Year's resolutions
IFTTT helps all your apps and devices work better together