Log WiFi connections/disconnections
Start today
Other popular Google Sheets workflows and automations
- Keep track of a particular stock's daily closing price in a spreadsheet
- Create a new row in Google Sheets when your business is tagged in a Facebook photo
- When a song is added to a Spotify playlist, song details appended to Google Sheet
- Add your Foursquare check-ins (w/ maps) to a spreadsheet
- Add a new row to Google Sheets for all new files in Dropbox folder
- Log People ringing door bell
- Save links I share on Facebook to a Google Drive Spreadsheet
- Create a spreadsheet of new laws, eliminating the need for countless Washington, DC interns
Useful Google Sheets and Smarter integrations
Triggers (If this)
- Kettle has finished boilingThis trigger fires when the Smarter iKettle 3.0 has finished boiling.
- 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.
- Kettle has cooled to temperatureThis trigger fires when the Smarter iKettle 3.0 has reached its 'Cool to' temperature.
- New worksheet in spreadsheetThis trigger fires when a new worksheet is added to a spreadsheet you specify.
- Kettle has finished keeping warmThis trigger fires when the Smarter iKettle 3.0 has finished keeping warm.
- New row added to spreadsheetThis trigger fires when a new row is added to a spreadsheet you specify.
- Coffee has finished brewingThis trigger fires when the Smarter Coffee 2.0 has finished brewing.
- Cell updated in spreadsheetThis trigger fires when a particular cell is updated within the spreadsheet you specify.
- Coffee has finished keeping warmThis trigger fires when the Smarter Coffee 2.0 has finished keeping warm.
- FridgeCam has a low batteryThis trigger fires when the FridgeCam has a low battery.
- FridgeCam detects that the door has been open for too longThe fridge door has been left open for too long.
- FridgeCam detects that the fridge temperature is too highThis trigger fires when the temperature inside the fridge becomes too high.
- FridgeCam detects that the fridge temperature is too lowThis trigger fires when the temperature inside the fridge becomes too low.
- FridgeCam detects that an item has changed in the fridgeThis trigger fires when an item is added to, or removed from, the fridge.
- FridgeCam detects that an item has been added to the shopping listThis trigger fires when an item is added to the fridge.
- FridgeCam detects that an item was removed from the shopping listThis trigger fires when an item is removed from the fridge.
Queries (With)
- 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 kettle has finished boilingThis query returns a list of when the Smarter iKettle 3.0 has finished boiling.
- Current value of a cellThis query returns the current value of a single cell in your spreadsheet.
- History of coffee has finished brewingThis query returns a list of when the Smarter Coffee 2.0 was finished brewing.
- 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 FridgeCam detected that the door has been open for too longThsi query returns a list of when the fridge door was been left open for too long.
- 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 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 worksheets in spreadsheetThis query returns a list of when a new worksheet is added to a spreadsheet you specify.
Actions (Then that)
- Boil the kettleThis action will boil a Smarter iKettle 3.0.
- 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.
- Brew coffeeThis action will brew coffee.
- 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.
Google Sheets and Smarter resources
Have the best vacation ever 2024
Make the most of your leisure time with connected hacks featuring Google, Reddit, Foursquare, and more.
Best ClickUp integrations for small and mighty teams
In this blog IFTTT provides the best ClickUp integrations to help small teams succeed.
IFTTT helps all your apps and devices work better together