Track working hours

Connect

Clock in and out of work to track your hours. By default this Applet requires that your Google Sheets file has a second sheet titled "status".

If

Button press

This trigger fires every time you press the button.

With

Query

This query returns the current value of a single cell in your spreadsheet.

When

Filter code

Then

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.

And

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.