Keep a log of your recently played tracks
Other popular Google Sheets workflows and automations
-
1.34K
-
-
Gmail to Sheets
1.52K
-
-
Call Log, Missed call
3.86K
-
-
Keep a simple spreadsheet of every Tweet you post
35.9K
-
-
Keep track of my completed tasks in a Google Spreadsheet
1.26K
-
-
When a reddit post is saved, enter a row into a Google Drive sheet with its info.
1.32K
-
-
When a song is added to a Spotify playlist, song details appended to Google Sheet
1.23K
-
-
Automatically save your Strava activities to a Google spreadsheet
7.55K
-
-
Back up new texts you receive on your Android device to a Google Spreadsheet
13.1K
-
Build your own Google Sheets and Scout Alarm automations
Triggers (If this)
-
Mode armed
This Trigger fires when a mode is armed.
-
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.
-
Mode disarmed
This Trigger fires when a mode is disarmed.
-
New worksheet in spreadsheet
This trigger fires when a new worksheet is added to a spreadsheet you specify.
-
Alarm triggered
This Trigger fires when the alarm for a specific mode is triggered.
-
New row added to spreadsheet
This trigger fires when a new row is added to a spreadsheet you specify.
-
Alarm dismissed
This Trigger fires when the alarm for a specific mode is dismissed.
-
Cell updated in spreadsheet
This trigger fires when a particular cell is updated within the spreadsheet you specify.
-
Door panel opened
This Trigger fires when any or a specific door panel is opened.
-
Door panel closed
This Trigger fires when any or a specific door panel is closed.
-
Access sensor opened
This Trigger fires when any or a specific access sensor is opened.
-
Access sensor closed
This Trigger fires when any or a specific access sensor is closed.
-
Motion detected
This Trigger fires when any or a specific motion sensor detects motion. Your Scout system must be in an Armed state.
Mode armed
This Trigger fires when a mode is armed.
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.
Mode disarmed
This Trigger fires when a mode is disarmed.
New worksheet in spreadsheet
This trigger fires when a new worksheet is added to a spreadsheet you specify.
Alarm triggered
This Trigger fires when the alarm for a specific mode is triggered.
New row added to spreadsheet
This trigger fires when a new row is added to a spreadsheet you specify.
Alarm dismissed
This Trigger fires when the alarm for a specific mode is dismissed.
Cell updated in spreadsheet
This trigger fires when a particular cell is updated within the spreadsheet you specify.
Door panel opened
This Trigger fires when any or a specific door panel is opened.
Door panel closed
This Trigger fires when any or a specific door panel is closed.
Access sensor opened
This Trigger fires when any or a specific access sensor is opened.
Access sensor closed
This Trigger fires when any or a specific access sensor is closed.
Motion detected
This Trigger fires when any or a specific motion sensor detects motion. Your Scout system must be in an Armed state.
Queries (With)
-
History of Access sensor closed
This query returns a list of when any or a specific access sensor was closed.
-
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 whena mode was armed
This query returns a list of when a mode was armed.
-
Current value of a cell
This query returns the current value of a single cell in your spreadsheet.
-
History of when a Door panel was closed
This query returns a list of when any or a specific door panel was closed.
-
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 a mode was disarmed
This query returns times when a mode was disarmed.
-
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 times Alarm was dismissed
This query returns a list of when the alarm for a specific mode was dismissed.
-
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 when Door panel was opened
This query returns a list of times when any or a specific door panel was opened.
-
History of worksheets in spreadsheet
This query returns a list of when a new worksheet is added to a spreadsheet you specify.
-
History of Alarm triggers
This query returns a list of times when the alarm for a specific mode was triggered.
-
History of times Access sensor opened
This query returns a list of times when any or a specific access sensor was opened.
-
History of Motion detected
This query returns a list of when any or a specific motion sensor detected motion while your Scout system was in an Armed state.
History of Access sensor closed
This query returns a list of when any or a specific access sensor was closed.
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 whena mode was armed
This query returns a list of when a mode was armed.
Current value of a cell
This query returns the current value of a single cell in your spreadsheet.
History of when a Door panel was closed
This query returns a list of when any or a specific door panel was closed.
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 a mode was disarmed
This query returns times when a mode was disarmed.
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 times Alarm was dismissed
This query returns a list of when the alarm for a specific mode was dismissed.
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 when Door panel was opened
This query returns a list of times when any or a specific door panel was opened.
History of worksheets in spreadsheet
This query returns a list of when a new worksheet is added to a spreadsheet you specify.
History of Alarm triggers
This query returns a list of times when the alarm for a specific mode was triggered.
History of times Access sensor opened
This query returns a list of times when any or a specific access sensor was opened.
History of Motion detected
This query returns a list of when any or a specific motion sensor detected motion while your Scout system was in an Armed state.
Actions (Then that)
-
Start arming a mode
This Action will arm a mode at your location of choice (home, vacation home, etc).
-
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.
-
Disarm a mode
This Action will disarm a mode at your location of choice (home, vacation home, etc).
-
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.
-
Disarm all modes
This Action will disarm any mode at your location that is in arming or armed mode.
-
Turn on siren
This Action will turn on the siren in the Scout Hub and Scout Door Panels (if you have any).
-
Turn off siren
This Action will turn off the siren in the Scout Hub and Scout Door Panels (if you have any).
-
Chirp
This Action will make the hub chirp.
-
Enable key fob
This Action will enable a key fob at your location of choice.
-
Disable key fob
This Action will disable a key fob at your location of choice.
Start arming a mode
This Action will arm a mode at your location of choice (home, vacation home, etc).
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.
Disarm a mode
This Action will disarm a mode at your location of choice (home, vacation home, etc).
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.
Disarm all modes
This Action will disarm any mode at your location that is in arming or armed mode.
Turn on siren
This Action will turn on the siren in the Scout Hub and Scout Door Panels (if you have any).
Turn off siren
This Action will turn off the siren in the Scout Hub and Scout Door Panels (if you have any).
Chirp
This Action will make the hub chirp.
Enable key fob
This Action will enable a key fob at your location of choice.
Disable key fob
This Action will disable a key fob at your location of choice.
How to connect Google Sheets and Scout Alarm
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 Scout Alarm 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