Cold Email Campaign Automation

This automation streamlines outbound email campaigns by automating lead selection, personalized email generation, delivery tracking, and follow-up communication. A campaign configuration is first defined with details such as the campaign name, product information, sender identity, reply address, and follow-up interval. The workflow then retrieves lead records from Google Sheets and filters out contacts that have already received an email or have unsubscribed.

For each eligible lead, the automation dynamically generates a personalized subject line and email body using the lead's name, company, and industry. The personalized email is sent through Gmail, while the delivery timestamp and campaign details are automatically logged into a Google Sheets email log for future tracking and reporting.

A scheduled workflow runs daily to review previously contacted leads. If a lead has not replied within the configured follow-up period and no follow-up email has been sent, the automation automatically sends a personalized follow-up email. This ensures consistent outreach while minimizing manual effort and maintaining a complete communication history.