Log your Facebook status updates in Google Drive spreadsheet
Other popular Google Sheets workflows and automations
-
1.31K
-
-
Back up new texts you receive on your Android device to a Google Spreadsheet
13.1K
-
-
Record every time your phone's battery is low in a Google spreadsheet
3.04K
-
-
Gmail to Sheets
1.52K
-
-
Put all your completed tasks in a Google Spreadsheet
5.67K
-
-
Automatically log work hours in a spreadsheet
1.48K
-
-
When a song is added to a Spotify playlist, song details appended to Google Sheet
1.23K
-
-
Automatically add your saved tracks in Spotify to a Google spreadsheet
13.3K
-
-
When motion is detected, log the event in a spreadsheet.
949
-
Build your own Google Sheets and Govee Home automations
Triggers (If this)
-
Turned on/off
This trigger fires when the device is turned on/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.
-
Armed/DisArmed
This trigger fires when the sensor is armed or disarmed
-
New worksheet in spreadsheet
This trigger fires when a new worksheet is added to a spreadsheet you specify.
-
Contact sensor triggered
This trigger fires when contact sensor triggered
-
New row added to spreadsheet
This trigger fires when a new row is added to a spreadsheet you specify.
-
Motion sensor triggered
This trigger fires when motion sensor triggered
-
Cell updated in spreadsheet
This trigger fires when a particular cell is updated within the spreadsheet you specify.
-
Water leakage detected
This trigger fires when water leakage is detected or stops
-
Low battery
This trigger fires when battery is low
-
Appliance alert
This trigger fires when the alert is triggered
-
Sub-devices triggered
This trigger fires when the gateway sub device is triggered
Turned on/off
This trigger fires when the device is turned on/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.
Armed/DisArmed
This trigger fires when the sensor is armed or disarmed
New worksheet in spreadsheet
This trigger fires when a new worksheet is added to a spreadsheet you specify.
Contact sensor triggered
This trigger fires when contact sensor triggered
New row added to spreadsheet
This trigger fires when a new row is added to a spreadsheet you specify.
Motion sensor triggered
This trigger fires when motion sensor triggered
Cell updated in spreadsheet
This trigger fires when a particular cell is updated within the spreadsheet you specify.
Water leakage detected
This trigger fires when water leakage is detected or stops
Low battery
This trigger fires when battery is low
Appliance alert
This trigger fires when the alert is triggered
Sub-devices triggered
This trigger fires when the gateway sub device is triggered
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.
-
Ping
server health check ping
-
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.
Ping
server health check ping
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)
-
Set appliance mode
This action will set the device (not including lights) to a specified mode.
-
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.
-
Arm/Disarm
You can choose to arm or disarm your device through this action.
-
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.
-
Turns on/off
This action will turn on/off the device of your choosing.
-
Turn on/off Night Light
This action will turn on/off the Night Light of your choosing.
-
Set Volume
This action will set the device Volume
-
Set light color
This action will set the light to specified color.
-
Set light brightness
This action will set the light to a specified brightness.
-
Turn on/off Warm Mist
This action will turn on/off the warm mist of the device you've chosen.
-
Turn on/off Oscillation
This action will turn on/off the oscillation of the device you've chosen.
-
Turn on/off White Noise
This action will turn on/off the white noise of the device you've chosen.
-
Turn on/off Dreamview
This action will turn on/off the Dreamview of your choosing.
-
Apply Snapshot
This action will apply the snapshot of your choice to the device that created the snapshot
-
Smart Aroma Diffuser Scenes
This action will apply the Smart Aroma Diffuser Scene of your choice to the device
Set appliance mode
This action will set the device (not including lights) to a specified mode.
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.
Arm/Disarm
You can choose to arm or disarm your device through this action.
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.
Turns on/off
This action will turn on/off the device of your choosing.
Turn on/off Night Light
This action will turn on/off the Night Light of your choosing.
Set Volume
This action will set the device Volume
Set light color
This action will set the light to specified color.
Set light brightness
This action will set the light to a specified brightness.
Turn on/off Warm Mist
This action will turn on/off the warm mist of the device you've chosen.
Turn on/off Oscillation
This action will turn on/off the oscillation of the device you've chosen.
Turn on/off White Noise
This action will turn on/off the white noise of the device you've chosen.
Turn on/off Dreamview
This action will turn on/off the Dreamview of your choosing.
Apply Snapshot
This action will apply the snapshot of your choice to the device that created the snapshot
Smart Aroma Diffuser Scenes
This action will apply the Smart Aroma Diffuser Scene of your choice to the device
How to connect Google Sheets and Govee Home
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 Google Sheets and Govee Home 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