Templates / Automated email marketing campaign workflow

Automated email marketing campaign workflow

Ready for 3.0

by Badr ✓ · 6,880 views · created 2024-10-06 · Social Media, Multimodal AI

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This AI workflow has 10 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets and OpenAI.

How it runs

Trigger: Manually, when you click “Execute workflow”.

  1. Fetch Recipient Data (Google Sheets): uses Google Sheets
  2. Validate Email Addresses (If): checks a condition and branches into true / false
  3. Process Recipients (Loop Over Items (Split in Batches)): loops over the items in batches
  4. Create Personalized Email (OpenAI): uses OpenAI
  5. Send Email: sends an email over SMTP
  6. Set Status to "Sent" (Edit Fields (Set)): sets or maps fields
  7. Update Recipient Status (Google Sheets): uses Google Sheets
  8. Generate Random Delay (Code): runs custom JavaScript code
  9. Pause Between Emails (Wait): pauses before continuing

Services it uses

Google SheetsOpenAI

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (9)

From the author

This n8n workflow demonstrates how to automate a large-scale personalized promotional email campaign, leveraging artificial intelligence to generate unique content for each recipient. Save time and increase the effectiveness of your marketing campaigns by…

Excerpt from Badr's description on n8n.io.

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

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.