A Friday weekly review desk built on your Google Tasks

Build me a weekly review desk that I open every Friday to close out the week in Google Tasks. It is a single user app for me, not a team tool. The whole point is that Google Tasks shows me no completion history and no throughput at all, so I want one screen that tells me what I actually finished, what I did not, and whether the plan I am about to make for next week is even possible.

The top of the app is a scoreboard built from Google Tasks. Use List Task Lists to get every list, then List Tasks on each one with showCompleted and showHidden both set to true so tasks that were cleared still count, and bucket tasks into weeks using the completed timestamp on each task. Show how many tasks I completed in the last seven days, the average for the previous four weeks, and the difference between the two so I can see at a glance whether this was a strong week or a thin one. Break this week's completed count down by task list. Also show how many tasks are still open across all lists.

Next to the scoreboard, an aging panel listing every open task whose due date has already passed, ranked by how many days past due it is, with the oldest at the very top. Each row shows the task title, which list it lives on, the due date, and the day count. This is the embarrassment list, so do not truncate it to a top five, let me scroll the whole thing.

Beside that, next week's calendar load from Google Calendar. Use List Events on my primary calendar covering the coming seven days, with singleEvents set to true so recurring meetings expand into real instances, and total the booked hours per day. Render it as a small bar per day with the hour total on it, and visually flag the days that are already heavily booked. All day events carry no hours, so count those separately as a badge on the day rather than folding them into the hour total.

The middle of the app is the review pass itself. It walks me list by list through everything still open, one list at a time, showing each task as a row. On every row I can keep it as is, reschedule it to a new due date with Update Task, mark it done with Update Task setting status to completed, or drop it entirely with Delete Task. Rescheduling should offer quick choices like tomorrow and next Monday plus a date picker, and remember that Google Tasks only stores the date and discards any time portion. Keep a progress indicator pinned at the top showing how many tasks I have handled out of the total and which list I am currently on, and let me leave the app and come back later without losing my place in the pass.

At the end of the review pass there is a Write my weekly review button that kicks off a background agent. The agent takes what I completed this week, what slipped, the aging overdue items and next week's calendar load, then uses Create Document to make a new Google Doc and Batch Update Document to fill it with a narrative review. The review covers what actually got done this week, which open items look genuinely stuck and why the agent thinks they are stuck, and a proposed top five for next week that respects how much uncommitted time my calendar actually leaves me. The agent then files those five as real tasks in a Google Tasks list called Next week, using Create Task List first if that list does not already exist, then Create Task for each priority. When the agent finishes, surface the link to the finished doc in the app.

The app keeps an archive of every review I have ever run. Each entry stores the date, a link to the Google Doc, and that week's headline stats, so I can open the archive and look back across a quarter and see the trend in what I was completing. Show it newest first and let me click through to any past doc.

Two things to get right. Completed tasks that have been cleared from a list become hidden rather than deleted, so every read behind the stats has to pass both showCompleted and showHidden, and has to follow the page tokens, because a single page of tasks tops out at 100. And this app is a review surface, not a logger, so it must never clear completed tasks from my lists. That history is the only thing the scoreboard can be built from.