Get Started
Back to Templates

Generate AI Newsletter Drafts from Google Sheets to Notion with GPT-5-mini

Created by

Created by: Snehasish Konger || snehasish

Snehasish Konger

Last update

Last update 14 days ago

Categories

Share

How it works:

This template turns rows in a Google Sheet into polished newsletter drafts in Notion using an AI writing agent. You click Execute workflow in n8n. It fetches all rows marked N8n Status = Pending, generates a draft from Newsletter Title and About the Newsletter, creates a Notion page, writes the full draft, then flips the sheet row to Done before moving to the next one.

Before you start (use your own credentials):

  • Create and select your credentials in n8n:

    • Google Sheets (OAuth2 or Service Account) with access to the target spreadsheet.
    • Notion (Internal Integration) with access to the target database.
    • OpenAI (API Key) for the Chat Model.

  • Replace any placeholders in nodes:

    • Spreadsheet ID/URL and sheet/tab name (e.g., newsletter).
    • Notion Database ID / Parent and any page or block IDs used by HTTP Request nodes.
    • OpenAI model name if you prefer a different model.

  • Give the Notion integration access to the database (Share → Invite the integration).

  • Do not hard-code secrets in nodes. Store them in n8n Credentials.

Step-by-step:

  1. Manual Trigger
    Start the run with When clicking ‘Execute workflow’.

  2. Fetch pending input (Google Sheets → Get row(s) in sheet)
    Read the newsletter tab and pull only rows where N8n Status = Pending.

  3. Iterate (Split In Batches → Loop Over Items)
    Process one sheet row at a time for stable memory use and pacing.

  4. Generate the newsletter (AI Agent + OpenAI Chat Model)

    • AI Agent loads the “System Role Instructions” that define style, sections, and format.
    • Pass Newsletter Title and About the Newsletter to the OpenAI Chat Model to produce the draft.

  5. Create a Notion page (Notion → Create Page)
    Create a page in your Newsletter Automation database with the page title set from Newsletter Title.

  6. Prepare long content for Notion (Code)
    Split the AI output into ~1,800-character chunks and wrap as Notion paragraph blocks to avoid payload limits.

  7. Write content blocks to Notion (HTTP Request → UpdateNotionBlock)
    Send a PATCH request to append all generated blocks so the full draft appears on the page.

  8. Mark the sheet row as done (Google Sheets → Update row in sheet)
    Update N8n Status = Done for the processed Newsletter Title.

  9. Continue the loop
    Return to Split In Batches for the next pending row until none remain.

Tools integration:

  • Google Sheets — input queue and status tracking (Pending → Done)
  • OpenAI — LLM that writes the draft from provided fields
  • Notion — destination database for each draft page
  • n8n Code + HTTP Request — chunking and Notion API block updates

Want auto-runs? Add a Cron trigger before step 2 and keep the flow unchanged.