Connect Google Sheets to TP-Link Tapo and unlock powerful automations

This trigger fires every time a plug/bulb turns 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 a plug/bulb turns off.

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

This trigger fires every time the color of a light bulb changes.

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

This triggers fires every time a shortcut is changed.

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

This triggers fires every time a shortcut is deleted.

This triggers fires every time the camera detects a motion.

This triggers fires every time the camera detects a person motion.

This triggers fires every time the camera detects a pet.

This triggers fires every time the camera detects meows.

This triggers fires every time the camera detects a glass breaking motion.

This triggers fires every time the camera detects a smoke alarm motion.

This triggers fires every time the camera detects a baby cry motion.

This triggers fires every time the camera detects a vehicle motion.

This triggers fires every time the camera detects a line crossing motion.

This triggers fires every time the camera detects a area intrusion motion.

This triggers fires every time the camera detects a tampering motion.

This triggers fires every time the camera detects a package pickup motion.

This triggers fires every time the camera detects a motion of delivering a package.

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

This query returns the status of the device.

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

This query returns the color of the light bulb.

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

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.

This action will turn on a device.

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 off a device.

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 change the brightness of a light bulb.

This action will change the color temperature of a light bulb.

This action will change the color of a light bulb.

This action will activate a shortcut.

This action will change the status of the privacy mode of the device.

This action will control the camera to alarm for specified time.

This action will change the status of floodlight of the device.

This action will change the status of target track of the camera.

This action will change the status of patrol of the camera.