Track your eWeLink 1 Channel Switch usage on Google spreadsheet
Connect top workflows
Quickly and easily enable Applets using eWeLink Smart Home and Google Sheets.-
80
-
-
Save data on sheet
30
-
-
If Puerta Avicell new Open, then Add row to avicellonline@gmail.com’s Google Drive spreadsheet
1
-
-
Track records of 4-channel switch on Google Sheets.
-
-
If door is opened or closed, add row to a spreadsheet
-
Build your own eWeLink Smart Home and Google Sheets automations
Triggers (If this)
-
4-Channel Plug turned on or off
This trigger fires when your eWeLink Support 4-Channel Plug is turned on or off.
-
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.
-
3-Channel Plug turned on or off
This trigger fires when your eWeLink Support 3-Channel Plug is turned on or off.
-
New worksheet in spreadsheet
This trigger fires when a new worksheet is added to a spreadsheet you specify.
-
2-Channel Plug turned on or off
This trigger fires when your eWeLink 2-Channel Plug is turned on or off.
-
New row added to spreadsheet
This trigger fires when a new row is added to a spreadsheet you specify.
-
1-Channel Plug turned on or off
This trigger fires when your eWeLink Support 1-Channel Plug is turned on or off.
-
Cell updated in spreadsheet
This trigger fires when a particular cell is updated within the spreadsheet you specify.
-
4-Channel Switch turned on or off
This trigger fires when your eWeLink Support 4-Channel Switch is turned on or off.
-
3-Channel Switch turned on or off
This trigger fires when your eWeLink 3-Channel Switch is turned on or off.
-
2-Channel Switch turned on or off
This trigger fires when your eWeLink Support 2-Channel Switch is turned on or off.
-
1-Channel Switch turned on or off
This trigger fires when your eWeLink Support 1-Channel Switch is turned on or off.
-
Smart Dimmer turned on or off
This trigger fires when your eWeLink Support Smart Dimmer is turned on or off.
-
Brightness is above
This trigger fires when the brightness of selected dimmer is above threshold.
-
Brightness is below
This trigger fires when the brightness of selected dimmer is below threshold.
-
Door sensor is open or closed
This trigger fires when the state of selected door sensor is open or closed.
-
Temperature goes above or below
This trigger fires when the temperature of selected device goes above or below threshold.
-
Humidity goes above or below
This trigger fires when the humidity of selected device goes above or below threshold.
-
Voltage goes above or below
This trigger fires when the voltage of selected device is above or below threshold.
-
Electric current goes above or below
This trigger fires when the electric current of the selected device goes above or below threshold.
-
Light turned on or off
This trigger fires when your light is turned on or off.
-
Light brightness goes above or below
This trigger fires when your light brightness goes above or below.
-
FanLight turned on or off
This trigger fires when the fan or the light of your FanLight is turned on or off
-
RF Bridge Alarm activated
This trigger fires when an alarm of your RF Bridge is activated.
-
When Camera detects a motion event
This Trigger fires every time the camera detects a motion event.
-
Low Water Level of Diffuser
This trigger fires when the water level of a diffuser is low.
-
Zigbee Motion Sensor
This trigger fires when motion is detected or no motion is detected from Zigbee motion sensor.
-
Leak detected
This trigger fires when leak is detected from water leak sensor.
-
Zigbee door sensor is open or closed
This trigger fires when the status of a Zigbee door sensor is open or closed.
-
Zigbee Wireless Switch Pressed
This trigger fires when Zigbee Wireless Switch is pressed, double pressed, or long pressed.
-
Electric curtain is open or closed
This trigger fires when the selected electric curtain is open or closed.
-
Enabled/disabled Child Lock of Thermostat
This trigger fires when the child lock status changes (enabled/disabled).
-
Thermostat Mode changes
This trigger fires when the thermostat mode changes.
-
Thermostat turned on or off
This trigger fires when the thermostat turns on or off
-
Color temperature(CT) of light appearances warm or cool
This trigger fires when your light’s color temperature of
light apperances warm or cool white.
-
Light turns to a specified colour
This trigger fires when your lights to a specified colour .
-
Scene Controller pressed
This Trigger fires every time your eWeLink Scene Controller is pressed.
-
Button Pressed
This Trigger fires every time your eWeLink Button is pressed.
-
Device/Group is turned on or off
This Trigger fires when the device/group is turn on or off
-
Various AQIs goes above or below
This trigger fires when the AQIs of selected devicegoes above or below threshold
4-Channel Plug turned on or off
This trigger fires when your eWeLink Support 4-Channel Plug is turned on or off.
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.
3-Channel Plug turned on or off
This trigger fires when your eWeLink Support 3-Channel Plug is turned on or off.
New worksheet in spreadsheet
This trigger fires when a new worksheet is added to a spreadsheet you specify.
2-Channel Plug turned on or off
This trigger fires when your eWeLink 2-Channel Plug is turned on or off.
New row added to spreadsheet
This trigger fires when a new row is added to a spreadsheet you specify.
1-Channel Plug turned on or off
This trigger fires when your eWeLink Support 1-Channel Plug is turned on or off.
Cell updated in spreadsheet
This trigger fires when a particular cell is updated within the spreadsheet you specify.
4-Channel Switch turned on or off
This trigger fires when your eWeLink Support 4-Channel Switch is turned on or off.
3-Channel Switch turned on or off
This trigger fires when your eWeLink 3-Channel Switch is turned on or off.
2-Channel Switch turned on or off
This trigger fires when your eWeLink Support 2-Channel Switch is turned on or off.
1-Channel Switch turned on or off
This trigger fires when your eWeLink Support 1-Channel Switch is turned on or off.
Smart Dimmer turned on or off
This trigger fires when your eWeLink Support Smart Dimmer is turned on or off.
Brightness is above
This trigger fires when the brightness of selected dimmer is above threshold.
Brightness is below
This trigger fires when the brightness of selected dimmer is below threshold.
Door sensor is open or closed
This trigger fires when the state of selected door sensor is open or closed.
Temperature goes above or below
This trigger fires when the temperature of selected device goes above or below threshold.
Humidity goes above or below
This trigger fires when the humidity of selected device goes above or below threshold.
Voltage goes above or below
This trigger fires when the voltage of selected device is above or below threshold.
Electric current goes above or below
This trigger fires when the electric current of the selected device goes above or below threshold.
Light turned on or off
This trigger fires when your light is turned on or off.
Light brightness goes above or below
This trigger fires when your light brightness goes above or below.
FanLight turned on or off
This trigger fires when the fan or the light of your FanLight is turned on or off
RF Bridge Alarm activated
This trigger fires when an alarm of your RF Bridge is activated.
When Camera detects a motion event
This Trigger fires every time the camera detects a motion event.
Low Water Level of Diffuser
This trigger fires when the water level of a diffuser is low.
Zigbee Motion Sensor
This trigger fires when motion is detected or no motion is detected from Zigbee motion sensor.
Leak detected
This trigger fires when leak is detected from water leak sensor.
Zigbee door sensor is open or closed
This trigger fires when the status of a Zigbee door sensor is open or closed.
Zigbee Wireless Switch Pressed
This trigger fires when Zigbee Wireless Switch is pressed, double pressed, or long pressed.
Electric curtain is open or closed
This trigger fires when the selected electric curtain is open or closed.
Enabled/disabled Child Lock of Thermostat
This trigger fires when the child lock status changes (enabled/disabled).
Thermostat Mode changes
This trigger fires when the thermostat mode changes.
Thermostat turned on or off
This trigger fires when the thermostat turns on or off
Color temperature(CT) of light appearances warm or cool
This trigger fires when your light’s color temperature of
light apperances warm or cool white.
Light turns to a specified colour
This trigger fires when your lights to a specified colour .
Scene Controller pressed
This Trigger fires every time your eWeLink Scene Controller is pressed.
Button Pressed
This Trigger fires every time your eWeLink Button is pressed.
Device/Group is turned on or off
This Trigger fires when the device/group is turn on or off
Various AQIs goes above or below
This trigger fires when the AQIs of selected devicegoes above or below threshold
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.
-
Current power state
This query returns the on/off state of the device you choose.
-
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.
Current values of a row
This query returns the current values in a given row. Values from columns A-Z are available as ingredients.
Current power state
This query returns the on/off state of the device you choose.
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)
-
Turn 4-Channel Plug on or off
This action will turn your eWeLink Support 4-Channel Plug on or off.
-
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 3-Channel Plug on or off
This action will turn your eWeLink Support 3-Channel Plug on or off.
-
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 2-Channel Plug on or off
This action will turn your eWeLink 2-Channel Plug on or off.
-
Turn 1-Channel Plug on or off
This action will turn your eWeLink Support 1-Channel Plug on or off.
-
Turn 4-Channel Switch on or off
This action will turn your eWeLink 4-Channel Switch on or off.
-
Turn 3-Channel Switch on or off
This action will turn your eWeLink Support 3-Channel Switch on or off.
-
Turn 2-Channel Switch on or off
This action will turn your eWeLink Support 2-Channel Switch on or off.
-
Turn 1-Channel Switch on or off
This action will turn your eWeLink Support 1-Channel Switch on or off.
-
Turn Smart Dimmer on or off
This action will turn your eWeLink Support smart dimmer on or off.
-
Set brightness for Smart Dimmer
This action will set brightness for selected eWeLink Support smart dimmer .
-
Set color for light
This action will set a color for selected light.
-
Set color temperature for light
This action will set a color temperature for selected light.
-
Set brightness for light
This action will set the brightness for selected light .
-
Turn on or off light
This action will turn your light on or off.
-
Press Remote Button on RF Bridge
This action will press selected remote button on your RF Bridge.
-
Control FanLight
This action will turn on or turn off the fan or the light of your fanlight.
-
Open or close electric curtain
This action will open or close your electric curtain.
-
Turn on or turn off diffuser
This action will turn your diffuser on or off.
-
Set percentage of electric curtain
This action will open selected curtain to the percentage you set.
-
Enable/disable the Child Lock of Thermostat
This action will enable or disable the child lock.
-
Change Thermostat Mode
This action will change the thermostat mode (Manual/Program).
-
Turn on or off Thermostat
This action will turn your eWeLink Thermostat on or off.
-
Fanlight on-off and speed setting
This action will set the light on/off or the fan speed of fanlight.
-
Camera makes alarm
This Action will makes the camera sound an alarm.
-
Set temperature
This action will set to a target temperature
-
Turn on or off device/group
This action will turn your device/group turn on or off
-
Camera Action
This will cause the camera to perform the action you selected.
-
Make device sound an alarm or beep
This action will set the device to sound an alarm or beep.
-
Set the security mode
This action will set to a security mode or disarm.
Turn 4-Channel Plug on or off
This action will turn your eWeLink Support 4-Channel Plug on or off.
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 3-Channel Plug on or off
This action will turn your eWeLink Support 3-Channel Plug on or off.
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 2-Channel Plug on or off
This action will turn your eWeLink 2-Channel Plug on or off.
Turn 1-Channel Plug on or off
This action will turn your eWeLink Support 1-Channel Plug on or off.
Turn 4-Channel Switch on or off
This action will turn your eWeLink 4-Channel Switch on or off.
Turn 3-Channel Switch on or off
This action will turn your eWeLink Support 3-Channel Switch on or off.
Turn 2-Channel Switch on or off
This action will turn your eWeLink Support 2-Channel Switch on or off.
Turn 1-Channel Switch on or off
This action will turn your eWeLink Support 1-Channel Switch on or off.
Turn Smart Dimmer on or off
This action will turn your eWeLink Support smart dimmer on or off.
Set brightness for Smart Dimmer
This action will set brightness for selected eWeLink Support smart dimmer .
Set color for light
This action will set a color for selected light.
Set color temperature for light
This action will set a color temperature for selected light.
Set brightness for light
This action will set the brightness for selected light .
Turn on or off light
This action will turn your light on or off.
Press Remote Button on RF Bridge
This action will press selected remote button on your RF Bridge.
Control FanLight
This action will turn on or turn off the fan or the light of your fanlight.
Open or close electric curtain
This action will open or close your electric curtain.
Turn on or turn off diffuser
This action will turn your diffuser on or off.
Set percentage of electric curtain
This action will open selected curtain to the percentage you set.
Enable/disable the Child Lock of Thermostat
This action will enable or disable the child lock.
Change Thermostat Mode
This action will change the thermostat mode (Manual/Program).
Turn on or off Thermostat
This action will turn your eWeLink Thermostat on or off.
Fanlight on-off and speed setting
This action will set the light on/off or the fan speed of fanlight.
Camera makes alarm
This Action will makes the camera sound an alarm.
Set temperature
This action will set to a target temperature
Turn on or off device/group
This action will turn your device/group turn on or off
Camera Action
This will cause the camera to perform the action you selected.
Make device sound an alarm or beep
This action will set the device to sound an alarm or beep.
Set the security mode
This action will set to a security mode or disarm.
How to connect eWeLink Smart Home and Google Sheets
Find or create an Applet
Start by discovering an automation to connect or customizing your own. It's quick and easy.Connect IFTTT to your accounts
Securely connect your eWeLink Smart Home and Google Sheets accounts.Finalize and customize your Applet
Review your trigger and action settings. Your Applet is ready to go!
IFTTT helps all your apps and devices work better together