Generate AI newsletter drafts from Google Sheets to Notion with GPT-5-mini
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
At a glance
Generate AI newsletter drafts from Google Sheets to Notion with GPT-5-mini is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Notion, Google Sheets, OpenAI. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Notion, Google Sheets, OpenAI
- Modules
- 9
- Price
- Free
- Version
- v1.0

About this workflow
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.
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Scrape and ingest web content into Supabase pgvector with Firecrawl
Create a multi-modal Telegram support bot with GPT-4 and Supabase RAG
Update a Notion database when Revolut Business draft payments are processed
Generate multiple T-shirt design prompts from images with GPT-4o
Create a Taxpayer's Signature Code (PKP) from new Google Sheets rows and post it to Slack
Analyze & summarize Amazon product reviews with Decodo, OpenAI and Google Sheets
Discover and enrich competitor clients with PredictLeads and Google Sheets
Extract structured LinkedIn profile data with Airtop & AI parsing
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you