Effortless Annual Reviews with Claude

Instead of trying to remember 12 months of work in one December scramble, you can build a simple system in Claude that logs your direct reports' accomplishments all year, tracks them in a spreadsheet, and turns that evidence into a first-draft performance review in minutes.

Privacy note: This system involves personnel data. Keep the Project private (not shared team-wide), be thoughtful about what you connect it to, and check your company's HR data policies before logging anything sensitive. Review anything Claude drafts — log entries or review text — before it's used or shared.

What do I need before I start?

• A Claude account with Projects
• Google Sheets/Drive connected in Claude (Customize → Connectors → Google Drive → Connect)
• Optional for the bonus step: Gmail and Slack connected

How do I choose my review categories?

Decide what you're tracking against before you build anything. Use your company's existing review framework if one exists, or a simple one like this:

1. Ownership — took initiative, drove projects to completion
2. Collaboration — helped others, worked well across teams
3. Impact — measurable results, client or business outcomes
4. Growth — new skills, stretch assignments, feedback applied

Also list the direct reports you'll track.

Step 1: How do I set up the Project?

1. Go to Projects in the left sidebar and click + New Project.
2. Name it something like "[Your Name]'s Team Accomplishment Log."
3. Add these project instructions so every chat follows the same rules:

These are notes I'm collecting throughout the year about my direct reports' accomplishments, growth, and contributions, to use when writing performance reviews. Keep entries factual and specific — dates, projects, measurable outcomes, and direct quotes from feedback when I have them. Organize by person, then by category: [list your categories].

Step 2: How do I create the tracking spreadsheet?

Build it once, inside the Project, so Claude always knows where to log new entries:

Create a Google Sheet called "[Team Name] Accomplishment Log" with these columns: Date, Direct Report, Category, Accomplishment, Evidence/Source (e.g., email, Slack message, client quote), and Manager Notes. Set up one row per entry so I can keep adding to it easily throughout the year.

Step 3: How do I log accomplishments all year?

Whenever something noteworthy happens — a shipped project, a client compliment, a tough problem solved — tell Claude right away in this Project. It takes 30 seconds and saves hours in December.

Add a new entry to my [Team Name] Accomplishment Log:
Direct report: [Name].
Date: [date].
Category: [category from your list].
What happened: [describe what they did, in a sentence or two].
Evidence: [e.g., "client email praising the deliverable," or "shipped the migration two weeks ahead of schedule"].

Tip: Put a weekly or biweekly reminder on your calendar to log anything you noticed. Little and often beats reconstructing a year from memory.

Step 4 (Bonus): How can Claude catch wins I might miss?

If Gmail and Slack are connected, add a scheduled task that flags praise for your team. It never adds anything without your OK.

Set up a weekly scheduled task that checks my email and Slack for messages that look like praise, positive feedback, or recognition of someone on my team: [list your direct reports' names]. For anything that qualifies, draft a suggested log entry (direct report, date, category, what happened, evidence) and send it to me for approval. Never add an entry to the [Sheet name] log without my confirmation first.

Step 5: How do I generate the year-end review?

Using the full year of entries in my [Team Name] Accomplishment Log for [Direct Report Name], write a draft performance review organized by category: [list your categories]. For each category, summarize the pattern of contributions and cite 2-3 specific, dated examples from the log as evidence. End with a short overall summary. Keep the tone constructive and specific — this is a first draft for me to review and personalize, not a final document.

Repeat once per direct report, or ask Claude to produce a separate draft for each person in one pass.

Where do I manage this system?