Connect Google Sheets to Home Connect Fridge Freezer and unlock powerful automations

This trigger fires every time your refrigerator door has been opened.

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 every time your freezer door has been opened.

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

This trigger fires every time your refrigerator door was left open too long.

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

This trigger fires every time your freezer door was left open too long.

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

This trigger fires every time your freezer temperature is too high.

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 your freezer temperature was too high.

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

This query returns a list of when your freezer door has been opened.

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

This query returns a list of when your refrigerator door was opened.

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

This query returns a list of when your refrigerator door was left open too long.

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 refrigerator temperature.

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 set the freezer temperature.

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 temporarily cool the refrigerator at maximum power.

This action will temporarily cool the freezer at maximum power.

This action will activate Sabbath mode (Rest mode) on your appliance. Note that this will disable most other actions for your appliance, including remote temperature control.

This action will deactivate Sabbath mode on your appliance.

This action will activate Vacation mode (Holiday mode) on your appliance. Note that this will change set point temperature and manually changing it will disable the Vacation mode (Holiday mode).

This action will deactivate Vacation mode on your appliance.

This action will activate Fresh mode on your appliance. Note that this will change set point temperature and manually changing it will disable the Fresh mode.

This action will deactivate Fresh mode on your appliance.

This action will activate Eco mode on your appliance. Note that this will change set point temperature and manually changing it will disable the Eco mode.

This action will deactivate Eco mode on your appliance.