Track work hours in a Google Spreadsheet
Start today
Triggers (If this)
Queries (With)
Actions (Then that)
Other popular Google Sheets workflows and automations
-
4.19K
-
-
Log all players that killed my character
3.36K
-
-
Automatically track your Fitbit weight logs in a Google spreadsheet
8.59K
-
-
Log new items in Raindrop.io to a Google Sheet
1.01K
-
-
Back up new texts you receive on your Android device to a Google Spreadsheet
13.1K
-
-
Keep a simple spreadsheet of every Tweet you post
35.9K
-
-
Save the Tweets you like on Twitter to a Google Spreadsheet
2.52K
-
-
Keep a running Drive spreadsheet of Pocket articles
970
-
-
When motion is detected, log the event in a spreadsheet.
949
-
Useful Google Sheets and Smarter integrations
Triggers (If this)
-
Kettle has finished boiling
This trigger fires when the Smarter iKettle 3.0 has finished boiling.
-
New spreadsheet added to folder
This 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 temperature
This trigger fires when the Smarter iKettle 3.0 has reached its 'Cool to' temperature.
-
New worksheet in spreadsheet
This trigger fires when a new worksheet is added to a spreadsheet you specify.
-
Kettle has finished keeping warm
This trigger fires when the Smarter iKettle 3.0 has finished keeping warm.
-
New row added to spreadsheet
This trigger fires when a new row is added to a spreadsheet you specify.
-
Coffee has finished brewing
This trigger fires when the Smarter Coffee 2.0 has finished brewing.
-
Cell updated in spreadsheet
This trigger fires when a particular cell is updated within the spreadsheet you specify.
-
Coffee has finished keeping warm
This trigger fires when the Smarter Coffee 2.0 has finished keeping warm.
-
FridgeCam has a low battery
This trigger fires when the FridgeCam has a low battery.
-
FridgeCam detects that the door has been open for too long
The fridge door has been left open for too long.
-
FridgeCam detects that the fridge temperature is too high
This trigger fires when the temperature inside the fridge becomes too high.
-
FridgeCam detects that the fridge temperature is too low
This trigger fires when the temperature inside the fridge becomes too low.
-
FridgeCam detects that an item has changed in the fridge
This trigger fires when an item is added to, or removed from, the fridge.
-
FridgeCam detects that an item has been added to the shopping list
This trigger fires when an item is added to the fridge.
-
FridgeCam detects that an item was removed from the shopping list
This trigger fires when an item is removed from the fridge.
Kettle has finished boiling
This trigger fires when the Smarter iKettle 3.0 has finished boiling.
New spreadsheet added to folder
This 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 temperature
This trigger fires when the Smarter iKettle 3.0 has reached its 'Cool to' temperature.
New worksheet in spreadsheet
This trigger fires when a new worksheet is added to a spreadsheet you specify.
Kettle has finished keeping warm
This trigger fires when the Smarter iKettle 3.0 has finished keeping warm.
New row added to spreadsheet
This trigger fires when a new row is added to a spreadsheet you specify.
Coffee has finished brewing
This trigger fires when the Smarter Coffee 2.0 has finished brewing.
Cell updated in spreadsheet
This trigger fires when a particular cell is updated within the spreadsheet you specify.
Coffee has finished keeping warm
This trigger fires when the Smarter Coffee 2.0 has finished keeping warm.
FridgeCam has a low battery
This trigger fires when the FridgeCam has a low battery.
FridgeCam detects that the door has been open for too long
The fridge door has been left open for too long.
FridgeCam detects that the fridge temperature is too high
This trigger fires when the temperature inside the fridge becomes too high.
FridgeCam detects that the fridge temperature is too low
This trigger fires when the temperature inside the fridge becomes too low.
FridgeCam detects that an item has changed in the fridge
This trigger fires when an item is added to, or removed from, the fridge.
FridgeCam detects that an item has been added to the shopping list
This trigger fires when an item is added to the fridge.
FridgeCam detects that an item was removed from the shopping list
This trigger fires when an item is removed from the fridge.
Queries (With)
-
Current values of a row
This 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 boiling
This query returns a list of when the Smarter iKettle 3.0 has finished boiling.
-
Current value of a cell
This query returns the current value of a single cell in your spreadsheet.
-
History of coffee has finished brewing
This query returns a list of when the Smarter Coffee 2.0 was finished brewing.
-
History of rows added to spreadsheet
This 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 long
Thsi query returns a list of when the fridge door was been left open for too long.
-
History of when Cell was updated in spreadsheet
This query returns a list of when a particular cell was updated within the spreadsheet you specify.
-
History of spreadsheets added to folder
This 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 spreadsheet
This query returns a list of when a new worksheet is added to a spreadsheet you specify.
Current values of a row
This 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 boiling
This query returns a list of when the Smarter iKettle 3.0 has finished boiling.
Current value of a cell
This query returns the current value of a single cell in your spreadsheet.
History of coffee has finished brewing
This query returns a list of when the Smarter Coffee 2.0 was finished brewing.
History of rows added to spreadsheet
This 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 long
Thsi query returns a list of when the fridge door was been left open for too long.
History of when Cell was updated in spreadsheet
This query returns a list of when a particular cell was updated within the spreadsheet you specify.
History of spreadsheets added to folder
This 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 spreadsheet
This query returns a list of when a new worksheet is added to a spreadsheet you specify.
Actions (Then that)
-
Boil the kettle
This action will boil a Smarter iKettle 3.0.
-
Add row to spreadsheet
This 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 coffee
This action will brew coffee.
-
Update cell in spreadsheet
This 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.
Boil the kettle
This action will boil a Smarter iKettle 3.0.
Add row to spreadsheet
This 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 coffee
This action will brew coffee.
Update cell in spreadsheet
This 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