Write a weekly project status report
Done, in progress, late and blocked work from your project tool, added to one status doc.
- On a schedule: Every Friday at 14:00
What it does
The task
Open the project at project url and read the tasks that changed in the last 7 days. Sort them into four groups: done, in progress, late and blocked. For each late or blocked task, give the owner, the due date and the last comment. Add a new section at the top of the Google Doc doc url with the date, a summary of three lines and the four groups. Do not change any task.
- It works in Asana, Jira, Linear and Google Docs, in the workspace you pick, and signs in with passwords from your Cuiar vault.
- As a routine it runs every Friday at 14:00 (cron
0 14 * * 5).
What you give it
| Blank | What to give | Example |
|---|---|---|
| project url | The link to the project in Asana, Jira or Linear | https://app.asana.com/0/1208843311/list |
| doc url | The Google Doc for the status reports | https://docs.google.com/document/d/1xStatusOfficeMove |
What you get back
An example run with the example values above. Your run uses your own data.
Week of 2 Nov, Office move
Summary: 14 tasks done. 2 tasks are late, and 1 is blocked by the landlord.
Done (14): Network cabling, Desk order, Parking permits and 11 more
In progress (9): Movers contract (Sam Ito, due 12 Nov) and 8 more
Late (2)
- Badge readers installed: Leo Brandt, due 30 Oct. Last comment: "Waiting for parts."
- Signage proof: Mia Clarke, due 3 Nov. No comment.
Blocked (1)
- Kitchen fit-out: Sam Ito. Waiting for landlord approval since 28 Oct.
Added to the top of the doc "Office move status".
Run it in Cuiar
- 01
Open it
Click Use in Cuiar on this page. The side panel opens with the task in the composer.
- 02
Fill in 2 blanks
Type project url and doc url. Tab moves to the next blank.
- 03
Run it, then repeat it
Run sends it once. To run it every Friday at 14:00, make a routine on cuiar.com/routines or with the CLI below.
As a routine, from the terminal
cuiar routines create "Write a weekly project status report" --schedule "0 14 * * 5" --time-zone Europe/Berlin \
"Open the project at https://app.asana.com/0/1208843311/list and read the tasks that changed in the last 7 days. Sort them into four groups: done, in progress, late and blocked. For each late or blocked task, give the owner, the due date and the last comment. Add a new section at the top of the Google Doc https://docs.google.com/document/d/1xStatusOfficeMove with the date, a summary of three lines and the four groups. Do not change any task."Run it from your AI agent
Claude Code, Codex, Cursor and other MCP clients reach Cuiar at https://mcp.cuiar.com/mcp. Add the server one time, then ask for the task in plain words, or call create_routine yourself.
1. Add Cuiar to Claude Code
claude mcp add --transport http cuiar https://mcp.cuiar.com/mcp2. Ask your agent
Use the Cuiar tool create_routine to run my "Write a weekly project status report" template with project url = https://app.asana.com/0/1208843311/list; doc url = https://docs.google.com/document/d/1xStatusOfficeMove.Setup for other agents: AI agents.
The tool call
{
"name": "create_routine",
"arguments": {
"name": "Write a weekly project status report",
"task": "Open the project at https://app.asana.com/0/1208843311/list and read the tasks that changed in the last 7 days. Sort them into four groups: done, in progress, late and blocked. For each late or blocked task, give the owner, the due date and the last comment. Add a new section at the top of the Google Doc https://docs.google.com/document/d/1xStatusOfficeMove with the date, a summary of three lines and the four groups. Do not change any task.",
"schedule": "0 14 * * 5",
"time_zone": "Europe/Berlin"
}
}Related templates
All ops templatesOpsAsks first
Prepare a handover before you go on leave
Open threads, tasks and meetings for your cover in one doc, and a draft out-of-office reply.
You start it: When you start it- Gmail
- Google Calendar
- Asana
- +1 more: Google Docs
Ops
Send me my agenda and tasks every morning
Today's meetings with their links and documents, and the tasks that are due, in one e-mail.
On a schedule: Every weekday at 7:00- Google Calendar
- Asana
- Gmail
Ops
Summarize this week's support tickets
The top issues by volume, the change against last week and two example tickets for each.
On a schedule: Every Monday at 8:00- Help Scout
- Google Docs
Ops
Draft the agenda for your weekly team meeting
Open actions from last week's notes, new topics from the team channel and blocked work, with times.
On a schedule: Every Monday at 15:00- Notion
- SSlack
- Linear
OpsAsks first
Send a recap and action items after each meeting
Decisions, owners and due dates from the meeting transcript, in a draft e-mail to the guests.
On an event: When a meeting with a transcript ends- Google Calendar
- Google Meet
- Google Docs
- +1 more: Gmail
Ops
Write an SOP for a task in a web app
Numbered steps with the exact names of menus and fields, checked in the app, in a Google Doc.
You start it: When you start it- Any admin panel
- Google Docs