Notion for Novel Planning: Building a Story Database That Works

Notion is a database-driven workspace that’s become wildly popular for project management, note-taking, and knowledge organization. Writers have adapted it for novel planning, and the results are powerful—if you know how to set it up.

The key insight: a novel isn’t one document. It’s a collection of interconnected elements—characters, settings, scenes, plot threads, research, timeline events—and Notion’s relational databases make those connections visible and navigable.

Here’s how to build a novel planning workspace in Notion that actually helps you write.

The Core Databases

Notion’s power comes from databases: tables of information where each row is an entry and each column is a property. Databases can link to each other, creating relationships. For a novel, you need four to six core databases.

Characters Database

Each row is a character. Properties:

Name (title)
Role (select: protagonist, antagonist, supporting, minor)
First appearance (relation: linked to Scenes database)
Arc summary (text: one-paragraph description of their journey)
Wants (text: what they’re pursuing)
Fears (text: what they’re avoiding)
Relationships (relation: linked to other Characters)
Status (select: fully developed, needs work, placeholder)

Each character entry opens to a full page where you can write detailed backstory, physical descriptions, voice notes, and anything else you need. The database view gives you the overview; the page view gives you the depth.

Scenes Database

Each row is a scene. Properties:

Scene name (title)
Chapter (select or relation)
POV character (relation: linked to Characters)
Characters present (relation: linked to Characters)
Setting (relation: linked to Settings)
Timeline position (date or number)
Status (select: outlined, drafted, revised, final)
Word count (number)
Plot threads (relation: linked to Plot Threads)
Scene purpose (text: what this scene accomplishes)

This database becomes your scene list, your revision tracker, and your structural overview all at once. Filter by status to see what’s drafted. Sort by timeline to check chronological flow. Filter by character to trace their journey through the novel.

Settings Database

Each row is a location. Properties:

Name (title)
Description (text)
Sensory details (text: what it looks, sounds, smells like)
Scenes set here (relation: linked to Scenes)
Associated characters (relation: linked to Characters)

Plot Threads Database

Each row is a subplot or thematic thread. Properties:

Thread name (title)
Description (text)
Scenes involved (relation: linked to Scenes)
Status (select: active, resolved, dropped)
Resolution (text)

This database makes it impossible to drop a subplot by accident. If a plot thread’s “Scenes involved” list stops midway through the book, you can see the gap immediately.

Research Database

Each row is a research item. Properties:

Topic (title)
Source (URL or text)
Key facts (text)
Related scenes (relation: linked to Scenes)
Verified (checkbox)

Organizing research by its connection to specific scenes ensures your research serves the story rather than sitting in a disconnected pile. For broader research strategies, see [INTERNAL: research-methods-for-writers].

Setting Up Views

Each database can be viewed in multiple ways. This is where Notion becomes genuinely useful for writing:

Board view for Scenes — group by Status (outlined, drafted, revised, final). Each scene is a card you can drag between columns as it progresses. A visual Kanban board for your novel.

Calendar view for Timeline — if your novel unfolds over specific dates, a calendar view shows scene distribution across time. Gaps become obvious. Clusters become obvious.

Table view for Characters — all characters at a glance, sortable by role, development status, or first appearance. Filter to show only characters who appear in Act 2.

Gallery view for Settings — if you add images to your setting entries (photos, maps, mood board images), gallery view displays them as visual cards. A visual tour of your novel’s world.

The Dashboard

Create a main dashboard page that aggregates your databases into a single view:

A filtered view of scenes currently in progress (status = drafted)
A count of total words written (using a formula property or manual tally)
A list of characters who need development (status = needs work)
Open plot threads (status = active)
Upcoming research tasks (verified = unchecked)

This dashboard becomes your novel command center. Open it at the start of each writing session to see where things stand and decide what to work on.

Templates Within Databases

Notion lets you create templates for database entries. Set up:

A Scene template with pre-filled sections: Scene Purpose, Draft, Revision Notes. When you create a new scene, the structure is already there.

A Character template with sections for Appearance, Backstory, Voice Notes, Relationships, and Arc. Consistent structure across characters makes comparison and development easier.

The Workflow

A typical writing session using Notion for planning:

Open the dashboard. Check which scenes are outlined but not drafted.
Choose a scene. Open it. Review the synopsis and purpose.
Check linked characters and settings for relevant details.
Write the scene (in Notion, or in your preferred writing app—see below).
Update the scene’s status to “drafted” and enter the word count.
Note any new characters, settings, or plot threads that emerged during drafting and add them to the appropriate databases.

Notion for Planning, Not for Writing

Important caveat: Notion is excellent for planning but mediocre for writing. The editor is functional but lacks the focus and typography of dedicated writing apps. It doesn’t have distraction-free mode, Markdown rendering is limited, and the performance with very long documents can lag.

My recommendation: use Notion for planning and tracking, and a dedicated writing app for actual prose. Scrivener (see [INTERNAL: scrivener-deep-dive]), Ulysses, or iA Writer (see [INTERNAL: ulysses-vs-ia-writer]) for the writing. Link your Notion scene entries to files in your writing app by pasting file paths or using a consistent naming convention.

This split — Notion for the brain, Scrivener for the hands — uses each tool’s strengths without forcing either into a role it is not designed for.

Templates and Starting Points

If building databases from scratch feels overwhelming, the Notion community has shared hundreds of novel planning templates. Search the Notion Template Gallery for “novel planning” or “novel writing” and you’ll find ready-made workspaces you can duplicate and customize.

Start with someone else’s template, use it for a few weeks, then modify it to match your process. No template will perfectly match your workflow on day one—customization is expected and encouraged.

The Real Value

The value of Notion for novel planning isn’t the database features themselves—it’s the connections between them. When you click a character and see every scene they appear in, every setting they’ve visited, and every plot thread they’re involved in, you understand your novel’s architecture in a way that no outline document or spreadsheet can provide.

That understanding makes drafting easier, revision more targeted, and the inevitable complexity of a novel manageable rather than overwhelming. You still have to write the words. But you’ll always know where those words fit in the larger story.