Connect Google Sheets to My Leviton and unlock powerful automations

This trigger fires when a Decora Smart Wi-Fi device turns 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 Decora Smart Wi-Fi device turns off.

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

This trigger fires when a My Leviton Scene has run.

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

This trigger fires when a My Leviton Activity has run.

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

This trigger fires when a My Leviton Room turns on.

This trigger fires when a My Leviton Room turns off.

This trigger fires when a My Leviton Residence's status is set to home.

This trigger fires when a My Leviton Residence's status is set to away.

This trigger fires when a DW4BC or D2SCS button is pressed. The DW4BC supports buttons 1,2,3, or 4. The D2SCS supports buttons 1,2, or 3.

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 times when a Decora Smart Wi-Fi device turns off.

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

This query returns a list of when a Decora Smart Wi-Fi device turned on.

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

This query returns a history of My Leviton Scene runs.

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

This query returns a list of instances when a My Leviton Room turns on.

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 toggle a Decora Smart Wi-Fi device On/Off.

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 brighten or dim a Decora Smart Wi-Fi Dimmer to a specific value.

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 dim a Decora Smart Wi-Fi Dimmer.

This action will brighten a Decora Smart Wi-Fi Dimmer.

This action will run a My Leviton Activity.

This action will run a My Leviton Scene.

This action will turn on all devices in a My Leviton Room.

This action will turn off all devices in a My Leviton Room.

This action will set a Leviton Residence to Home or Away.

This action will make a light blink.

This action will set a Leviton Fan Speed Controller's speed.