Connect Google Sheets to YoLink and unlock powerful automations

This trigger fires when door sensor state change

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 motion sensor state changed

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

This trigger fires when your leak sensor detected water.

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

This trigger fires when the temperature or humidity value is in the alert range

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

This trigger fires when your YoLink Lock's state changed

This trigger fires when motion sensor state changed

This trigger fires when CO or Smoke is detected

Fire this trigger by YoLink Flex Fob

This trigger fires when the Leak Sensor detects an event you specify.

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 YoLink Lock's state changed

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

This query returns a list of when motion sensor state changed

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

This query returns a list of when the door sensor state changed.

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.

Turn on or turn off yolink outlet

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 on or turn off yolink switch

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.

Open or close your valve with YoLink Valve Controller

Control your YoLink IR Remote

Turn on/off power strip

Control your thermostat

Set delay for your sprinkler

Enable / Disable YoLink Device's notification

Start / Stop alarm for siren

Execute your scene that defined in YoLink APP