AutomationMart
Home/Browse/Generate AI newsletter drafts from Google Sheets to Notion with GPT-5-mini
n8n

Generate AI newsletter drafts from Google Sheets to Notion with GPT-5-mini

n8nn8n9 modulesv1.0
NotionGoogle SheetsOpenAI

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
Generate AI newsletter drafts from Google Sheets to Notion with GPT-5-mini workflow diagram

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.

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 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

What this does Receives a URL via webhook, uses Firecrawl to scrape the page into clean markdown, and stores it as vector embeddings in Supabase pgvector. A visual, self-hosted ingestion pipeline for RAG knowledge bases. Adding a new source is as simple as sending a URL. The second part of the workflow exposes a chat interface where an AI Agent queries the stored knowledge base to answer questions, with Cohere reranking for better retrieval quality. How it works Part 1: Ingestion Pipeline 1. Web

Free

Create a multi-modal Telegram support bot with GPT-4 and Supabase RAG

What It Does This n8n workflow turns your Telegram bot into a smart, multi-modal AI assistant that accepts text, documents, images, and audio messages, interprets them using OpenAI models, and responds instantly with context-aware answers. It integrates a Supabase vector database to store document embeddings and retrieve relevant information before sending a prompt to OpenAI — enabling a full RAG experience 💡 Why This Workflow? Most support bots can only handle basic text input. This workflow: -

Free

Update a Notion database when Revolut Business draft payments are processed

Every time a Revolut Business draft payment is processed, Make will automatically update a Notion database. The template works with the Notion property (the one that gets updated) named 'Processed', of type Checkbox. The template is supposed to be used as an extension in combination with this [template](https://www.integromat.com/en/integration/6329-add-revolut-business-draft-payments-to-notion).

Free

Generate multiple T-shirt design prompts from images with GPT-4o

Disclaimer This Workflow uses a community node. What It Does Workflow Demonstration This powerful workflow eliminates hours of trial and error when trying to craft the perfect prompt for AI-generated images. By simply saving an image of the design you want to model your generated images after into a designated folder on your desktop, the workflow is automatically triggered. Once the image is saved, n8n pulls it into the workflow, where an Analyze Image AI agent powered by GPT-4o analyzes it and

Free

Create a Taxpayer's Signature Code (PKP) from new Google Sheets rows and post it to Slack

Every time you add a new row to your Google Sheets spreadsheet, Make will automatically generate a Taxpayer's Signature Code (PKP) using the EET module and post it to Slack. The template uses this [example spreadsheet](https://goo.gl/qm1mgb).

Free

Analyze & summarize Amazon product reviews with Decodo, OpenAI and Google Sheets

Disclaimer Please note - This workflow is only available on n8n self-hosted as it’s making use of the community node for the Decodo Web Scraping This n8n workflow automates the process of scraping, analyzing, and summarizing Amazon product reviews using Decodo’s Amazon Scraper, OpenAI GPT-4.1-mini, and Google Sheets for seamless reporting. It turns messy, unstructured customer feedback into actionable product insights — all without manual review reading. Who this is for This workflow is designed

Free

Discover and enrich competitor clients with PredictLeads and Google Sheets

Discover your competitor's clients through PredictLeads connections data, enrich each client with company details, and export everything to Google Sheets. This workflow takes a list of competitor domains from Google Sheets, queries the PredictLeads Connections API to discover their client relationships, enriches each discovered client with company profile data (industry, employee count, location), and writes the results to a structured output sheet for competitive intelligence. How it works: 1.

Free

Extract structured LinkedIn profile data with Airtop & AI parsing

Extracting LinkedIn Profile Information Use Case Manually copying data from LinkedIn profiles is time-consuming and error-prone. This automation helps you extract structured, detailed information from any public LinkedIn profile—enabling fast enrichment, hiring research, or lead scoring. What This Automation Does This automation extracts profile details from a LinkedIn URL using the following input parameters: - airtopprofile: The name of your Airtop Profile connected to LinkedIn. - linkedinurl:

Free

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.

Log in to review
Free
No ratings yet

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.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free