IFTTT
IFTTT
Explore
Plans
Log in
Get started
Mobile menu
Close menu
Back
Share this using the options below:
Quickly connect BOSMA to Google Sheets
Send this automation to anyone using the options below.
Copy
Or copy link
Copy
Share
Connect
BOSMA
to
Google Sheets
and unlock powerful automations
Start today
Other popular BOSMA workflows and automations
Lock the door with Alexa
BOSMA
8
Set Security Mode to "Away" with Google Assistant
BOSMA
Set Security Mode to "Home" when you return home
BOSMA
7
Tap to trigger device siren.
BOSMA
Set Security Mode to "Home" when it's time to sleep
BOSMA
Tap to set Security Mode to "Disarmed"
BOSMA
2
Trigger device siren with Google Assistant
BOSMA
Set Security Mode to "Away" when you leave home
BOSMA
8
Useful BOSMA and Google Sheets integrations
Triggers (If this)
Detects loitering
This trigger fires when the camera detects an unknown person stays within the camera's view for a period of time.
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.
Someone rings your doorbell
This trigger fires when someone rings your doorbell.
New worksheet in spreadsheet
This trigger fires when a new worksheet is added to a spreadsheet you specify.
Door sensor opens
This trigger fires when a door sensor opens.
New row added to spreadsheet
This trigger fires when a new row is added to a spreadsheet you specify.
Smart button is pressed
This trigger fires when a smart button is pressed.
Cell updated in spreadsheet
This trigger fires when a particular cell is updated within the spreadsheet you specify.
Detects door-breaking
This trigger fires when a lock detects a door-breaking event.
Lock blocked
This trigger fires when a door lock is blocked.
Package theft
This trigger fires when the camera detects someone is trying to steal a package.
Package delivery
This trigger fires when the camera detects that a package has been delivered.
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.
Query your Aegis Smart Locks
This query returns the list of all Aegis Smart Locks you have.
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)
Switch Security Mode
This action will switch your Family's Security Mode to the selected mode.
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.
Lock the Aegis Smart Lock
This action will lock your Aegis Smart Lock.
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.
Unlock the Aegis Smart Lock
This action will unlock your Aegis Smart Lock.
Trigger Device Siren
This action will trigger the siren on the selected Bosma device.
IFTTT helps all your apps and devices work better together
Start automating