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
The integration steps this workflow runs, in the order it first runs them.
- 1Google SheetsRead rows
- 2Google SheetsAppend row
- 3GmailSend
How it works
Everything the template sets up, and what to fill in before the first run.
Turns the clock-in and clock-out times your team writes down themselves into a weekly per-person total, so nobody has to add up a spreadsheet by hand on a Monday morning.
Every Monday at 07:00 it reads your 'Time entries' tab, keeps the entries dated in the seven days before today, works out the hours between each start and finish, and appends one row per person to your 'Weekly summary' tab: week ending, person, hours, how many entries were counted, how many need attention, and what to check. It only ever appends - your entries are read and never edited, and last week's summary rows stay where they are.
An entry it cannot read is reported, never counted as zero. A missing name, a missing or badly written date or time, and a finish time that is not after the start all land in that person's 'Entries to check' cell with the sheet row number, so the total you see is always the total of the entries it could actually read.
Set it up by pasting your spreadsheet link into the 'spreadsheetUrl' step. Your entries tab needs these four column headings in row 1, spelled exactly like this - the workflow reads columns by name, so the headings have to match, though their order does not: Date (YYYY-MM-DD), Person (a name or an email address), Start (HH:MM, 24-hour) and End (HH:MM, 24-hour). Change 'entriesTab' or 'summaryTab' if your tabs are named differently. Add an address to 'managerEmail' to have the same summary emailed to a manager or to payroll; leave it blank and the summary is written to the sheet only.
It records what people report about themselves. It does not track where anyone is, and asks for no location or device information.
You May Also Be Interested In
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.Send sentiment-aware emails with couponsEmails each customer about their purchase in your tone, reads their feedback first, and adds a coupon when the feedback is negative.Save matching emails to a spreadsheetSaves each new Gmail message that matches your search as a row in your spreadsheet, and never saves the same message twice.
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