IFTTT
IFTTT
Explore
Solutions
AI Tools
Smart Home
Social Media
Lead Management
Productivity
Customer Communications
Lifestyle
IFTTT for students
Plans
Log in
Get started
Mobile menu
Close menu
Back
Connect
Google Sheets
to
Scout Alarm
and unlock powerful automations
Start today
Other popular Google Sheets workflows and automations
Log all players that killed my character
Rust
2.3k
Keep a log of your recently played tracks
Spotify
986
Log People ringing door bell
Ring
1.2k
Record every time your phone's battery is low in a Google spreadsheet
Google
3.0k
Track #hashtag mentions in a Google Spreadsheet
Twitter
2.4k
Do more with your Discover Weekly playlist
Spotify
1.1k
Track every time the ISS passes over your house
by
IFTTT
4.1k
Automatically add a new row to Google Sheets when you receive a new Google Business review
Google
4
Create a Google spreadsheet entry every time you charge your Android device
Google
9.1k
Useful Google Sheets and Scout Alarm integrations
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.
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.
Actions (Then that)
Start arming a mode
This Action will arm 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 a mode
This Action will disarm 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 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.
IFTTT helps all your apps and devices work better together
Start automating