Build yesterday's timesheet from what you actually did
Rebuilds yesterday from your calendar, sent mail and commits, and appends one evidence row to your timesheet.
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 columnReads the date column of the 'Timesheet' tab so a day already written up is never added twice.
- 2Google CalendarCheck timeslotAsks your calendar which windows were marked busy between the start and end of your working day on that date.
- 3GmailList emailsCounts the emails you sent that day, adding a note to the row if the count reached its cap.
- 4AnthropicGenerate model responseAsks the AI for one or two sentences on the shape of the day, using only the counted figures and inventing nothing.
- 5Google SheetsAppend rowAppends one row with the date, meeting minutes and hours, busy windows, emails sent, commits, repositories, summary and notes.
How it works
What happens on each run, in plain English.
Every day at 12:00, yesterday is rebuilt from the traces it left: the time your calendar was marked busy during your working day, the mail you sent, and the commits you pushed to the repositories you list. One evidence row is appended to your timesheet, so a billable day starts from evidence rather than memory.
Each row records meeting minutes and hours, how many busy windows there were, how many emails went out, commits pushed and where, and one or two AI-written sentences on the shape of the day, drawn only from the counted figures with nothing invented. If your calendar or mailbox could not be read, that cell is left blank and the reason goes in the 'Notes' column, so a blank never quietly reads as zero. A day already on the tab is never written twice, and nothing already there is edited.
Before the first run you need a Google Sheet with a 'Timesheet' tab headed for the columns the row fills. Commits are optional and need a GitHub token.
You May Also Be Interested In
Welcome new clients from their intake formWrites a personalised welcome email from each new client intake row, asks you to approve it, then sends it or drafts it.Score client health from your email logScores how satisfied each client sounds in the emails you log every week and keeps a client health dashboard tab up to date.
Track a property market over timeSearches one property site each week, records the listings that are new to you, and logs how the record has changed.
Watch your websites for downtimeChecks every site listed in a spreadsheet on a schedule and alerts you in Slack or by email when one goes down or recovers.
Start from a workflow that already works.
Add "Build yesterday's timesheet from what you actually did" to your workspace, connect its apps, and make it yours. No credit card required.
Free plan available · No credit card required