Automated Email Sender with Batch Tracking and Scheduling

This n8n workflow automates the process of sending personalized emails to a list of contacts stored in Google Sheets, with built-in scheduling, record updates, and conditional logic. It begins with a scheduled trigger that initiates the workflow at a specified interval (every 6 hours). The workflow then retrieves contact emails that haven’t been sent yet, and loops through each contact individually. For each contact with a valid email address, it sends a personalized email via Gmail or other SMTP services. After sending, it updates the Google Sheet record to mark the email as sent, including details like timestamp and message ID. The workflow supports batch processing, ensuring controlled email dispatching, and includes notes for setup and customization. This setup is ideal for bulk outreach campaigns, newsletters, or follow-up email sequences, providing a scalable and automated solution for email marketing and communication management.