Automate newsletter creation & client delivery with GPT-4O, Google Sheets

by Amit Mehta ✓ · 11,118 views · created 2025-07-05 · Social Media, Multimodal AI

What this workflow does

This AI workflow has 15 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Google Sheets, OpenAI, Google Drive and Gmail.

How it runs

Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).

1. Get topic from newsletter sheet (Google Sheets): uses Google Sheets
2. Pick records to send email to client (Google Sheets): uses Google Sheets
3. Validate Status as Pending (If): checks a condition and branches into true / false
4. Validate Status as Approved (If): checks a condition and branches into true / false
5. Create HTML for Newsletter (OpenAI): uses OpenAI
6. Get Client email address (Google Sheets): uses Google Sheets
7. Prepare Data to create word doc (Code): runs custom JavaScript code
8. Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
9. Upload doc to google drive (Google Drive): uses Google Drive
10. Update status as Sent (Google Sheets): update

…plus 3 more steps. See the full node list below.

Services it uses

Google SheetsOpenAIGoogle DriveGmail

Before you upgrade to n8n 3.0

Nodes used (9)

• Manual Triggern8n-nodes-base.manualTrigger
• Schedule Triggern8n-nodes-base.scheduleTrigger
• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
• Google Sheetsn8n-nodes-base.googleSheets
• Ifn8n-nodes-base.if
• OpenAI@n8n/n8n-nodes-langchain.openAi
• Coden8n-nodes-base.code
• Google Driven8n-nodes-base.googleDrive
• Gmailn8n-nodes-base.gmail

From the author

How it Works This workflow automates the complete newsletter management process from content creation to client delivery, using Google Sheets, AI content generation, Google Drive, and Gmail. Whether you're a content creator, marketing agency, or small…

View the original on n8n.io → Check your own copy