How to Automate Your Newsletter From Notion to Beehiiv (No Code)

The biggest friction point with newsletters isn't writing — it's the formatting, the platform switching, and the mental overhead of going from "idea" to "ready to send." This workflow removes all of that.

Here's exactly how it works and how to set it up.

The Setup Overview

• Notion — where you write rough drafts and manage the queue
• n8n — the automation layer that watches Notion and triggers the pipeline
• Claude API — polishes the draft, adds structure, suggests a subject line
• Beehiiv API — receives the finished draft as a new post

No code required beyond setting up the n8n workflow (which is drag-and-drop).

Step 1 — Set Up Your Notion Newsletter Database

Create a Notion database called "Newsletter Queue" with these properties:

• Title — the topic or working title
• Status — Draft / Ready / Sent
• Issue Number — number field
• Send Date — date field
• Notes — any rough bullet points or ideas

When you want to write an issue, create a new page in this database. Write your rough notes in the page body — bullet points, fragments, half-formed ideas. Doesn't matter. Claude will handle the polish.

When you're ready to process it, change Status to "Ready".

Step 2 — Build the n8n Workflow

The workflow has 4 nodes:

Node 1 — Schedule trigger. Runs every morning at 8am. Checks for Notion pages with Status = "Ready".

Node 2 — Notion query. Fetches all pages in the Newsletter Queue database where Status = "Ready". Grabs the page content (your rough notes).

Node 3 — Claude polish. Sends the rough notes with this prompt:

"You are a newsletter editor. Take these rough notes and turn them into a polished newsletter issue. Format: 1) Subject line (curiosity-driven, no clickbait), 2) Preview text (one sentence), 3) Newsletter body (conversational tone, 300–500 words, no fluff, one clear insight or story, ends with a question or soft CTA). The newsletter is about AI tools and automation. The reader is a creator or entrepreneur. Do not sell anything."

Node 4 — Beehiiv API post. Takes the Claude output and creates a new draft post in Beehiiv via their API. Sets the subject line, preview text, and body. Status is set to "draft" so you review before sending.

After Node 4 runs, n8n updates the Notion page Status to "Sent" so it doesn't get picked up again.

Step 3 — Connect Beehiiv API

In Beehiiv, go to Settings → Integrations → API. Generate an API key. In n8n, add an HTTP Request node with:

• Method: POST
• URL: https://api.beehiiv.com/v2/publications/[your-pub-id]/posts
• Auth: Bearer token (your API key)
• Body: JSON with subject, preview_text, content fields from the Claude output

The Result

Your workflow:

1. Jot rough notes in Notion (5 minutes)
2. Set status to "Ready"
3. Next morning, find a polished draft waiting in Beehiiv
4. Review, tweak if needed, hit send

Total active time per issue: ~10 minutes. The automation handles everything else.

Adding Affiliate Links

The cleanest approach: keep a "Tools I Use" section at the bottom of every issue. These are static affiliate links you add once in Beehiiv as a reusable content block. They appear in every issue automatically without touching the automation.

For in-body affiliate mentions, add a line to the Claude prompt: "If any AI tools are mentioned, note them as candidates for affiliate linking." Then manually add the links during your review step. Don't automate affiliate link insertion — keep that human.

Beehiiv Boosts (Bonus Revenue)

Even with a small list, enable Beehiiv Boosts in your monetization settings. You get paid when your subscribers sign up for partner newsletters. With 500 subscribers and a good niche audience, this can generate $50–200/month passively — before you have a single product to sell.

---

Want this workflow built for you? The AI Automation Setup service includes newsletter pipeline builds. Get in touch.