AI/AIZENME
📊 AUTOMATION · Agents & IoT Level: Beginner ⏱ 15 MIN Free & Open Source

Automate Weekly Reviews & Habit Dashboards in Obsidian with AI-Written DataviewJS & Templater

Writing Obsidian Daily Notes every day is great—until Sunday review requires opening 7 files manually. Describe your YAML frontmatter to an LLM to generate custom `DataviewJS` + `Templater` scripts that auto-aggregate weekly tasks, new notes, habit streaks and one-click AI review prompts.

CORE TOOLS Obsidian, Dataview Plugin + Templater Plugin (Open Source), DeepSeek / Claude
BEST FOR Obsidian users, GTD practitioners, freelancers, knowledge workers
REQUIREMENTS Obsidian with free Dataview and Templater community plugins
✦ WHY THIS WORKFLOW

Dataview turns Obsidian into a personal database, but learning its query syntax from scratch takes hours. Letting an LLM write exact `dataviewjs` blocks tailored to your folders gives you an automated weekly dashboard in minutes.

✦ Interactive Workflow Animation Preview

Step-by-Step Action Checklist

0 / 4 Completed
READY-TO-USE PROMPT TEMPLATE
Open Official Tool / Repo ↗
My Obsidian Daily Notes live in `"01-Daily"` named `YYYY-MM-DD.md` with YAML keys `sleep_hours` (number), `exercise` (boolean), `deep_work_hours` (number), and `daily_win` (string).
Write a ready-to-paste **Weekly Review Markdown template using DataviewJS**:
1) Automatically parse the ISO week from the weekly note filename (`YYYY-[W]WW`) to filter the exact Monday–Sunday date range;
2) Render a summary table of each day’s `daily_win`, exercise status (✅/❌), and totals/averages for `deep_work_hours` and `sleep_hours`;
3) List all uncompleted `- [ ]` tasks across those 7 daily notes.
Use Cases & Tags:
Auto-aggregating 7 days of Daily Notes into a single Weekly Review dashboardRendering YAML habit trackers into visual completion tablesBuilding dynamic active-project Kanban tables across foldersConcatenating the week’s fleeting notes for AI reflection#dataviewjs