Connect Google Sheets to Powered by Viva and unlock powerful automations

This trigger fires when a specific device is turned on.

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 a specific device is turned off.

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

This trigger fires when motion is detected.

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

This trigger fires when a specific door opens.

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

This trigger fires when a specific door closes.

This trigger fires when a specific sensor reads the temperature.

This trigger fires when every family member has left.

This trigger fires when everyone has gone to sleep.

This trigger fires when everyone has woken up.

This trigger fires when smoke is detected.

This trigger fires when the alarm in the house is breached, requires a subscription with alarm functionality.

This trigger fires when at least one family member has come home.

This trigger fires when a water leak is detected.

This trigger fires when a specific door is unlocked

This trigger fires when glass breakage is detected.

This trigger fires when a specific light bulb changes color.

This trigger fires when a specific light bulb changes brightness.

This trigger fires when a specific door is locked.

This trigger fires when a specific sensor measures the luminance.

This trigger fires when a specific device reports its battery level.

This query returns a recent history of when a device reported a battery level.

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

This querty returns a recent list of detections of someone waking up.

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

This query returns a list of when a specific door opens.

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

This query returns a list of when a specific device was turned on.

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 specific door was unlocked

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 specific sensor reads the temperature.

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

This query returns a list of when a specific device was turned off.

This action will turn a device off given a name.

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 a device on given a name.

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 the alarm in your house, this requires a subscription with alarm functionality.

This action will turn on the alarm in your house, this requires a subscription with alarm functionality.

This action will unlock a specific door.

This action will change the brightness of a bulb given a name.

This action will lock a specific door.

This action will change the color of a bulb given a name.