Inside My Plotting Process: Spreadsheets, Beat Sheets, and Making Peace With Being a Slow Writer

First things first: I am a slow writer. I have made my peace with this the way you make peace with a persistent houseguest who stays long past their welcome — grudging acceptance, the occasional deep sigh, and resigning to set an extra place at the table.

I have read the productivity books. I have seen the authors who draft 5,000 words a day before breakfast and then, presumably, go run a marathon and house train a dozen puppies. That is not me. I am the slow and steady turtle. I have made my peace with the turtle. Most days.

But I have figured out, gradually, over three novels and an embarrassing number of scrapped outlines, that being slow isn't the same as being directionless. I've found the opposite. As slow as my speed may be, structure helps to keep me steady. So today let's walk through the mechanics of how I plot a book, beat sheets and spreadsheets and all, because I think the "just write and see what happens" advice works beautifully for some writers and would leave me, personally, sitting halfway through a draft and wondering where the plot went and why my hero has three different jobs within five chapters.

The beat sheets: Save the Cat and Romancing the Beat

I lean on two structure books, and I lean on them a lot -- Save the Cat Writes a Novel by Jessica Brody, and Romancing the Beat by Gwen Hayes.

Save the Cat gives me the skeleton — the beats that show up, in some form, in every story that actually works. The opening image. The catalyst. The midpoint. The dark night of the soul, which is exactly as dramatic as it sounds and also exactly what we readers need. The structure was built for screenwriting originally and then adapted for novels. 

Romancing the Beat does the same job, but it's built specifically for romance, which means it does something Save the Cat doesn't -- it tracks two people's emotional arcs at once, plus the arc of the relationship itself, which is really its own third character with its own needs and growth curve. Because here's the thing about romance that a general story-structure book can't fully account for — the plot isn't just, "Does the goal get accomplished?" The plot is also, "Do these two people trust each other yet, and if not, why not, and what would it take?"

I use both books together, which probably sounds like overkill, and is possibly overkill. But Save the Cat keeps the overall story honest. Romancing the Beat keeps the relationship honest. I need both, because a romance novel with a great external plot and a flat relationship arc is not a romance novel but just a plot with two people standing near each other. And a romance novel with a great relationship arc and no external plot tends to drift, because readers need something to actually be happening while these two people fall in love.

Where the spreadsheet comes in

Here's where I get, admittedly, a little intense. I map out my scenes in Excel.

Not just a list of "what happens" but multiple columns, side by side, scene by scene, going through the physical action and the emotional beats. What's happening on the surface (the plot mechanics, the misunderstandings, the cat causing chaos) sits right next to what's happening underneath it, emotionally, for each character in each scene.

I do this because I believe romance readers are reading for the emotional beats every bit as much as they're reading for the plot. Nobody's up until 2 a.m. because they desperately need to know whether the 1950s dating experiment is a success. They're up until 2 a.m. because the heroine just realized something about her best friend, something that she's been missing for the whole book, and the hero is standing right there when she realizes it, and the reader needs to see what happens next.

If I only track the physical action, I can build a functional plot that goes nowhere emotionally. If I only track the emotional beats, I end up with an internal journey and no actual scenes for it to happen in. The spreadsheet forces each scene to earn its place so that by the time I sit down to draft, I already know not just what's happening, but what it's supposed to cost.

It's not glamorous. Nobody's making a cottagecore aesthetic video of "day in the life of an author, featuring: Google Spreadsheets." But it works, and honestly, there's something almost soothing about reducing a whole messy, feelings-driven story down to rows and columns I can actually look at.

Structured enough to trust it, loose enough to survive characters with minds of their own

Here's the tension I'm always managing, though: I want enough structure that I trust I'm hitting the right beats at the right time — that the midpoint actually functions like a midpoint, that the dark night of the soul actually earns its darkness instead of showing up because the outline said it should. But I don't want so much structure that the outline becomes a cage.

Because characters do not respect outlines. I'll build this careful, beat-mapped plan, and then somewhere around chapter four, a character will show up different than planned. Quieter than I expected, or funnier, or carrying some wound I hadn't planned for that suddenly explains three other things about them that I also hadn't planned for. And if my structure is too rigid, that means scrapping the outline, or worse, forcing the character back into the shape I originally designed for them, which never works. Readers can feel it when a character is being forced into someone else's plan instead of making their own choices.

So the goal — and I don't always hit it, but it's the goal — is structure loose enough to bend. I treat the beat sheet less like a set of orders and more like a set of checkpoints. I know roughly where the midpoint needs to land and roughly what it needs to accomplish emotionally, but I stay open to the actual route getting there, which often looks different than I planned, because the character who showed up is, more often than not, more interesting than the one I designed on paper. The spreadsheet can flex. The emotional column can adjust. What doesn't change is the underlying shape, because that shape is doing real work.

Why draft one is for meeting the characters, not finishing the story

Despite my best efforts, my first draft is not where I get the story right. My first draft is where I get to know the characters well enough to get the story right in the second draft.

I used to fight this. I used to sit down for draft one convinced that if I'd just outlined hard enough, beat-sheeted thoroughly enough, spreadsheeted intensely enough, I could skip the "getting to know you" phase entirely and go straight to a polished plot.

It has never once worked that way.

Draft one is always, no matter how prepared I am, the draft where I find out who these people actually are once they're moving and talking and making decisions instead of sitting quietly in a spreadsheet cell. It's the draft where I discover a character's real sense of humor, which is never quite the sense of humor I assigned them on paper. It's the draft where a supporting character demands more page time than I budgeted for because they're funnier than I gave them credit for.

Draft two is where all of that gets solidified. By the time I sit down for revisions, I actually know these people. I know how the hero actually talks when he's nervous versus when he's hurt, which, it turns out, are not the same voice at all, even though I originally wrote them that way. I know what the heroine's real emotional arc turned out to be, which is usually adjacent to what I planned but rarely identical. Draft two is where the beat sheet and the character who showed up finally get reconciled — where I go back through my careful physical-action-and-emotional-beat columns and adjust them to match the story that's actually been written, instead of the one I originally mapped.

The whole messy, ongoing point