Asian Drama Tracker - Google Sheets

Ever scroll through Netflix, spot Business Proposal in your continue-watching row, and have absolutely no idea which episode you left off on? You know you watched it last Tuesday — or was it Wednesday — and somewhere between that cliffhanger and the three new K-Dramas people keep recommending, your watchlist turned into a mess of half-remembered details. This Asian drama tracker for Google Sheets gives every scattered piece of your viewing life a proper home across eight organized tabs.

The first frustration is never knowing what you have already watched or where you stopped. The Shows tab solves that by letting you log each drama with its country, genre, sub-genre, year, number of seasons and episodes, streaming platform, and watch status. You add a show photo and rate each series across five categories — Overall, Story, Acting, Production, and OST — so every Crash Landing on You rewatch and every new C-Drama discovery gets a proper record. When you want even more detail, the Episodes tab tracks individual episodes by number, title, and photo, with a per-episode rating so you can mark exactly which installment left you staring at the ceiling.

Then there is the problem of forgetting which actor played which role in which show. The Actors tab keeps photos, birthplace, gender, birth date, current age, and an interest level for each performer, and every entry links back to the drama you know them from. You spot a familiar face in Hidden Love and trace them straight back to whatever show made you notice them in the first place. The Critic Ratings tab tackles another common headache — figuring out whether a drama is actually worth starting. You log the review source, date, rating, percentage score, rating type, and a direct URL to the original review. Averaged ratings across shows help you compare before committing sixteen episodes of your weekend.

Watching without a log means the details blur together after a few days. The Journal tab records each session with the date, show, platform, minutes watched, episodes covered, and space for notes. Summary stats at the top surface your weekly best viewing time and episode count, and a line chart tracks your progress over the past week. The Dashboard pulls everything into one view — totals for shows tracked, shows completed, episodes tracked, total time spent watching, actors tracked, shows currently watching, and critic ratings logged. Bar charts rank your top-rated shows alongside critic favorites, a pie chart breaks down which shows have critic ratings, and a status chart shows your overall watching progress.

The whole tracker runs in Google Sheets with nothing to install and no subscription to manage. It is yours to keep and customize. The purchase also includes Excel and Notion versions of the same tracker if you prefer a different platform.