Friday timesheet chase
Reminds everyone who has not submitted their hours, and tells their manager who was reminded.
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 only the people whose Hours this week is empty.
If
missing.countis more than 0For each
person- 2GmailSendReminds each person, and sends the manager the list.
- 2
- 3GmailSend
How it works
What happens on each run, in plain English.
On Friday afternoon this reads your Timesheets sheet and emails each person whose Hours this week is still blank, asking them to submit their hours.
Your manager gets one email naming everyone who was reminded. If everyone has submitted, nothing is sent. The sheet needs the columns Name, Email and Hours this week.
You may also be interested in
Offboard a leaving employeeWhen a row is added to your Offboarding sheet, creates the offboarding tasks in Asana, dated from the last day, and emails the manager.Approve time off requests from a sheetAsks the employee's manager to approve each time off request in a sheet, then updates the row and tells the employee.Create onboarding tasks for a new hireWhen you add a new hire to a Google Sheet, creates their kickoff, IT setup and benefits tasks in Asana and tells their manager.
Tell the team who's out this weekEvery Monday morning, posts who is on leave this week from BambooHR to Slack, with their dates, holidays and work anniversaries.Start from a workflow that already works.
Add "Friday timesheet chase" to your workspace, connect its apps, and make it yours.
Free plan, no credit card