Email Validator

😫 The Pain Point

Your marketing list has 5000 emails. Before spending on email campaigns, you need to verify they’re real. Typos like “gmial.com” waste money. Invalid domains bounce.

🚀 Agentic Solution

A Multi-Level Email Validator that checks syntax and mail server existence.

Key Features:

• Syntax Check: Valid format (user@domain.com).
• Domain Check: Does the domain exist?
• MX Record Check: Does the domain accept email?

⚔️ Phase 1: Commander (Quick Fix)

For quick validation.

Prompt:

“I have an Excel emails.xlsx with column ‘Email’. Write a Python script using dnspython to:

1. Syntax Check: Validate email format with regex.
2. MX Check: Verify domain has MX records.
3. Classify: Valid, Invalid_Syntax, Invalid_Domain.
4. Output: Save with ‘Status’ column.

Print validation summary. Handle timeouts gracefully.”

Result: Clean email list with bad addresses flagged.

🏗️ Phase 2: Architect (Permanent Tool)

Engineering Prompt:

**Role:** Python Tool Developer
**Task:** Create an "Email Validator".

**Requirements:**
1.  **GUI:**
    *   Select Excel file.
    *   Column picker.
    *   Validation level: Syntax / +Domain / +MX.
    *   Progress bar.
    *   Export clean/invalid lists.

2.  **Logic:**
    *   Regex for syntax.
    *   DNS lookup for domain.
    *   Concurrent MX checks for speed.
    *   Cache domain results.

3.  **Deliverables:**
    *   `email_validator.py`
    *   `run.bat`, `run.sh`
    *   `requirements.txt`

🧠 Prompt Decoding

• MX Records: Mail eXchanger records indicate a domain can receive email.

🛠️ Instructions

1. Install: pip install dnspython
2. Copy Prompt → Run.