When motion is detected, log the event in a spreadsheet.
Other popular Google Sheets workflows and automations
-
949
-
-
Log WiFi connections/disconnections
7.23K
-
-
Automatically log every call you make on your Android phone to a Google spreadsheet
10.7K
-
-
Keep a simple spreadsheet of every Tweet you post
35.9K
-
-
Press a button to track work hours in Google Drive
123K
-
-
How strong is your currency in another country? Log the exchange rate every day
4.39K
-
-
Save your Fitbit sleep logs to a Google Spreadsheet
12K
-
-
If new daily summary is available, log a row in a Google Sheets spreadsheet
853
-
-
Put all your completed tasks in a Google Spreadsheet
5.66K
-
Build your own Google Sheets and SpotCam automations
Triggers (If this)
-
Humidity event detected
This Trigger fires every time a humidity event is detected.
-
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.
-
Motion event detected
This Trigger fires every time a motion event is detected.
-
New worksheet in spreadsheet
This trigger fires when a new worksheet is added to a spreadsheet you specify.
-
Illumination event detected
This Trigger fires every time a illumination event is detected.
-
New row added to spreadsheet
This trigger fires when a new row is added to a spreadsheet you specify.
-
Temperature event detected
This Trigger fires every time a temperature event is detected.
-
Cell updated in spreadsheet
This trigger fires when a particular cell is updated within the spreadsheet you specify.
-
Audio event detected
This Trigger fires every time an audio event is detected.
-
SpotCam Ring video doorbell pressed
This Trigger fires every time when SpotCam Ring video doorbell is pressed.
-
SpotCam low battery
This Trigger fires every time when a low battery event is detected by SpotCam Ring video doorbell or SpotCam Solo.
-
SpotCam Ring battery cover removed
This Trigger fires every time when SpotCam Ring battery cover is removed.
-
Missing Object Event
This Trigger fires every time when a designated object is missing
-
Virtual Fence Crossed
This Trigger fires every time when a virtual fence is crossed
-
Vehicle Detected
This Trigger fires every time when a vehicle is detected
-
Human Detected
This Trigger fires every time when a person is detected.
-
Pass Out Event
This Trigger fires every time when system detects someone fall or pass out
-
Pet Detected
This Trigger fires every time when a pet is detected
-
Baby Crying
This Trigger fires every time when baby crying sound is detected.
-
Human Tracking
This Trigger fires every time when a person is being tracked.
-
Face Recognized
This Trigger fires every time a face is recognized.
Humidity event detected
This Trigger fires every time a humidity event is detected.
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.
Motion event detected
This Trigger fires every time a motion event is detected.
New worksheet in spreadsheet
This trigger fires when a new worksheet is added to a spreadsheet you specify.
Illumination event detected
This Trigger fires every time a illumination event is detected.
New row added to spreadsheet
This trigger fires when a new row is added to a spreadsheet you specify.
Temperature event detected
This Trigger fires every time a temperature event is detected.
Cell updated in spreadsheet
This trigger fires when a particular cell is updated within the spreadsheet you specify.
Audio event detected
This Trigger fires every time an audio event is detected.
SpotCam Ring video doorbell pressed
This Trigger fires every time when SpotCam Ring video doorbell is pressed.
SpotCam low battery
This Trigger fires every time when a low battery event is detected by SpotCam Ring video doorbell or SpotCam Solo.
SpotCam Ring battery cover removed
This Trigger fires every time when SpotCam Ring battery cover is removed.
Missing Object Event
This Trigger fires every time when a designated object is missing
Virtual Fence Crossed
This Trigger fires every time when a virtual fence is crossed
Vehicle Detected
This Trigger fires every time when a vehicle is detected
Human Detected
This Trigger fires every time when a person is detected.
Pass Out Event
This Trigger fires every time when system detects someone fall or pass out
Pet Detected
This Trigger fires every time when a pet is detected
Baby Crying
This Trigger fires every time when baby crying sound is detected.
Human Tracking
This Trigger fires every time when a person is being tracked.
Face Recognized
This Trigger fires every time a face is recognized.
Queries (With)
-
History of human detection
This query returns a list of events when a person was detected.
-
Current values of a row
This query returns the current values in a given row. Values from columns A-Z are available as ingredients.
-
History of virtual fence crossed
This query returns a list of when when a virtual fence was crossed. Note: this query will only return future events after this Applet is created.
-
Current value of a cell
This query returns the current value of a single cell in your spreadsheet.
-
History of SpotCam low battery detections
This query returns a list of when a low battery event was detected by SpotCam Ring video doorbell or SpotCam Solo.
-
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 SpotCam Ring battery cover removes
This query returns a list of when the SpotCam Ring battery cover was removed.
-
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 vehicles detected
This query returns a list of when a vehicle was detected
-
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 motion events detected
This query returns a list of when a Motion event was detected
-
History of worksheets in spreadsheet
This query returns a list of when a new worksheet is added to a spreadsheet you specify.
History of human detection
This query returns a list of events when a person was detected.
Current values of a row
This query returns the current values in a given row. Values from columns A-Z are available as ingredients.
History of virtual fence crossed
This query returns a list of when when a virtual fence was crossed. Note: this query will only return future events after this Applet is created.
Current value of a cell
This query returns the current value of a single cell in your spreadsheet.
History of SpotCam low battery detections
This query returns a list of when a low battery event was detected by SpotCam Ring video doorbell or SpotCam Solo.
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 SpotCam Ring battery cover removes
This query returns a list of when the SpotCam Ring battery cover was removed.
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 vehicles detected
This query returns a list of when a vehicle was detected
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 motion events detected
This query returns a list of when a Motion event was detected
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 On Share Function
This action will unblock all shared users so they can access your SpotCam.
-
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 Share Function
This action will unblock all shared users so they can access your SpotCam.
-
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 On SpotCam
This Action will turn on the designated SpotCam.
-
Turn Off SpotCam
This Action will turn off the designated SpotCam.
-
Turn On Alert
This Action will turn on your Spotcam's alert function.
-
Turn Off Alert
This Action will turn off your Spotcam's alert function.
-
Turn On Night Vision
This Action will turn on your Spotcam's night vision mode.
-
Turn Off Night Vision
This Action will turn off your Spotcam's night vision mode.
-
Sound Siren
This Action will sound siren of SpotCam Sense series.
-
Move To Preset Point
This Action will move your SpotCam HD Eva to the preset point.
-
Take a Snapshot and Email It
This Action will take a snapshot and email it to your SpotCam account email address.
Turn On Share Function
This action will unblock all shared users so they can access your SpotCam.
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 Share Function
This action will unblock all shared users so they can access your SpotCam.
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 On SpotCam
This Action will turn on the designated SpotCam.
Turn Off SpotCam
This Action will turn off the designated SpotCam.
Turn On Alert
This Action will turn on your Spotcam's alert function.
Turn Off Alert
This Action will turn off your Spotcam's alert function.
Turn On Night Vision
This Action will turn on your Spotcam's night vision mode.
Turn Off Night Vision
This Action will turn off your Spotcam's night vision mode.
Sound Siren
This Action will sound siren of SpotCam Sense series.
Move To Preset Point
This Action will move your SpotCam HD Eva to the preset point.
Take a Snapshot and Email It
This Action will take a snapshot and email it to your SpotCam account email address.
How to connect Google Sheets and SpotCam
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 SpotCam accounts.Finalize and customize your Applet
Review your trigger and action settings. Your Applet is ready to go!Upgrade your automations with
-
Connect to more Applets
Connect up to 20 automations with Pro, and unlimited automations with Pro+ -
Add multiple actions with exclusive services
Add real-time data and multiple actions for smarter automations -
Get access to faster speeds
Get faster updates and more actions with higher rate limits and quicker checks
More on Discord and Instagram
About Google Sheets
Google Sheets lets you create and edit spreadsheets stored on your Google Drive. Turn on Applets to monitor specific cells in your spreadsheets as well create news docs, rows, and cell updates.
About SpotCam
SpotCam is a smart cloud video monitoring solution that helps you monitor all the things you care about. You can find useful applet for SpotCam HD/FHD/Pano series monitoring camera, SpotCam Ring series video doorbell, or SpotCam Solo cordless camera in this channel.