llm_email.py

# llm_email.py
def generate_email_templates(df):
    emails = []
    for _, row in df.iterrows():
        name = row.get("Company Name", "Your Company")
        tech = row.get("Tech Stack", "modern technologies")
        rating = row.get("Glassdoor Rating", "4.0")
        size = row.get("LinkedIn Employees", "100")
        score = row.get("Lead Score (0-100)", 50)

        email = f"""
Subject: Supercharge {name}'s Growth with Smart Automation 🚀

Hi Team {name},

I noticed you're using {tech} and have a team of about {size} employees — impressive! 
With a Glassdoor rating of {rating}, it's clear your team values excellence.

I'd love to show you how our AI tools can help your engineering and sales teams scale faster.

Let me know if you'd be open to a quick 15-min call next week?

Best,
[Your Name]
        """.strip()

        emails.append(email)
    
    return "\n\n---\n\n".join(emails)