Generate and send AI newsletters with OpenAI, Tavily, Google Sheets and Gmail

Description

📨 AI Newsletter Automation Workflow

🚀 Brief Overview (How It Works)

This workflow automates the complete process of generating and sending AI-powered newsletters. It starts with a form submission where the user provides a brand name, website, and topic query. The system then fetches relevant news, analyzes the brand’s visual identity (colors & logo), and uses AI to generate structured newsletter topics and content. Finally, it converts everything into a beautifully styled HTML email, saves it to Google Sheets, and sends it to all subscribers via Gmail.

Quick Setup Guide
👉 Demo & Setup Video
👉 Sheet Template
👉 Course

🔑 Nodes of Interest

On Form Submission (Trigger)**
Entry point for brand details and query input

HTTP Request (Tavily API)**
Fetches latest news based on the query

Generate Draft Topics (AI)**
Creates newsletter title + 3 key topics using LLM

Split Topics**
Breaks topics into individual items for processing

Generate Newsletter Content (AI)**
Writes detailed content for each topic with sources

Merge Content Pieces**
Combines all sections into one dataset

AI Agent (Brand Analyzer)**
Extracts brand colors from website HTML

Information Extractor**
Extracts logo URL from brand website

Convert Newsletter to HTML (AI)**
Formats content into styled email HTML using brand theme

Google Sheets**
Saves generated newsletter drafts

Gmail Node**
Sends newsletter to all subscribers

🔐 What You’ll Need (Credentials)

OpenAI API Key**
Used for all AI content generation (GPT-4.1-mini)

Tavily API Key**
For fetching real-time news data

Google Sheets OAuth**
To store newsletter drafts & manage subscribers

Gmail OAuth**
To send emails to subscribers

⚙️ Recommended Settings & Best Practices

Use structured output parsers to ensure consistent AI responses
Keep topic count fixed (3) for predictable flow
Limit newsletter length to ≤ 1000 words for readability
Use Split + Aggregate pattern for scalable content generation
Maintain strict prompt engineering (system messages already optimized)
Always validate real URLs for citations (avoid hallucinations)
Use Loop Over Items for controlled email sending
Store drafts before sending (fail-safe logging)

🎯 Customization Ideas

Add weekly automation trigger (Cron node) instead of manual form
Integrate Notion / Airtable instead of Google Sheets
Add unsubscribe & email tracking (SendGrid / Mailchimp)
Personalize emails using user segmentation (AI-based)
Add multi-language newsletter generation
Include image generation (DALL·E / Stable Diffusion) for visuals
Connect to Telegram / WhatsApp bot for distribution
Add analytics dashboard for open/click rates

🏷️ Tags

AI Automation, n8n Workflow, Newsletter Automation, Email Marketing, GPT Integration, LangChain, Tavily API, No-Code AI, Content Generation, Marketing Automation, GenAI Workflow, AI Agents