The Novelist's Stack

Most novels don’t die from bad writing. They die from scattered notes — a character sheet in one document, a timeline in another, plot ideas in your phone, and no idea what you fixed in draft two.

The cure is boring and unglamorous: one place for everything. Here’s the four-database system I use in Notion, and why each piece earns its spot.

1. A chapter planner that forces every scene to justify itself

One row per chapter or scene, with a Purpose field: what must this scene accomplish? If you can’t answer, that scene is a candidate for the cut. Add the story beat it serves (I use the 15-beat structure — explained here), the POV character, and a word target. Suddenly “write the novel” becomes a list of small, known jobs.

2. A story bible with two fields that do all the work

Characters, locations, items, factions — fine. But the fields that matter are Wants and Needs. What your character wants drives the plot; what they actually need drives the arc; the gap between them is the book. If Wants and Needs are identical, you have a flat character and now you know it in chapter one instead of draft three.

3. A word tracker that tracks mood, not just count

Words and minutes per session, yes — but also how it felt (flowing, steady, grinding, blocked) and one note: where did you stop? Leaving yourself a re-entry hook is the cheapest productivity trick in writing. Tomorrow-you opens the tracker and knows exactly which sentence comes next.

4. A revision board, because “the draft is broken” isn’t actionable

After the first draft, every problem becomes a card: what’s broken, how badly (book-breaking → polish), what kind (plot hole, pacing, character…), and which chapters it touches. Then you work the board left to right — Triage, Diagnosed, Fixing, Fixed. Revision stops being a fog and becomes a queue.

Build it yourself — or duplicate mine

You can build all four databases in an afternoon on Notion’s free plan. Or you can duplicate the one I’ve already built, with the 15-beat structure, all the fields above and worked examples included: The Author Dashboard — one-click duplicate, yours forever.

Not sure yet? Grab the free revision prompts first and see if my approach fits how you work.