I Asked Claude to Build My Content Dashboard. It Updates Itself
What if your AI-built dashboard updated itself every time you opened it? No re-prompting. No copy-pasting. Just open it and the data is already current. 🔄 In this video I show you exactly how to build a live Kanban content pipeline dashboard using Claude Desktop's Live Artifacts feature inside Cowork - connected directly to a Google Sheet. One prompt. A real production board. And it stays fresh automatically. Note: Live Artifacts require a paid Claude plan (Pro, Max, Team, or Enterprise) and Claude Desktop. The free plan does not include this feature. ───────────────────────────────────── 🔥 WHAT YOU WILL LEARN ───────────────────────────────────── ✅ What Live Artifacts are and how they differ from regular static chat artifacts ✅ Why static artifacts break your workflow (and how Live Artifacts fix that) ✅ Requirements: Claude Desktop + paid plan (Pro or higher) ✅ How to set up the Google Drive connector and grant the right permissions ✅ How to prompt Claude (Opus) to generate a Kanban board from a Google Sheet ✅ What goes on each card: title, category, date created, days in stage ✅ How Claude calculates days-in-stage automatically and highlights stuck cards in red ✅ Iterating with two more prompts: category badge bar and a "Next Up" priority callout ✅ How versioning works - every iteration is saved and restorable with one click ✅ Pin and open in live view options explained ✅ Proving live updates: edit the Google Sheet, refresh, watch the board change ✅ How the 14-day red highlight fires automatically on stale cards ───────────────────────────────────── ⏱ CHAPTERS ───────────────────────────────────── 00:00 Intro to Live Artifacts 00:32 Live vs Static Artifacts 01:03 Requirements and Setup 01:28 Create a Live Artifact 02:27 Connect Google Drive Sheet 03:04 Prompt a Kanban Dashboard 05:26 Dashboard Generated Tour 06:32 Iterate with New Prompts 08:18 Versioning and Next Up 08:58 Pin and Open Live View 09:52 Edit Sheet Live Updates 11:27 Highlight Stuck Cards 12:31 Wrap Up and More Connectors 13:14 Final Thanks ───────────────────────────────────── 🔗 RESOURCES ───────────────────────────────────── ↗ Claude Desktop download → https://claude.com/download ↗ Live Artifacts official docs → https://support.claude.com/en/articles/14729249-use-live-artifacts-in-claude-cowork ↗ Get started with Cowork → https://support.claude.com/en/articles/13345190-get-started-with-claude-cowork ↗ Claude pricing (Pro and above) → https://claude.com/pricing ↗ Claude 101 free course → https://anthropic.skilljar.com/claude-101 ───────────────────────────────────── ☕ Buy me a Coffee: https://ko-fi.com/datasciencebasics ✌️Patreon: https://www.patreon.com/datasciencebasics ───────────────────────────────────── 🤝 Connect with me: 📺 Youtube: https://www.youtube.com/@datasciencebasics?sub_confirmation=1 👔 LinkedIn: https://www.linkedin.com/in/sudarshan-koirala/ 🐦 Twitter: https://twitter.com/mesudarshan 🔉Medium: https://medium.com/@sudarshan-koirala 💼 Consulting: https://topmate.io/sudarshan_koirala #claudeai #claudecowork #liveartifacts #claudedesktop #claudeaitutorial #anthropic #googlesheets #kanbanboard #aitools2026 #datasciencebasics