Get a weekly report draft made automatically
You can do this after: Advanced
💻 This only works on a computer. You'll need Claude Code or the Claude desktop app.
In one line
On weekdays, just drop work notes into a folder. At 4 pm on Friday, Claude gathers those notes and makes a weekly report draft. All you do is read it and polish it.
When to use it
- When every Friday you write a report wondering “What did I even do this week?”
- When your report has a set format and you fill it in the same way every time
Before you start
- You’ll use scheduled tasks in the Claude desktop app. If it’s your first time, see Get a morning briefing automatically first.
- If you’re working with company documents, check your company’s rules about using AI first.
Follow along
Step 1. Set up the folders
Inside a “Weekly Report” folder, set it up like this:
Weekly Report/
notes/ ← where you put note files during the week
template/ ← where you keep one past report
done/ ← where Claude saves the draft
Any format works for notes. One line at a time in a text file is fine, like “11/10 sent revised quote, waiting to hear from Acme Co.”
Step 2. Create the scheduled task
In the Code tab, choose “Weekly Report” as the folder and say:
Illustration (may look a little different from the real screen)
(Scheduled task ran automatically: Friday 4:03 pm)
Sample replyI read this week's 7 notes.
I saved "2026-11-13_weekly-report_draft.docx" in the "done" folder, following the template.
[needs checking] in 2 places
• Which project "that thing" in Thursday's note refers to
• The date Acme Co. replied
Step 3. Watch it the first time
Run it once with Run now, and when it asks for permission to read and create files, choose Always allow. If the draft doesn’t match the template, adjust the job description, with things like “make headings bold” or “separate what’s done from next week’s to-dos.”
Make it your own
- End of each month: “Make a monthly results summary from this month’s notes”
- Every day before you leave work: “Turn today’s notes into tomorrow’s to-do list”
- A meeting notes folder: “Gather only what was decided in this week’s meetings onto one page”
Watch out for
- A draft is just a draft. Always check numbers, dates, and names yourself before sending.
- Including “don’t make anything up” and “mark it [needs checking]” cuts down on Claude filling in gaps with plausible-sounding guesses.
- To make Word files better, install the document skills in Claude Code (see Merge dozens of Excel files into one). If it still won’t make the file, you can change it to “save it as a Markdown (.md) file.”
I'm stuck here
Stuck while following along? Tell me where. Only the site owner sees this. Leave your email only if you'd like a reply.
💌 Get new tips by email
I'll email you when a new tip goes up. No ads, ever.