Connect Futurehome to Google Sheets and unlock powerful automations

This Trigger fires every time someone manually runs a Futurehome shortcut.

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 site changes modes.

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

This Trigger fires every time a device in your home is switched on.

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

This Trigger fires every time a device in your home is switched off.

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

This Trigger fires every time a door or a window is opened. You can also set a delay to have the trigger run if something has been left open.

This Trigger fires every time a door or a window is closed. You can also set a delay to have the trigger run if something has been closed for more than a defined time.

This Trigger fires every time one of your locks have been Locked.

This Trigger fires every time one of your locks have been Unlocked.

This Trigger fires every time a smoke sensor senses smoke.

This Trigger fires every time a flood sensor detects moisture.

This Trigger fires every time a temperature sensor senses a temperature above a desired value.

This Trigger fires every time a temperature sensor senses a temperature below a desired value.

This Trigger fires every time a sensor reports a higher brightness than desired.

This Trigger fires every time a sensor reports a lower brightness than desired.

This Trigger fires every time a humidity sensor senses a humidity above a desired value.

This Trigger fires every time a humidity sensor senses a humidity below a desired value.

This Trigger fires every time a device reports a higher power consumption than defined.

This Trigger fires every time a device reports a lower power consumption than defined.

This Trigger fires every time motion has been detected in one of your rooms.

This Trigger fires every time motion is no longer detected in a room.

This Trigger runs every time a Futurehome Smarthub restores it’s connection and is brought online.

This trigger runs every time a Futurehome Smarthub loses connection.

This query returns a list of recent mode changes.

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 Futurehome Smarthub is brought back online.

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

This query returns a list of when a sensor reports a lower brightness than desired.

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

This query returns a list of when one of your locks have been Locked.

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 smoke sensor senses smoke.

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 temperature sensor senses a temperature below a desired value. Note: this query will only return future events after this Applet is created.

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

This query returns a list of when a door or a window was closed.

This query returns a list of when a device in your home was switched off.

This query returns a list of when a sensor reported a higher brightness than desired.

This Action will allow you to set a mode on your site.

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 let you run one of your shortcuts.

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 one of your Futurehome devices.

This Action will turn off one of your Futurehome devices.

This Action will lock one of your locks.

This Action will unlock one of your locks.

This Action will allow you to set the desired temperature for a room.

This Action will change the colour of your RGB lights. Input may be colour name or Colour HEX. If a match is not found the light will change to White (FFFFFF).

This Action will allow you to set your lights to a defined brightness between 0-100%.