Connect Google Sheets to Govee Home and unlock powerful automations

This trigger fires when the device is turned on/off

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 the sensor is armed or disarmed

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

This trigger fires when contact sensor triggered

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

This trigger fires when motion sensor triggered

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

This trigger fires when water leakage is detected or stops

This trigger fires when battery is low

This trigger fires when the alert is triggered

This trigger fires when the gateway sub device is triggered

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

server health check ping

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

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 particular cell was updated within the spreadsheet you specify.

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 set the device (not including lights) to a specified mode.

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.

You can choose to arm or disarm your device through this action.

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 on/off the device of your choosing.

This action will turn on/off the Night Light of your choosing.

This action will set the device Volume

This action will set the light to specified color.

This action will set the light to a specified brightness.

This action will turn on/off the warm mist of the device you've chosen.

This action will turn on/off the oscillation of the device you've chosen.

This action will turn on/off the white noise of the device you've chosen.

This action will turn on/off the Dreamview of your choosing.

This action will apply the snapshot of your choice to the device that created the snapshot

This action will apply the Smart Aroma Diffuser Scene of your choice to the device