📧 How to Use the Email Automation Script

This Python script automates sending personalized emails to leads based on their industry (Technology 💻 or Finance 💼). It customizes the subject and body of each email and sends them out using Gmail's SMTP server.

Key Features:

• Segmentation 🔍: The script filters leads by industry and personalizes the email content accordingly.
• Personalization ✍️: Each email is customized with the lead’s name, company, and industry-specific offers.
• Rate Limiting ⏱️: A delay between emails prevents Gmail from rate-limiting, ensuring emails are sent smoothly.
• Security 🔐: Email credentials are stored securely with environment variables, so no sensitive data is exposed.
• Logging 📋: The script logs every email sent and any errors to a file (email_log.txt), helping track the process.

How It Works:

1. CSV Input 📝: The script loads a CSV file (leads.csv) with the lead information (name, email, company, industry, etc.).
2. Segmentation 🎯: Leads are split into two groups: Technology 💻 and Finance 💼.
3. Sending Emails 📤: For each lead, an email is sent with a personalized subject and body.
4. Logging and Monitoring 🧾: The script logs the email sends and any errors for easy tracking.

import pandas as pd
import smtplib
import os
import time
from email.mime.text import MIMEText
from email.mime.multipart import MIMEMultipart
import logging

Set up logging

logging.basicConfig(filename='email_log.txt', [level=logging.INFO](<http://level=logging.info/>))

Function to send emails

def send_email(recipient, subject, body):
sender_email = os.getenv("SENDER_EMAIL")  # Use environment variable for security
password = os.getenv("EMAIL_PASSWORD")  # Use environment variable for security

msg = MIMEMultipart()
msg['From'] = sender_email
msg['To'] = recipient
msg['Subject'] = subject

msg.attach(MIMEText(body, 'plain'))

try:
    server = smtplib.SMTP('smtp.gmail.com', 587)
    server.starttls()
    server.login(sender_email, password)
    text = msg.as_string()
    server.sendmail(sender_email, recipient, text)
    logging.info(f"Email sent to {recipient}")
    print(f"Email sent to {recipient}")
except Exception as e:
    logging.error(f"Error sending email to {recipient}: {e}")
    print(f"Error: {e}")
finally:
    server.quit()