Every Friday afternoon, someone in your team copies numbers from three apps into a spreadsheet, rewrites the same status update, and calls it "the weekly report." It's pure drudgery — and it's exactly the kind of work AI workspaces are good at.
Here are three scenarios I use weekly, each with a prompt template you can copy. They work in any AI chat tool (ChatGPT, Claude, or a multi-model workspace like Mycel); nothing here needs special infrastructure.
Scenario 1: Messy Transactions → Categorized Summary
The raw material: half-organized expense notes, chat logs, meeting scribbles. The goal: categories, dates, and a three-sentence weekly summary.
Steps:
- Copy your raw text (chat logs, email threads, plain text from Excel)
- Use a mid-tier model — you want reliability but not overkill
- Paste this prompt:
Organize the following transaction records by category and produce a concise weekly summary:
- Categories: income, expense, meeting, to-do, other
- List specific items under each category, with dates if present
- End with a 3-sentence summary of the week's key points
[PASTE YOUR RAW TEXT HERE]
Tip: if the input format is really messy, run a cheap fast-model pass first just to normalize the text, then the mid-tier pass for the actual analysis.
Scenario 2: Weekly Report First Draft
Give the AI your raw activity list and a fixed report structure, and let it write the draft you edit instead of a blank page you fear:
You are writing my weekly report. Use this structure:
1. This week's completed work (bullet points, outcomes first)
2. In progress (with status)
3. Risks and blockers
4. Next week's plan
Tone: concise, professional, no fluff. Data comes below; don't invent facts.
[PASTE YOUR WEEK'S ACTIVITY NOTES]
The trick is the last line: don't invent facts. AI drafts are great at phrasing and structure, but the facts must come from you.
Scenario 3: Excel Data → Insights Without Formulas
Paste a table (or CSV text) and ask for analysis instead of writing VLOOKUP formulas you'll forget next month:
Here is my data table in CSV format. Please:
1. Point out anomalies (duplicates, outliers, missing values)
2. Summarize totals by category
3. Suggest 3 follow-up questions a manager might ask about this data
4. Output a cleaned version of the table
[PASTE CSV]
Scenario 3 is where structured + unstructured thinking really pays off: the model catches the duplicate row you'd miss and flags the outlier your boss would ask about.
Why This Beats Manual Work
- Consistency: same structure every week, no "wait, which template did I use?"
- Speed: 15 minutes of formatting becomes 2 minutes of review
- Better questions: when the AI proposes "3 follow-up questions," you look more prepared in the meeting, not less
Cost Note
These are all short-context tasks. On tiered platforms, they belong on the low/mid tier — my weekly-report batch on Mycel costs about 10-20 credits a week (roughly $0.015-0.03). The expensive reasoning tier is unnecessary for this work; save it for actual analysis problems.
The templates above are format-agnostic. If your workspace supports file upload or desktop assistants (Mycel's does), you can skip the copy-paste and feed documents directly — but the prompts stay the same.
Top comments (0)