Airzone Cloud

Google Sheets

Connect Airzone Cloud to Google Sheets and unlock powerful automations

Execute Smartlife scene when the zone is off

Airzone Cloud
Set a defined zone temperature when the zone temperature drops below a defined threshold

Airzone Cloud

1
Set a defined zone temperature when the outside temperature drops below a defined threshold

Airzone Cloud
Execute Smartlife scene when the zone is on

Airzone Cloud
Turn on a zone when solar power rises above the defined value

Airzone Cloud
Turn on a zone when solar energy start exporting solar power to the grid

Airzone Cloud
Save a Google Docs with a zone status every day at same time

Airzone Cloud
Turn off a zone when solar energy stop exporting solar power to the grid

Airzone Cloud
Turn off a zone when solar power drops below the defined value

Airzone Cloud

Triggers (If this)

Zone On

This trigger fires when the Airzone AC unit turns on.

New spreadsheet added to folder

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.

Zone Off

This trigger fires when the Airzone AC unit turns off.

New worksheet in spreadsheet

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

Temperature rises above threshold

This trigger fires when the zone temperature rises above a given threshold.

New row added to spreadsheet

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

Temperature drops below threshold

This trigger fires when the zone temperature drops below a given threshold.

Cell updated in spreadsheet

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

Humidity drops below threshold

This trigger fires when zone humidity drops below a given threshold.

Humidity rises above threshold

This trigger fires when zone humidity rises above a given threshold.

Zone demand state change

This trigger fires when zone changes demand for air.

Zone air quality change

This trigger fires when a zone's air quality changes.

Queries (With)

Current values of a row

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

Device status

Get device status

Current value of a cell

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

History of rows added to spreadsheet

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

History of when Cell was updated in spreadsheet

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

History of spreadsheets added to folder

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.

History of worksheets in spreadsheet

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

Actions (Then that)

Change zone mode

This action will change the operation mode in the Airzone unit.

Add row to spreadsheet

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.

Turn off zone

This action will power off the zone.

Update cell in spreadsheet

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.

Turn on zone

This action will power on the Airzone zone.

Change zone temperature

This action will change the Airzone zone's temperature. Note: if zone is off, it is turned on.

Execute Scene

This action will execute specified scene

Change zone fan speed

This action will change zone's fan speed.

IFTTT helps all your apps and devices work better together