Create a Google spreadsheet entry every time you charge your Android device
Start today
Other popular Google Sheets workflows and automations
- When motion is detected, log the event in a spreadsheet.
- Save your Misfit sleep logs to a Google Spreadsheet
- Add new ClickUp tasks to a Google Sheets spreadsheet
- Log every time you stop charging your phone to a Google spreadsheet
- Track watering in a Google spreadsheet
- Archive every time you're @mentioned to a Google spreadsheet
- Automatically log work hours in a spreadsheet
- Add new Square payments to a spreadsheet
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