Connect Google Sheets to iDevices and unlock powerful automations

This trigger fires when the specified product 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 the specified product turns off.

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

This trigger fires when your thermostat target temperature is set above or below the specified value.

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

This trigger fires when the target thermostat mode changes to the configured mode (or on any change if 'any' is selected).

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

This trigger fires when the ambient temperature read on your device is above or below the configured value.

This trigger fires when the specified product's night light turns on.

This trigger fires when the specified product's night light turns off.

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 when the specified product's night light turned off.

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

This query returns a list of recent thermostat changes to the configured mode (or of all changes if 'any' was selected).

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 turn the specified product 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 turn the specified product on.

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 set the percentage of brightness for the specified product.

This action will set the target temperature of your thermostat.

This action will set the mode of the selected thermostat.

This action will turn the specified product's night light on.

This action will turn the specified product's night light off.

Set the color of the specified product's night light.