Get AI summaries of any video or article — Sign up free
Obsidian Workflow: Speed up your Weekly Review thumbnail

Obsidian Workflow: Speed up your Weekly Review

Pamela Wang·
6 min read

Based on Pamela Wang's video on YouTube. If you like this content, support the original creators by watching, liking and subscribing to their content.

TL;DR

Automate weekly reviews by rolling up structured daily notes into a weekly note using Dataview tables and Habit Tracker summaries.

Briefing

A weekly review that used to take 2–3 hours can be cut to roughly 30–40 minutes by wiring Obsidian daily notes into an automated weekly note. The core idea is simple but powerful: daily logs already contain the raw material—what happened, how it felt, what was read, what tasks remain, and which habits were checked—then Dataview rollups and the Habit Tracker plugin aggregate that information into a single weekly page. That weekly page then becomes the decision hub for next week, reducing the mental load of remembering everything and planning from scratch.

The system is built around Obsidian’s Periodic Notes plugin, which creates daily and weekly notes in a consistent folder structure. Daily notes are where interstitial journaling happens (timestamped “logs”), along with tags and categories for things like daily checklists and habit-related to-dos. Weekly notes are named with a start date baked in, because the template logic depends on the locale’s week start (Monday vs. Sunday). Periodic Notes uses the first day of the week setting for date ranges, but the template also needs to stay aligned with the correct weekly note; otherwise, clicking between weeks can show mismatched date information.

Templater and Dataview do the heavy lifting for automation. Templater generates weekly notes with the correct date boundaries and pulls in the “Note for next week” section from the previous weekly review. Dataview then filters daily entries to only the current week’s range (Monday–Sunday in the example) and renders tables for items like “memories,” “goals,” and “tasks.” Memories roll up from daily notes tagged with a specific journal memory tag and emoji, with additional safeguards using file creation/modification times so stray or incorrectly linked notes don’t pollute the weekly summary.

Habits are handled in two complementary ways. For mini-habits, the Habit Tracker plugin checks whether specific to-dos were ticked in daily notes and produces counts plus a calendar-style view with annotations (e.g., whether work happened, whether exercise happened). For cross-note tracking, tags provide autocompletion and easier reuse than Dataview inline fields. The weekly template also uses careful formatting tricks—like square-bracket wrapping around Dataview inline fields—to include only the intended portion of a sentence and to simulate line breaks where Dataview otherwise only reads the first line.

The weekly review template itself is organized with metadata (life/work, note type, status, date range, and monthly parent). It follows a Getting Things Done-inspired checklist: task generation (calendar, email, Slack), trigger lists for responsibilities and long-term projects, and a “next weekly review” capture area where items are sorted into must-do, bonus, or miscellaneous. Rollups then summarize what was created or modified during the week, what remains incomplete, and what insights were captured.

By the end, the weekly review page functions as both a retrospective and a planning worksheet—automatically populated from daily notes, while still leaving a structured place to decide what matters next week. The result is less worry about missing something and a workflow that’s fast enough to actually keep up with.

Cornell Notes

The system automates weekly reviews in Obsidian by rolling up structured daily notes into a single weekly page. Periodic Notes creates daily/weekly note files, while Templater generates weekly templates with correct date ranges and carries forward the “Note for next week” section from the prior week. Dataview then filters daily entries to the current week and renders tables for memories, goals, and tasks, using tags plus date-range checks (including file modification/creation safeguards). Habits are tracked either via tags and Dataview-style rollups or more reliably through the Habit Tracker plugin, which detects checked to-dos and produces counts and calendar annotations. The payoff is a weekly review that drops from hours to about 30–40 minutes, reducing planning stress.

How does the workflow prevent weekly date mismatches when weeks are clicked or generated across locales?

Weekly notes are named with the starting date of the week (e.g., the week begins on a specific Monday/Sunday), because Periodic Notes uses the configured first day of the week for date ranges. The template logic depends on “now” and the week boundary; if a user clicks into a different weekly note without the correct date context, the weekly page can show wrong date information. The fix is to rely on Periodic Notes’ “open weekly note” command so the correct weekly note is created/selected for the intended date, rather than manually navigating links that may not align with the template’s date calculations.

What’s the division of labor between Templater, Dataview, and the Habit Tracker plugin?

Templater builds the weekly review note structure with correct dates and pulls forward the “Note for next week” section from the previous weekly review. Dataview performs the rollups: it filters daily notes to the current week’s date range and renders tables for items like memories, goals, and tasks. The Habit Tracker plugin handles habit execution tracking by matching specific to-do text in daily notes and detecting whether the checkbox was ticked; it then summarizes counts and can display a calendar with annotations (e.g., work/exercise status per day).

Why are square brackets used around Dataview inline fields in the rollups?

Square brackets are used to capture only a specific part of an inline Dataview field (rather than the entire sentence). This matters when the daily log contains multiple clauses but only one clause should roll up into a particular weekly table (e.g., “work log” should include “finished code for simulator,” while another clause like “found my USB” should not). The brackets also help with formatting: they allow rendering that behaves like line breaks (using a `br` command) even though Dataview inline attributes don’t naturally support multi-line content—otherwise only the first line may be read and rolled up.

How do the weekly rollups ensure they only include the right daily notes for the week?

Rollups rely on multiple constraints: daily notes must be tagged with the relevant key (e.g., the memories tag plus emoji), and the daily notes must link to the correct weekly note so the date range aligns. Additional filters check that the daily note’s file modification time falls within the week window (and that it was created before the next day boundary). This reduces contamination from notes that might be incorrectly tagged or linked to the weekly note.

What’s the role of tags versus Dataview inline fields for tracking across many notes?

Tags are favored for cross-note tracking because they offer autocompletion in Obsidian, while Dataview inline fields don’t provide the same convenience. The workflow still uses Dataview rollups for structured aggregation, but tags make it easier to consistently apply and reuse tracking markers (for example, using a dedicated weekly-review tag to later find and remove items already processed).

How does the weekly checklist connect to the rollups for tasks and planning?

The weekly review template includes GTD-inspired sections like task generation (calendar, email, Slack), trigger lists, and long-term tasks. During the week, daily notes capture tasks and logs; incomplete tasks are then rolled up into “tasks this week” based on tasks created/modified within the weekly date range. Checklist headings are formatted so they don’t get counted as incomplete tasks by the rollup logic, preventing the weekly page’s own checklist text from polluting the task summary.

Review Questions

  1. What specific mechanisms in the system keep weekly date ranges aligned with the correct Periodic Notes week boundaries?
  2. How do the rollups for memories differ from the habit tracking summaries in terms of data source and matching logic?
  3. Where do square brackets and `br` fit into the Dataview rollup pipeline, and what problem do they solve?

Key Points

  1. 1

    Automate weekly reviews by rolling up structured daily notes into a weekly note using Dataview tables and Habit Tracker summaries.

  2. 2

    Use Periodic Notes for consistent daily/weekly file creation, and open weekly notes via the plugin command to avoid date-context bugs.

  3. 3

    Name weekly notes with the week’s starting date so template logic stays aligned with locale week boundaries (Monday vs. Sunday).

  4. 4

    Use Templater to generate weekly templates with correct date ranges and to carry forward the “Note for next week” section from the prior weekly review.

  5. 5

    For rollups, combine tags/emojis with date-range filtering and file creation/modification safeguards to prevent stray notes from appearing.

  6. 6

    Track habits with the Habit Tracker plugin when possible, since it detects checked to-dos in daily notes and can render counts and calendar annotations.

  7. 7

    Format Dataview inline rollups carefully (e.g., square brackets and `br`) to capture only the intended clause and to achieve multi-line-looking output where Dataview otherwise only reads the first line.

Highlights

Weekly review time drops from 2–3 hours to about 30–40 minutes by aggregating daily logs into an automated weekly note.
Weekly notes include the week start date to avoid mismatches caused by locale differences in week boundaries.
Square brackets around Dataview inline fields let the system capture only the intended part of a sentence and support `br`-based line rendering.
Habit Tracker plugin summaries come from checkbox state in daily notes, producing both counts and calendar annotations.
The weekly template is structured with metadata and GTD-inspired sections, while rollups summarize memories, goals, and incomplete tasks for the week.

Topics

Mentioned