Building A Personal Time Tracker Dashboard With Notion And Timely

A Notion time-tracking dashboard can be built to automatically summarize where weekly hours go—by combining a Google Sheets back end with filtered charts, then optionally feeding entries from Timely through Zapier. The payoff is a single workspace that turns raw time logs into practical views: total hours over the last seven days, productive hours by project, learning goals, “limit hours” (time spent on activities meant to be reduced), and billable versus non-billable time.

The dashboard’s structure is anchored by a linked objectives database and a set of chart-driven tabs. From the main view, a seven-day hours graph updates as new entries land, and hovering over dates reveals the specific projects tracked and the hours attributed to each. Additional sections break time down in ways that map to common personal management questions: which projects drove productive work, which projects align with learning objectives, how much time went to “limit” categories like Netflix, YouTube, social media, or Twitter, and how billable time compares with non-billable time day by day. The system also supports creating new objectives directly inside the dashboard—such as a learning goal with a weekly target (e.g., “read for five reading hours per week”)—so the reporting stays tied to goals rather than just activity.

To recreate the setup, the workflow starts with a cloneable Google Sheets template. Users copy the sheet, then enter their own data into the “raw input” area, which is designed to feed pivot tables and charts. Manual logging is supported by adding rows with project, date, hours, and a billable flag (or a boolean “true/false” that drives billable versus non-billable classification). Once the data is in place, charts must be embedded into Notion: each chart is published from Google Sheets, the embed link is copied, and Notion uses that link to dynamically refresh charts as the sheet updates (typically after refreshes rather than instantly).

A key implementation detail is that filtered chart views require careful pivot-table configuration. For example, the “learning hours” chart should only include projects tagged as learning objectives (like “reading” or “Coursera”). That same filtering logic must be mirrored for productive hours and other categories, so the right project tags appear in each view. It’s described as fiddly at first, but once the project-tag filters are set, new entries automatically flow into the correct charts.

For automation, Timely acts as the time capture layer. Timely runs in the background and logs active screen time, then users tag items to projects (e.g., “product” or “freelancing submit”) to generate time entries. A pre-built Zapier automation connects Timely to the Google Sheets “raw input” sheet, mapping fields like date and client/project details into the correct columns. A Zap test creates a new spreadsheet row, and the Notion charts update accordingly—turning daily tagging in Timely into an always-current dashboard in Notion. The result is a goal-aware time system that can work either manually or fully automated, depending on how the Google Sheets and Zapier integration are configured.