Weekly timesheet hours summary
Totals the clock-in and clock-out times your team logs themselves into a weekly hours summary per person.
Apps it connects
Authenticate each one once and the workflow is ready to run.
What it does
Each integration step this workflow runs, in order, what it is for, and the conditions and loops that decide when it runs.
- 1Google SheetsRead rowsReads the 'Time entries' tab, taking each row's date, person, start and end by column heading.
For each
person- 2Google SheetsAppend rowAppends one row per person to the 'Weekly summary' tab: week ending, hours, entries counted, entries to check and what to check.
- 2
If
managerEmailis not empty- 3GmailSendEmails the per person totals and any entries needing attention to the manager or payroll address you give it.
- 3
How it works
What happens on each run, in plain English.
Every Monday at 07:00, the workflow reads the clock-in and clock-out times your team logs on a 'Time entries' tab, keeps those from the previous seven days, works out the hours in each and totals them per person, so nobody adds up a spreadsheet by hand.
One row per person is appended to a 'Weekly summary' tab: week ending, hours, entries counted, entries needing attention and what to check. Your entries are only ever read, never edited, and last week's summary rows stay where they are. An entry that cannot be read is reported, never counted as zero: a missing name, a badly written date or time, or a finish not after the start is listed with its row number, so the total covers only what could be read. If you give it an address, the same summary is emailed to a manager or to payroll.
Your entries tab needs 'Date', 'Person', 'Start' and 'End' headings, with dates as YYYY-MM-DD and 24 hour times. It records only what people report about themselves and asks for no location or device data.
You May Also Be Interested In
Parse emailed CVs into a talent sheetReads each job application that lands in Gmail, adds the candidate's details as a row in your Google Sheet and tells your team in Slack.Weekly employee feedback digestEvery Monday, the week's feedback form responses summarized for HR and emailed, then cleared from the sheet.Welcome next week's new startersEvery Monday, emails anyone starting in the next week and tells the team in Slack who is joining.Extract purchase orders from GmailReads each new purchase order email, looks its items up in your product list, and logs every line with name and price.
Start from a workflow that already works.
Add "Weekly timesheet hours summary" to your workspace, connect its apps, and make it yours. No credit card required.
Free plan available · No credit card required