Save motion events to Google Sheets
Start today
Popular Google Sheets and Smart Home Solution workflows and automations
Useful Google Sheets and Smart Home Solution integrations
Triggers (If this)
- Device turned onThis trigger fires when a specific device is turned on.
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.- Device turned offThis trigger fires when a specific device is turned off.
- New worksheet in spreadsheetThis trigger fires when a new worksheet is added to a spreadsheet you specify.
- Motion detectedThis trigger fires when motion is detected.
- New row added to spreadsheetThis trigger fires when a new row is added to a spreadsheet you specify.
- Door openedThis trigger fires when a specific door opens.
- Cell updated in spreadsheetThis trigger fires when a particular cell is updated within the spreadsheet you specify.
- Alarm breachedThis trigger fires when the alarm in the house is breached, requires a subscription with alarm functionality.
- Door closedThis trigger fires when a specific door closes.
- Temperature reading receivedThis trigger fires when a specific sensor reads the temperature.
- Water leak detectedThis trigger fires when a water leak is detected.
- Brightness changed on bulbThis trigger fires when a specific light bulb changes brightness.
- Color changed on bulbThis trigger fires when a specific light bulb changes color.
- Smoke detectedThis trigger fires when smoke is detected.
- Battery report receivedThis trigger fires when a specific device reports its battery level.
- Luminance report receivedThis trigger fires when a specific sensor measures the luminance.
- Glass breakage detectedThis trigger fires when glass breakage is detected.
- We detect that the home is emptyThis trigger fires when every family member has left.
- We detect that everyone has gone to sleepThis trigger fires when everyone has gone to sleep.
- We detect that someone has woken upThis trigger fires when everyone has woken up.
- At least one person arrives homeThis trigger fires when at least one family member has come home.
- Door lockedThis trigger fires when a specific door is locked.
- Door unlockedThis trigger fires when a specific door is unlocked
Queries (With)
- History of everyone has gone to sleepThis query returns a list of when everyone was gone to sleep.
- 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 when the alarm triggeredThis query returns a list of when the alarm in the house was breached, requires a subscription with alarm functionality.
- Current value of a cellThis query returns the current value of a single cell in your spreadsheet.
- History of door lockedThis query returns a list of when a specific door was locked.
- History of rows added to spreadsheetThis query returns a list of when a new row is added to a spreadsheet you specify.
- History of color changes on bulbThis query returns a list of when a specific light bulb changes color.
- 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 device turned offThis query returns a list of when a specific device was turned off.
- 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 battery report receivedThis query returns a list of when a specific device reports its battery level.
- History of worksheets in spreadsheetThis query returns a list of when a new worksheet is added to a spreadsheet you specify.
Actions (Then that)
- Turn device offThis action will turn a device off given a name.
- 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.
- Turn device onThis action will turn a device on given a name.
- 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.
- Turn alarm onThis action will turn on the alarm in your house, this requires a subscription with alarm functionality.
- Unlock doorThis action will unlock a specific door.
- Change brightness of bulbThis action will change the brightness of a bulb given a name.
- Lock doorThis action will lock a specific door.
- Change color of bulbThis action will change the color of a bulb given a name.
- Turn alarm offThis action will turn off the alarm in your house, this requires a subscription with alarm functionality.
Google Sheets and Smart Home Solution resources
Automations for teachers
From homework tracking to sharing photos with parents, as well as creating custom voice responses for your classroom, IFTTT has the ability to save you time every day. Additionally, existing integrations with Google Drive, Google Sheets,...
7 best spreadsheet apps other than Excel
Check out our recommendations for the best spreadsheet apps and learn how you can build useful automations in minutes with IFTTT!
How to Export Asana Projects to Google Sheets
Keep clear track of your Asana projects in a spreadsheet - Set up an Asana to Sheets integration in minutes with IFTTT.
IFTTT helps all your apps and devices work better together