Creating My Weekly Timesheet from Email, Calendar, and Slack with a Claude Project

ERIN REID pro Saint Louis, Missouri, USA · 1H AGO

Late timesheets delayed accurate client billing for our advertising and marketing agency, so I built a Claude project that reconstructs my week from the tools I already use. It drafts time entries that I review and approve before anything reaches our system. It's useful for anyone who logs time after the fact and loses track of smaller tasks. 1. Before each run, Claude checks that my Chrome browsing history and Claude conversation export, which have no connector, are current. If one is out of date, it reminds me and asks whether to wait or continue without it. 2. It pulls the time I've already entered in the system so nothing gets posted twice. 3. It searches the emails I sent or replied to, my calendar meetings (using Gemini notes to confirm they happened and how long they ran), files I edited in Google Drive, Slack threads I joined, work-related browsing, and Claude work sessions. 4. It builds a timeline for each day and groups related items into one block. An email, a doc edit, and a Slack thread about the same issue count once. Personal activity is left out. 5. It estimates time for each block, rates each estimate as high, moderate, or low confidence, and assigns a project and task using my past entries as a guide. 6. It combines related time by day, project, and task before rounding up to the nearest quarter hour, so small items aren’t each rounded up separately, and writes a short description for each entry. 7. It flags unexplained gaps during my usual working hours and asks me about them. It never fills them in on its own. 8. It checks my calendar for PTO and applies our rules for days I worked anyway, so I post only the leave I actually took. 9. It produces a daily reconstruction, a ready-to-enter timesheet, and a weekly reconciliation, then saves a draft to the project. 10. I correct or confirm entries, and Claude updates the totals. Once I approve, it saves a final version. Entering and submitting are separate commands, and it runs each only when I say so. The project instructions require Claude never to invent work or pad hours, never to double-count, and to disclose any source it couldn’t search. Instead of trying to remember my week, I now review entries that already have project codes and descriptions, and it also surfaces work I had forgotten.