Free Newsletter Issue Planner Spreadsheet
Outline issues, CTAs, and send metrics so your newsletter stays consistent.
What this is
Outline subjects, CTAs, and sections before you write, then log open/click rates after send. Consistency beats perfection for newsletters.
Best for
- Weekly or biweekly newsletter writers
- Creators tying issues to product launches
- Teams sharing an editorial calendar
What’s included
- Send date, subject, primary CTA, sections, status
- Open % and click % fields
Preview
| Send date | Subject line | Primary CTA | Sections | Status | Open % | Click % |
|---|---|---|---|---|---|---|
| 2026-08-11 | One template that saved my week | Download pack | Story; Tip; Link | Sent | 48 | 6.1 |
| 2026-08-18 | Media kit mistakes | Grab the kit | Story; Checklist | Draft |
How to use
- Plan 4 issues ahead so you’re never writing on send day.
- One primary CTA per issue.
- Log open/click rates to refine subject lines.
Tips
- One primary CTA per issue — secondary links go below the fold.
- Draft subject lines in the sheet before the body exists.
- Review the last 4 open rates before changing cadence.
FAQ
Where do I get open rates?
From your ESP (Beehiiv, Mailchimp, ConvertKit, etc.). Paste trailing campaign stats after each send.