Connect Google Sheets to Hager IoT and unlock powerful automations

This Trigger fires every time your device is switched 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 every time your device is switched off.

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

This Trigger fires every time your device player's state changes to the value you specified.

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

This Trigger fires every time your device detects a brightness level above the value you specified.

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

This Trigger fires every time your device brightness level is below the value you specified.

This Trigger fires every time your device's binary switch is turned on.

This Trigger fires every time your device's binary switch is turned off.

This Trigger fires every time your device detects a CO2 level above the value you specified.

This Trigger fires every time your device detects a CO2 level below the value you specified.

This Trigger fires every time your device detects humidity levels higher than the threshold you specified.

This Trigger fires every time your device detects humidity levels lower than the threshold you specified.

This Trigger fires every time your device detects luminescence levels higher than the value you specified.

This Trigger fires every time your device detects a luminescence level below the value you specified.

This Trigger fires every time your device's rain indicator turns on.

This Trigger fires every time your device's rain indicator turns off.

This trigger fires when the Weather Station reports day.

This trigger fires when the Weather Station reports night.

This Trigger fires every time your device detects temperatures above the value you specified.

This Trigger fires every time your device detects a temperature below the value you specified.

This Trigger fires every time your device detects a volume level above the value you specified.

This Trigger fires every time your device volume level is below the value you specified.

This Trigger fires every time your device detects wind speed higher than the value you specified.

This Trigger fires every time your device detects wind speed lower than the value you specified.

This Trigger fires every time your device's battery level falls below the value you specified.

This Trigger fires every time your device's alarm is turned on.

This Trigger fires every time your device's alarm is turned off.

This query returns a list of events when the alarm was turned on.

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 recent times your battery fell below a specified value. Note: this query will only return future events after this Applet is created.

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

This query returns a list of when your device detects wind speed lower than the value you specified. Note: this query will only return future events after this Applet is created.

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 device's binary switch was turned off.

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 device detects a brightness level above the value you specified. Note: this query will only return future events after this Applet is created.

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 your device's alarm was turned off.

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

This query returns a list of when your device player's state changes to the value you specified.

This query returns a list of when your device volume level was below the value you specified. Note: this query will only return future events after this Applet is created.

This query returns a list of when your device detected a CO2 level above the value you specified. Note: this query will only return future events after this Applet is created.

This query returns a list of when the Weather Station reports night.

This query returns a list of when your device brightness level was below the value you specified. Note: this query will only return future events after this Applet is created.

This query returns a list of instances when your device detected wind speed higher than the value you specified. Note: this query will only return future events after this Applet is created.

This Action will run a scene.

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 on your devices that support switching 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 turn off your devices that support switching off.

This Action will set level on your lighting devices that support dimming.

This Action will set volume on your media player devices that support volume.

This Action will control your media player devices.

This action will change the thermostat setpoint.

This action will run a KNX scene.

This action will change the shutter/blinds position.

This Action will change the color of your lights. NOTE: Accepts color names and CSS hex color values. Defaults to white if no color match is found.

This action will play a playlist.

This action will play an item from the favorites.