๐Ÿ“ฑ Send bulk email campaigns with Gmail/SMTP and Postgres reputation-safe timing

โšก 375 views ยท ๐Ÿ“ฑ Social Media & Email Marketing

Description

Overview

This workflow automates bulk email campaigns with built-in validation, deliverability protection, and smart send-time optimization.

It processes CSV leads, validates emails, enriches data, and schedules campaigns intelligently. Emails are sent using controlled inbox rotation, while engagement tracking and analytics continuously improve performance.


How It Works

  1. Campaign Input Receives campaign data and CSV leads via webhook.

  2. Lead Processing Extracts CSV data, splits leads, and validates email format.

  3. Domain & Quality Checks Verifies domains using MX records and filters invalid leads.

  4. Lead Enrichment Adds timezone, domain type, and engagement score for better targeting.

  5. Lead Storage Stores valid leads and separates invalid ones for tracking.

  6. Campaign Execution Scheduler fetches active campaigns and selects top leads.

  7. Send Optimization Calculates best send time per lead based on timezone and historical performance, while selecting inboxes within sending limits.

  8. Email Delivery Waits until optimal time and sends emails using selected inbox.

  9. Tracking & Logging Logs sent emails and updates inbox usage statistics.

  10. Event Tracking Captures opens, clicks, replies, and bounces via webhook.

  11. Performance Analytics Updates campaign stats and analyzes engagement trends.

  12. Continuous Optimization Updates send-time rules to improve future campaign performance.


Setup Instructions


Use Cases


Requirements


Notes

๐Ÿ”— Nodes Used

HTTP Request, Postgres, Webhook, Gmail, Schedule Trigger, Extract from File

๐Ÿ“ฅ Import

Download workflow.json and import into n8n: Workflow menu โ†’ Import from File

๐Ÿ“– Importing guide ยท ๐Ÿ”‘ Credential setup