Call Log, Missed call
Start today
Other popular Google Sheets workflows and automations
- Log your Facebook status updates in Google Drive spreadsheet
- Sync all your new iOS Contacts to a Google Spreadsheet
- Create a Google spreadsheet entry every time you charge your Android device
- Save the Tweets you like on Twitter to a Google Spreadsheet
- Track watering in a Google spreadsheet
- Save new Google contacts to a Google Drive spreadsheet
- Log WiFi connections/disconnections
- Add a new row to Google Sheets when there is a pinned message in Discord
Useful Google Sheets and Scout Alarm integrations
Triggers (If this)
- Mode armedThis Trigger fires when a mode is armed.
- New spreadsheet added to folderThis 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 disarmedThis Trigger fires when a mode is disarmed.
- New worksheet in spreadsheetThis trigger fires when a new worksheet is added to a spreadsheet you specify.
- Alarm triggeredThis Trigger fires when the alarm for a specific mode is triggered.
- New row added to spreadsheetThis trigger fires when a new row is added to a spreadsheet you specify.
- Alarm dismissedThis Trigger fires when the alarm for a specific mode is dismissed.
- Cell updated in spreadsheetThis trigger fires when a particular cell is updated within the spreadsheet you specify.
- Door panel openedThis Trigger fires when any or a specific door panel is opened.
- Door panel closedThis Trigger fires when any or a specific door panel is closed.
- Access sensor openedThis Trigger fires when any or a specific access sensor is opened.
- Access sensor closedThis Trigger fires when any or a specific access sensor is closed.
- Motion detectedThis 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 closedThis query returns a list of when any or a specific access sensor was closed.
- Current values of a rowThis query returns the current values in a given row. Values from columns A-Z are available as ingredients.
- History of whena mode was armedThis query returns a list of when a mode was armed.
- Current value of a cellThis query returns the current value of a single cell in your spreadsheet.
- History of when a Door panel was closedThis query returns a list of when any or a specific door panel was closed.
- History of rows added to spreadsheetThis query returns a list of when a new row is added to a spreadsheet you specify.
- History of when a mode was disarmedThis query returns times when a mode was disarmed.
- History of when Cell was updated in spreadsheetThis query returns a list of when a particular cell was updated within the spreadsheet you specify.
- History of times Alarm was dismissedThis query returns a list of when the alarm for a specific mode was dismissed.
- History of spreadsheets added to folderThis 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 openedThis query returns a list of times when any or a specific door panel was opened.
- History of worksheets in spreadsheetThis query returns a list of when a new worksheet is added to a spreadsheet you specify.
- History of Alarm triggersThis query returns a list of times when the alarm for a specific mode was triggered.
- History of times Access sensor openedThis query returns a list of times when any or a specific access sensor was opened.
- History of Motion detectedThis 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 modeThis Action will arm a mode at your location of choice (home, vacation home, etc).
- Add row to spreadsheetThis 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 modeThis Action will disarm a mode at your location of choice (home, vacation home, etc).
- Update cell in spreadsheetThis 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 modesThis Action will disarm any mode at your location that is in arming or armed mode.
- Turn on sirenThis Action will turn on the siren in the Scout Hub and Scout Door Panels (if you have any).
- Turn off sirenThis Action will turn off the siren in the Scout Hub and Scout Door Panels (if you have any).
- ChirpThis Action will make the hub chirp.
- Enable key fobThis Action will enable a key fob at your location of choice.
- Disable key fobThis Action will disable a key fob at your location of choice.
IFTTT helps all your apps and devices work better together