Log temperature readings to Google Sheets
Start today
Popular Google Sheets and Powered by Viva workflows and automations
Useful Google Sheets and Powered by Viva 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.
- Door closedThis trigger fires when a specific door closes.
- Temperature reading receivedThis trigger fires when a specific sensor reads the temperature.
- 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.
- Smoke detectedThis trigger fires when smoke is detected.
- Alarm breachedThis trigger fires when the alarm in the house is breached, requires a subscription with alarm functionality.
- At least one person arrives homeThis trigger fires when at least one family member has come home.
- Water leak detectedThis trigger fires when a water leak is detected.
- Door unlockedThis trigger fires when a specific door is unlocked
- Glass breakage detectedThis trigger fires when glass breakage is detected.
- Color changed on bulbThis trigger fires when a specific light bulb changes color.
- The current battery levelThis trigger fires when a specific light bulb changes brightness.
- Door lockedThis trigger fires when a specific door is locked.
- Luminance report receivedThis trigger fires when a specific sensor measures the luminance.
- Battery report receivedThis trigger fires when a specific device reports its battery level.
Queries (With)
- History of battery level reports for a specific deviceThis query returns a recent history of when a device reported a battery level.
- 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 detection of someone waking up.This querty returns a recent list of detections of someone waking up.
- Current value of a cellThis query returns the current value of a single cell in your spreadsheet.
- History of door opensThis query returns a list of when a specific door opens.
- History of rows added to spreadsheetThis query returns a list of when a new row is added to a spreadsheet you specify.
- History of device onsThis query returns a list of when a specific device was turned on.
- 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 door unlocksThis query returns a list of when a specific door was unlocked
- 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 temperature reading receivedThis query returns a list of when a specific sensor reads the temperature.
- History of worksheets in spreadsheetThis query returns a list of when a new worksheet is added to a spreadsheet you specify.
- History of device turned offThis query returns a list of when a specific device was turned off.
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 offThis action will turn off the alarm in your house, this requires a subscription with alarm functionality.
- 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.
IFTTT helps all your apps and devices work better together