Connect Blue by ADT to Google Sheets and unlock powerful automations

This trigger fires when a Blue By ADT sensor notices activity in the home.

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.

This trigger fires when an issue occurs, such as Low Battery, Device Offline, etc.

This trigger fires when a new worksheet is added to a spreadsheet you specify.

This trigger fires whenever a light is turned on, turned off, or a dimmer level is changed

This trigger fires when a new row is added to a spreadsheet you specify.

This trigger fires when a door is locked or unlocked

This trigger fires when a particular cell is updated within the spreadsheet you specify.

This trigger fires whenever the thermostat settings have changed.

This trigger fires whenever the Blue By ADT system arm state changes.

This trigger fires whenever a garage door is opened or closed

This trigger fires when a Blue By ADT camera detects motion

This trigger fires when a Blue By ADT alarm event occurs.

This triggers fires when your Blue by ADT doorbell camera is rang or detects motion.

This trigger fires when your camera detects a person.

This query returns the current values in a given row. Values from columns A-Z are available as ingredients.

This query returns a list of whenever the thermostat settings have changed.

This query returns the current value of a single cell in your spreadsheet.

This query returns a list of when an issue occurs, such as Low Battery, Device Offline, etc.

This query returns a list of when a new row is added to a spreadsheet you specify.

This query returns a list of whenever a garage door was opened or closed.

This query returns a list of when a particular cell was updated within the spreadsheet you specify.

This query returns a list of when a Blue By ADT camera detected motion.

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.

This query returns a list of when a new worksheet is added to a spreadsheet you specify.

This action will arm the Blue By ADT security system.

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.

This action will turn on a light.

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.

This action will turn off a light.

This action will set the level of a dimmer.

This action will lock a door.

This action will close the garage door

This action will set your thermostat to high and low temperature range while in Auto or Dual mode. This does not set the thermostat to Auto mode.

This action will set your thermostat to heat or cool mode and set a single temperature.

This action will take a snapshot on a selected camera

This action will record a video clip on a selected camera

This action will execute a rule you have created on your LifeShield account. To create a new rule, open your Blue By ADT app go to settings, and select Rules.