runbookify
← All plans
Project & Work Management / Task & Milestone Tracking

My Day Personal Task Digest: Stop Hunting the Shared Tracker Every Morning

Turn one shared task sheet into a personalized daily email for each person — what's due today, what's overdue, and what's coming up — with a team lead previewing and approving the batch before it sends.

BeginnerAn afternoonBuilds onNext.jsSupabaseResend
What you'll build

A web tool where you import your task list and people, the app groups tasks by owner and builds a per-person digest (due today, overdue, coming up), a team lead previews and approves or schedules the batch, and personalized emails go out via Resend with a full send log and CSV export.

Gated download

Enter your email — the plan downloads instantly and a copy lands in your inbox.

By submitting your email you'll also receive the weekly runbookify newsletter. You can unsubscribe at any time.

Before you start

  • A Supabase account (free)
  • A Vercel account (free)
  • A Resend account (free)
  • A task list CSV (owner, due date, status, priority)
  • A people / email list
  • Claude Code or any AI coding agent

The problem this kills

Every morning the same ritual: each person opens the shared task tracker, scrolls past everyone else's rows, filters to their own name, squints at due dates, and tries to remember what slipped yesterday. Some people never check it. Some check the wrong tab. The overdue stuff hides in the middle of a 300-row sheet, and the one task that was actually due today gets missed because it looked like all the others.

A shared tracker is great for the team and terrible for the individual. Nobody should have to do data archaeology before their first coffee just to find out what they're supposed to do today. And you don't need a project-management platform — or a developer — to fix it.

What you'll build

A small internal web tool. You import two things: your task list (owner, due date, status, priority) and your people / email list. The tool groups every task by its owner and builds a clean per-person digest — what's due today, what's overdue, and what's coming up — sorted by priority and date. A team lead previews the whole batch in one screen, can fix or skip a person, and then approves or schedules the send. Only then do the personalized emails go out via Resend — each person sees only their own tasks, never anyone else's. You get a complete send log and a CSV export of exactly what each person was sent.

It respects the real-world rules too: each person's time zone, an optional no email on weekends setting, and a dedupe guard so the same person can't be emailed twice for the same day.

What's inside the Implementation Plan

The downloadable plan is a step-by-step file you paste into an AI coding agent. It opens by interviewing you about your business — where your tasks live, exactly what your columns are named, how you track owners and due dates, what counts as "overdue" versus "coming up," your team's time zones and working days, and your messy edge cases (unassigned tasks, shared owners, done-but-not-marked-done) — and then it tailors the data model, the grouping rules, and every later step to your answers. This is not a generic template; the agent reflects a short spec back to you and waits for your thumbs-up before it builds anything. From there it walks the agent through importing tasks and people, the per-person grouping, the digest render, the team-lead preview-and-approve screen, the scheduled send, and the send log — each step with a ready-to-copy prompt. There's also a fallback so you can build the whole thing today even with no API to your task system.

The governance it includes (this is the point)

Even a "simple" daily email touches people's data, so this ships with the controls a team needs: login so only your team can use the tool, row-level security so you only ever see your own organization's tasks and people, a complete audit trail of who previewed, approved, scheduled, and sent which batch and when, a hard human-approval gate so no digest goes out until a team lead signs off (and an admin must approve any change to who's included), and duplicate guards keyed on (person + date) so a slip-up can't blast the same person twice. Critically, the per-person grouping is enforced so a person can never be emailed someone else's tasks.

Who it's for

Team members, team leads, project coordinators, and anyone drowning in a shared task sheet who wants their day handed to them instead of having to dig for it. If you can describe how your team tracks tasks, you can build this.

You've got this — start with the plan, paste the first prompt, answer the interview, and you'll see your first per-person digest take shape the same afternoon.

Gated download

Enter your email — the plan downloads instantly and a copy lands in your inbox.

By submitting your email you'll also receive the weekly runbookify newsletter. You can unsubscribe at any time.