Dev Blog Publisher

## What & Why As the academy platform grows, the builder wants to share the development journey publicly on a Blogger blog. This tool lets a SuperAdmin select any feature plan (past or upcoming), compose a sanitized blog post from it, and publish it directly to the Blogger blog — all without leaving the admin area. Posts appear on the blog automatically via Blogger's built-in mail-to-blog feature. A post history log tracks everything that's been published.

## Done looks like - A "Dev Blog Publisher" card appears in the Command Center Tools tab, visible only to SuperAdmins - SuperAdmin can choose a source: an existing feature plan file (e.g. "Group Private Lesson Guardian Approval", "Certification Tracker") or a custom free-text entry - The content is automatically sanitized: code blocks are stripped, internal file paths and API routes are hidden, and no personal names or email addresses are included - A live preview shows exactly what will appear on the blog before posting - SuperAdmin can edit the title and body before posting - Clicking "Post to Blog" sends an email via Resend to — the subject is the post title, the body is clean HTML — causing it to publish automatically on Blogger - A "Post History" tab inside the card shows all previously published posts (title, date, source) - Posts are logged in a database table for reference

## Out of scope - Editing or deleting posts already published to Blogger (Blogger does not support that via email) - Scheduling posts for a future time - Pulling posts back from Blogger - Any Blogger API integration — email-only posting is sufficient

## Tasks 1. Schema: blog_posts table — Add a table to the database schema with fields for title, content snapshot, source file name, posted-at timestamp, and the person who posted it. Run db:push.

2. Backend: blog API routes — Add server routes: (list available task files with titles and dates), (load and sanitize one task file for preview — strip code blocks, file paths, API routes, inline code), (sanitize content, send via Resend email to the Blogger address, log to table), (list post history). All routes require SuperAdmin access.

3. Frontend: Dev Blog Publisher tool card — Add a new collapsible tool card to ToolsSection with two tabs: "New Post" (source selector dropdown of task files + custom option, editable title and body, live preview panel, Post to Blog button) and "Post History" (table of past posts with title, date, source). Show a sanitization notice so the admin knows what was stripped before posting.

## Relevant files - - - - -

Canadian Elite Volleyball Academy
elitevolleyball.training

Elite Academy

Thursday, April 9, 2026