YouTube Planner — Ideas, Status & Schedule
Role: UX & Front-End · Growing Back-End • Stack: HTML, CSS, JavaScript, Supabase (Auth + Postgres)
Problem
Managing YouTube across multiple channels is chaotic: ideas scattered in notes, no clear status tracking, and publish dates forgotten. I designed this planner to centralise ideas, track progress visually, and give creators a calm overview of what’s due next.
Goals
- 🎬 Capture video ideas quickly with title, description, and channel.
- 📊 Track status from Idea → Draft → Filming → Editing → Scheduled → Published.
- 📅 See upcoming videos by due date (Today, This Week, Later).
- 🔒 Keep data private with authentication and row-level security.
- 📱 Responsive design: usable on desktop and mobile.
6
Statuses tracked
∞
Ideas per channel
100%
User data isolation
UX Highlights
- Board view: Kanban columns for each status.
- Schedule view: grouped list of Today / This Week / Later.
- Quick capture: inline form at the top; one field + dropdowns.
- Channel filter: see all ideas or just one channel.
- Accessible actions: each card has simple Edit / Delete / Advance buttons.
Architecture (MVP)
The MVP runs as a static app on Netlify, with Supabase handling authentication, storage, and row-level security. Each idea belongs to a user and an optional channel.
| Layer | Tech | Notes |
|---|---|---|
| Front-end | HTML, CSS, JavaScript | Board & schedule UI |
| Auth | Supabase Auth | Email/password (MVP) |
| DB | Supabase Postgres | Tables: channels, ideas |
| Hosting | Netlify | Deploy from GitHub |
Database Schema (simplified)
| Table | Main fields |
|---|---|
channels | id, user_id, name, platform |
ideas | id, user_id, channel_id, title, description, status, due_date |
Challenges & Fixes
- Scope creep: kept MVP to ideas + statuses + due dates. Drag-and-drop & calendar grid saved for later.
- Data privacy: Row Level Security ensures only the owner can access their channels/ideas.
- Mobile layout: reduced 6-column board to 2-column grid on smaller screens.
Result
The MVP delivers a working planner: creators can log in, add ideas, track them across statuses, and check upcoming deadlines. It demonstrates full-stack skills: authentication, CRUD, filters, and responsive UI.
Screens
Future Improvements
- Drag-and-drop between columns with auto-save.
- Calendar grid with weekly/monthly views.
- Templates for recurring video types (e.g., Reviews, Tutorials).
- Supabase Storage: attach thumbnails or briefs.
- Collaboration: invite an editor with restricted access.
- YouTube API integration to auto-detect published status.
Links
Live Demo GitHub Repo Download CV
Built by Antonella Akromah · a@gmail.com