Other popular Google Sheets workflows and automations
- Save links I share on Facebook to a Google Drive Spreadsheet
- Log my card purchases to a spreadsheet
- Keep a simple spreadsheet of every Tweet you post
- Save your Fitbit sleep logs to a Google Spreadsheet
- Keep a log of your recently played tracks
- Save all of your liked videos in a spreadsheet
- Save new Google contacts to a Google Drive spreadsheet
- Archive every time you're @mentioned to a Google spreadsheet
- Add new ClickUp tasks to a Google Sheets spreadsheet
Useful Google Sheets and Smart Life integrations
Triggers (If this)
- Device or group is turned onThis trigger fires when the specified device/group 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 or group is turned offThis trigger fires when the specified device/group is turned off.
- New worksheet in spreadsheetThis trigger fires when a new worksheet is added to a spreadsheet you specify.
- Unlock the lockThis trigger fires when user unlocking the lock, his password or fingerprint identification or card is confirmed.
- New row added to spreadsheetThis trigger fires when a new row is added to a spreadsheet you specify.
- Camera detects motionThis trigger fires when the specified camera detects motion. To use this trigger, camera’s motion detection should be turned on.
- Cell updated in spreadsheetThis trigger fires when a particular cell is updated within the spreadsheet you specify.
- Camera detects soundThis trigger fires when the specified camera detects sound. To use this trigger, camera’s sound detection should be turned on.
- Input incorrect password repetitiouslyThis trigger fires when someone input incorrect password repetitiously.
- Battery lowThis trigger fires when residual electricity in the lock under threshold.
- Door sensor is openThis trigger fires when the door sensor is open.
- Door sensor is closedThis trigger fires when the door sensor is closed.
- Person is detectedThis trigger fires when PIR detects person.
- Leak detectedThis trigger fires when water leak detected.
- Sound and light detectedThis trigger fires when water sound and light detected.
- Shake detectedThis trigger fires when sensor shake detected
Queries (With)
- History of Leak detectedThis query returns a list of times when the sensor detected a water leak.
- 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 Door sensor was closedThis query returns a list of times when the door sensor was closed.
- Current value of a cellThis query returns the current value of a single cell in your spreadsheet.
- History of when Door sensor was openThis query returns a list of times when the door sensor was open.
- 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 Person was detectedThis query returns a list of when PIR detected person.
- 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 times when the specified device/group 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 Device was turned onThis query returns a list of when the specified device/group was turned on.
- History of worksheets in spreadsheetThis query returns a list of when a new worksheet is added to a spreadsheet you specify.
- History of repetitious incorrect password alertsThis query returns a list of times when someone input an incorrect password repetitiously.
- History of motion detections by CameraThis query returns a list of when a Camera detected motion. To use this query, Camera motion detected should be turned on.
- History of Camera detected soundThis query returns a list of times when the specified camera detected sound. To use this query, camera’s sound detection must have been turned on.
- History of Shake detectedThis query returns a list of when sensor detected a shake
- History of when lock unlockedThis query returns a list of when a user unloocked the lock and his password, fingerprint identification, or card was confirmed.
- History of Sound or Light DetectedThis query returns a list of when water sound or light were detected.
- History of low Battery alertsThis query returns a list of when residual electricity in the lock dropped below the threshold. Note: this query will only return future events after this Applet is created.
Actions (Then that)
- Turn onThis action will turn on the device/group of your choosing.
- 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 offThis action will turn off the device/group of your choosing.
- 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.
- Activate SceneThis action will activate the specified scene.
- Set light brightnessThis action will set your light to a specified brightness.
- Set light colorThis action will set the light to specified color.
- Start Cool ModeThis action will set your AC to Cool Mode.
- Start Heat ModeThis action will set your AC to Heat Mode.
- Set AC temperatureThis action will set your AC to a specified temperature by remote controller.
- Turn on oscillation function of fanThis action will turn on the oscillation function of your fan by IR remote controller.
- Turn off oscillation function of fanThis action will turn off the oscillation function of your fan by IR remote controller.
Google Sheets and Smart Life 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,...
Have the best vacation ever 2024
Make the most of your leisure time with connected hacks featuring Google, Reddit, Foursquare, and more.
How to find your next job using automation 2024
Using automations to streamline your productivity at work can be a game changer. But, if you’re not satisfied with your job or on the lookout for a new opportunity, IFTTT can help you there, too. You can easily set up alerts and...
Automations for students 2024
Save yourself time that is often spent getting organized and managing your schedule by automating elements of the manual tasks you need to do. Out of the hundreds of services available on IFTTT, we integrate with many of the popular...
5 best habit tracker apps for self improvement
Looking to start habit tracking? Learn more about it and discover the benefits of habit tracking. IFTTT is here with the best habit tracker apps. Make the most of these helpful apps but automating them with IFTTT
What is influencer marketing and how does it work?
Click to learn What is Influencer Marketing and How Does it Work?