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

This n8n workflow transforms raw newsletter ideas in a Google Sheets tab into fully formatted drafts in Notion using an AI agent powered by OpenAI's GPT-4o-mini model. It starts with a manual trigger, fetches all rows marked 'Pending' from the specified sheet, then iterates through them using Split In Batches to ensure stable processing. For each row, it passes the 'Newsletter Title' and 'About the Newsletter' fields to an AI Agent configured with detailed system instructions for style, sections, and formatting, generating high-quality content.

The workflow then creates a new page in your Notion database, appends the AI-generated draft as blocks, and finally updates the original sheet row's status to 'Done'. This prevents reprocessing and maintains a clean audit trail. Key benefits include massive time savings for content creators—eliminating manual writing, copying, and formatting—while ensuring consistent output quality. It's scalable for batch processing multiple newsletters without overwhelming API limits or memory.

Ideal use cases: Marketing teams drafting weekly AI newsletters, solopreneurs automating content pipelines, agencies managing client updates, or educators generating course summaries. Requires Google Sheets, Notion, and OpenAI credentials; customize sheet ID, Notion database, and model as needed. Highly reliable for production use with error handling implied in the loop structure.